Excel (There isn't enough memory to complete this action)
Try switching off the following this helps our users when we see this issue, esp when using many sheets at once.
For Office 2013 - Advanced > General > Tick the option - Ignore other applications that use Dynamic Data Exchange (DDE)
-
Proposed as answer by
netgeke
Monday, August 03, 2015 6:00 PM
December 30th, 2014 3:48pm
Hi,
Everytime multiple Excel spreadsheets are open we keep getting the error message saying:
There isn't enough memory to complete this action.
Try using less data or closing other applications.
To increase memory availability, consider:
- Using a 64-bit version of Microsoft Excel.
- Adding memory to your device
I have tried to increase the memory to 8GB and re-installed to 64-bit version but the application keeps doing the same thing. It freezes occasionally, blank screen appears.
What can i do to resolve this?
December 30th, 2014 6:35pm
Try switching off the following this helps our users when we see this issue, esp when using many sheets at once.
For Office 2013 - Advanced > General > Tick the option - Ignore other applications that use Dynamic Data Exchange (DDE)
December 30th, 2014 6:48pm
Thanks for the suggestion, I tried that before.
I have tried so many different types of solutions that i cant even remember which ones i have done.
December 30th, 2014 8:14pm
Hello Dan Maia,
Sometimes an error message is accurate to the point.
1. Is this occurring on multiple computers or just one? (You wrote 'We' ...")
2. What is the total RAM and operating system on this computer / these computers?
3. After a fresh boot, do you still get this message when using Excel spreadsheets ONLY?
4. Did this just happen now with spreadsheets successfully used over a period of time?
December 30th, 2014 9:23pm
Hi George:
1. Is this occurring on multiple computers or just one? (You wrote 'We' ...") -
Just one machine
2. What is the total RAM and operating system on this computer / these computers? -
8GB Ram using Windows 7
3. After a fresh boot, do you still get this message when using Excel spreadsheets ONLY? -
Yes after a fresh boot only happens with Excel
4. Did this just happen now with spreadsheets successfully used over a period of time? -
Yes thats correct
Hi Robbery:
You may be right about the formula calculation but these are spreadsheets that have been modified over
time so we cant start from fresh. I tried to increase the virtual memory but still no joy.
December 31st, 2014 11:52am
Hi again,
1. Open Windows Task Manager (Ctrl-Shift-Esc). Select tab Performance. Check Physical memory, first without Excel running, then with Excel and no error, then with Excel and error.
2. Select Processes tab and sort on Memory. Is Excel at top? How much? An empty Excel takes about 36 MBytes RAM on my machine.
3. Can you successfully run this spreadsheet on another machine? If so, I'd do an
offline virus scan on the problematic machine. I have instructions if you need it.
December 31st, 2014 12:11pm
Do you mean TICK or UNTICK to try and switch off? The default is a blank TICK block.
If I TICK the option I cannot open any XLSX file by double clicking on the file.I can only open the files by using the File>Open function from within Excel.
January 4th, 2015 11:57am
I'm having this same problem and it just started happening.
I tried <g class="gr_ gr_8 gr-alert gr_gramm Punctuation only-ins replaceWithoutSep" data-gr-id="8" id="8">rebooting</g> but the issue persists even when trying to create a new spreadsheet.
I'm running Windows 8.1 64-bit and 64-bit Excel with 16GB in my machine.
And now I just went to check the version/build of Excel and the problem has gone away.. WTF?
Rich
January 11th, 2015 5:53am
I only have 8GB. But good to know more memory won't fix it. Seems like mine started around end of jan 2015. Trying repair.
Never used to happen. Opened tons of sheets at one time.
February 19th, 2015 10:25am
Same problem with 32-bit version. Anyone found a solution yet?
April 7th, 2015 12:28pm
I have a desktop computer i7 with 8GB of RAM 64-Bit that has given this problem ever since I have used Excel 2013. I also have a notebook i5 at home with 6GB Ram 64-Bit that also exhibits the same problem. I am opening a NEW instance of Excel and it won't
open a small timesheet spreadsheet!
I also have LOTS of problems with Excel hanging ever since I upgraded (about 2 years ago!). 2013 is definitely a bad year for Excel - I can't believe that Microsoft is not aware of this problem!
"Pissed off with Excel"
May 3rd, 2015 3:40am
Same here!! Any fixes for this Microsoft?
May 27th, 2015 4:57am
Same here!! Any fixes for this Microsoft?
We have the same issue, with several users/PC's. Windows 8.0 office 2013 32-bit.
June 18th, 2015 8:18am
I have the same problem here! any fix?
June 29th, 2015 12:15pm
THANK YOU VERY MUCH, your solution immediately resolved the problem that I was facing over a year ago.
June 29th, 2015 4:34pm
Same issue started once I went to excel 2013. Happens regardless of which workbooks are open or even number of sheets open. Seems more related to time system is up and running. Sometimes closing excel and reopening helps for a while but reboot
will be required to get it to work right for longer than an hour or so.
Intel I5 processor, 16gb RAM (so that is not the issue), windows 7, excel 2013 32bit. It seems just to be a software issue in need of a fix.
Come on MS, figure out a patch.
July 24th, 2015 4:01pm
Excel 32-bit is limited to 2GB of memory no matter how much you have in your machine.
July 28th, 2015 2:54pm
Hi Lei23, what was the solution ?
August 20th, 2015 7:37am