There isnt enough memory to complete this task

[methody]

Hi there I am having a major problem which has cropped up all of a sudden. (I use Office 365 - 64 bit. I am using a good Dell desktop which does not appear to be coming close to any memory limits)

I do use some quite large Excel files but was not having a problem. When now I try to open Excel (any file) I am getting a message "There isnt enough memory to complete this action"

I have uninstalled and reinstall office. I have even upgraded to Windows 11. I now basically cannot get access to Excel at all.

Any help appreciated

Alan

 

[rollis13]

Does your file contain macros ? If so, is there a macro in AutoOpen ? maybe it's doing some 'dirty' work.

 

[methody]

No. No macros. Now for every single Excel file when I go to open it I am getting that message.

 

[Logit]

The following may help. DO NOT RUN THIS ON THE ORIGINAL FILE. Try on a COPY OF THE FILE FIRST.

You can run this macro on your workbook and it will clear all the stray stuff from outside the data range on each sheet.

Select Code  copy to clipboard
Sub LipoSuction()
'JBeaucaire (8/3/2009)
Dim LR As Long, LC As Long
Dim ws As Worksheet

For Each ws In Worksheets
    LR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row + 1
    LC = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column + 1

    'Clear everything below column A last cell and row 1 last cell
        ws.Range(ws.Cells(1, LC), ws.Cells(ws.Rows.Count, ws.Columns.Count)).Clear
        ws.Range(ws.Cells(LR, 1), ws.Cells(ws.Rows.Count, ws.Columns.Count)).Clear
Next ws

End Sub

 

[dave3009]

What happens if you open Excel in 'Safe Mode'?

Instruction on how to do that from Microsoft.

If opening Excel on its own seems to work fine, then try to open a workbook in safe mode. If the workbook opens fine then take the functionality for a test spin, see that it calculates as expect and so on. Let us know how this goes.