"Not enough Memory"

[RichardLW]

I have a workbook that I've used for about 17 years through different versions of Excel, first on PC's, then on my Mac. Currently on Office 2011 (14.2.5) (since the day it came out plus the update). I re-did it in Nov 2010 when the Office 2011 came out. My MacBook Pro is a 2.66 Core duo with 8 GB of ram. The workbook is only 940 KB, and has only 11 sheets, one with a link to one another sheet, and another with multiple links to different sheet.

Ten days ago it started giving me the "Not enough Memory" error when trying to save or autosave. I tried restarting excel, rebooting, etc. Finally changed the name and restored the sheet from my time capsule. It worked fine for a few days and then repeated the problem. Again I restored the sheet, changed the name, and it worked fine for two days. Then the message again.

It can't be the file size. I have a similar sheet for other products that is 5.5MB and works fine. It gives me the message whether or not I have the linked files open.

 

[Andrew Poulsom]

I suggst you Google for 'not enough memory excel 2011'. This is the first hit I got:

Excel "Not enough memory" - Microsoft Community

 

[RichardLW]

That is what I did first. Most topics are on windows machines. Not Macs. I followed mac leads to check and repair disk, restored, and got the same error.

Is there any way to find where the error is in Excel?

 

[Andrew Poulsom]

Sorry, I don't know.