It seems this bug has existed for many years and has no definitive answer - or even useful workarounds if it is persistent. Here are my observations: I'm using Excel for Mac 2011. There is one particular spreadsheet in my database that is used daily and updated with a couple of cell changes and a run of a macro that updates just the S&P Index quote into one cell (same cell every time) with an internet call. The spreadsheet is 2.3MB in size. The spreadsheet functions perfectly for weeks. Then, with no different changes, it becomes impossible to save the file.
The error 'Not Enough Memory' pops up when the Save is attempted. Following that error, if the file is closed and reopened, it is also impossible to save it - even without any action made on the spreadsheet after being opened. The only way out of this is to restore an older version of the file from a backup copy, bring it up to date and Save it. This usually works (not always - sometimes I have to go back to a version many days prior to the error even though subsequent backed up versions may have worked when backed up). After this, the file works ok for a few more weeks - but then hits the same 'Not Enough Memory' error and the restore has to be done again. The error is not related to not being enough memory - either in RAM (usually over 1.5GB unused when Excel is active) or on disk. At the time the error occurs, other spreadsheets, some bigger than 2.3MB, function properly.
This site has suggested a procedure to use to get around the problem: I have used this process and repairing disk permissions and refreshing the Preferences plist files worked once. It no longer works. Any new ideas would be much appreciated. Please go to the Excel menu and choose About Excel. Be sure your version is 14.7.7.
BEST FIX - Flash Drive Says Not Enough Free Space but There Is Plenty. I buy a cable of some sort that will allow me to connect two computers and transfer the file from my work PC to my home Mac? Solutions to Not Enough Disk Space Error.
If it isn't then please install updates and then test again. Make sure your Mac has a working internet connection, then:.
Update Mac OS X. Open the App store and click on the Updates button. Install the updates. After, in any Office application go to the Help menu and choose Check for Updates to launch the AutoUpdate app.
Let AutoUpdate install updates and then restart your Mac. I am an unpaid volunteer and do not work for Microsoft.
'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. Sorry that I had to press the issue, but there are times when several different versions of Excel are current versions. In Office 2011 14.7.7 is the current and final version. There is some overlap when a new 2011 version comes out, so there could be two different current builds at any given moment, and you can legitimately call both of them the latest build. In Excel 2016 there can be up to 6 different versions, all 'the latest,' at any given moment. Anyway, the scenario you described has occasionally turned up in the forums.
It appears you have researched and tried deleting preferences, with past success but not current or lasting success. Unfortunately, there is a whole lot of possible causes of out of memory errors in macros. All I can suggest is to start with this list and rule them out one-by-one: I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.and here's an update to my issue. I have not been able to eliminate the bug on a file save attempt.
Now, with NO changes to either the spreadsheet or Excel - or the environment in which it runs, an 'Out of Memory' error message pops up when I attempt to open the file - after accepting the 'Enable Macros' message. What is even more peculiar is that after clicking this message, it pops up again 5 times, but then disappears and the file appears to have been loaded. Note that there were absolutely no changes to the file since the 'Not Enough Memory' appeared on a file save attempt - when the only way out of that issue was to 'Do Not Save' the file. Note also that these errors occur only on one specific file. All other Excel files, many with open, load and save correctly. Yet another update to the problem. Out of curiosity, I decided to open the bad file with Excel 2010 for Windows (although the file was originally created under Excel 2011 for Mac).
The file opened successfully; was modified and brought up to date and then saved. It did all this without any error messages. I then reopened the saved file with Excel 2011 for Mac and it has since operated successfully - without any error messages either on opening or when being saved. None of the macros were changed. Curiouser and curiouser.
What to do if you get an out of memory or not enough resources message Microsoft Excel users will sometimes get a message that says their computer is out of memory, enough system resources to display completely, cannot complete this task with available resources or Excel can not open workbook with available resources. Excel 2007-2016 users tend to see them more than Excel 2003 users. Microsoft re-wrote large portions of Excel when they released 2007. This re-write appears to have affected memory usage. The conclusion we reached from the much testing is that COM add-ins are the major cause of memory issues. COM add-ins sneak onto your PC without permission (or clearly asking). The two COM add-ins we have seen that cause memory issues are Adobe and Blue Tooth.
We have never seen a need for them in Excel. They should be removed immediately.
COM add-ins are compiled computer code that manages their own memory. Often at the expense of Excel, especially if they are badly written. Ususally you can run one COM add-in without issues.
Two is like walking on thin ice. Three or more - just wait for the crash. It will happen. VBA add-ins (the kind we write) are not compiled and are called Excel add-ins and do not cause memory issues. Excel manages memory for them.
We have had all of our add-ins open at one time and no memory issues. The following are steps one can take that may solve memory problems. It is also possible that none of these steps will solve.
Memory problems are often difficult to solve. We have tried to order the steps from easy to do to hard to do. And from inexpensive to expensive. The number one thing you can do: If you have any COM add-ins installed, un-install them unless they are absolutely required. COM add-ins are a special type of add-in written in machine language. They are often installed without explicit approval.
COM add-ins are often reported as causing memory problems (our add-ins are not COM add-ins). Two frequently mentioned as problems are Blue-Tooth and Adobe COM addins. To un-install COM add-ins:. If you are using Excel 2003, download our free and use it to un-install the COM add-ins. If you are using Excel 2007, click the round Office Button, Excel Options, Add-ins, change the dropdown box to COM add-ins and click Go. If you are using Excel 2010-2016, click File, Options, Add-ins, change the dropdown box to COM add-ins and click Go.
The easiest way to run out of memory and get the message 'Excel can not complete the task with available resources.' Is to have 1) Multiple Excel sessions open and 2) other applications open. Run only one Excel session. Many Excel users will open new Excel sessions each time a new workbook is opened via double clicking on a workbook link.
To see if you have multiple sessions open, press ALT-CTL-DELETE and check how any Excel applications are running. There should be just one running. Regarding other applications, it depends on what they are and how much memory they need before a problem happens. If a new Excel session opens each time you double click on a workbook, try unchecking the Excel Option 'Ignore other applications' if it is checked on the Options General tab. We have gotten reports that the 64 bit version of Office 2010 has memory problems if other Office program are open. We do not recommend using the 2010 64 bit version of Excel.
Very few users will see any benefit from it. The 64 bit version of Office 2013 and Office 265 runs fine. We run it often. Close Excel every 1-2 hours. Excel does not seem to release all memory when workbooks are closed. Ultimately a crash will occur. Only closing Excel will solve.
Some cases of out of memory or resources are caused by doing a copy and paste that is not valid. Instead of advising that one can not do such an action, Excel says either out of memory or out of resources. It can happen if one is trying to paste a selection containing hidden cells or has merged cells.
Try unhiding all rows and columns and then doing the copy and paste. Also try removing all formats first In Excel 97-2003 one would select Edit, Clear, Formats.
In Excel 2007-2010 we're not certain how to do (except by using the Spreadsheet Assistant) Lastly, if this happens, select only the used range and copy and paste it. Excel may think your worksheets are larger than you do! This can greatly consume memory.
Normally your scroll area controlled by the scroll bars is very small. However, sometimes Excel thinks there are cells well below your used range. One way is to check where Excel thinks the last cell is located. Do this by pressing CTRL+SHIFT+END.
If it well below your used range, then select all 'unused' columns in this range and delete them. Then select all unused rows in this range and delete them.
Then close and re-open Excel. Install the latest upgrades to your version of Office. Detailed steps are found on our page on. Do not shortcut the steps. Use the to first remove EXD files prior to doing a SP upgrade and prior to doing a repair is very important. Also doing a repair of Office after installing an SP upgrade is an essential step. If you have all the upgrades in place, do a repair of Office if you start getting memory or resource problems.
We have noticed problems tend to appear after a Microsoft Windows automatic update or critical patch is done. Most PCs are set to run such automatically and often the user does not know any change was made to his or her PC. We suspect the update is causing the problem.
Be sure to run the before repairing Office. Delete temp files on your PC. Use the free to do so. If you are using Google Desktop Search, un-install it. Google Desktop Search appears to be a memory hog and has been reported to interfere with Microsoft Excel.
Specifically, it installs a COM add-in that monitors every action in Excel so that it can index it. This obviously ties up a lot of memory and slows down Excel tremendously. The next suggestion advises how to remove COM addins.
Un-install any VBA add-ins you do not need. VBA add-ins are normally very passive and do not cause memory problems. We have 20-30 loaded all the time. Although our testing indicates VBA add-ins are not a major memory user, you should only install as add-ins those you need all the time. To un-install un-needed VBA add-ins:.
If you are using Excel 97-2003, select Tools and Add-ins. A dialog with the available add-ins will appear.
Uncheck the ones you do not need. If you are using Excel 2007, click the round Office Button, Excel Options, Add-ins, change the dropdown box to Excel add-ins and click Go.
If you are using Excel 2010, click File, Options, Add-ins, change the dropdown box to Excel add-ins and click Go. There is a very small chance that you have an un-needed add-in or workbook in your XLSTART folder. Such open automatically.Search for the folder XLSTART on your PC. It may be a hidden folder so you will have to set options to show hidden folders while searching. Some add-ins install themselves in this folder. Such addins are not listed in the above dialogs.
Remove any you files in XLSTART folder that you do not need (with Excel closed). Typically the folder should be empty or contain only Personal.XLS. See if you have an alternate startup folder and check its content, and remove anything you do not need (with Excel close). One program known to do this approach is called GoldMine, and its removal solved one user's memory problems. To find your alternate startup location:. If you are using Excel 97-2003, select Tools, Options, and the General tab. If you are using Excel 2007, click the round Office Button, Excel Options, Advanced, and go to the General section.
If you are using Excel 2010-2013, click File, Options, Advanced, and go to the General section. Delete your XLB file. It can become corrupt but cause no noticeable problems.
If corrupt it can consume lots of memory. Excel will recreate, but button customization will be lost. This is a file where Excel stores its toolbar settings.
To delete it, which is a free product we provide. There have been reports that doing this will solve problems.
Any special toolbar customization will be lost, but hopefully easy to add back. It is possible that your printer or its driver is causing the problem.
Several years ago HP printers were causing a memory problem with Excel. We do not know if HP fixed the problem and it may still be around or surfacing again. Change your default printer if you have other printers available. Do not use a system printer as your default if you can avoid it.
See if there is an update to your printer's driver. Another solution is to specify a different printer as your default, even if you do not have the one you are specifying.
This means you will have to change your printer when you need to print, which is a headache. Today we use a Canon laser G3 as our printer of choice and do not have memory problems. Back when we had problems with HP printers we switch to a Brothers laser and the problem went away. We have no plans of ever using a HP printer again. Extensive printing was one of the causes of memory problems in Excel 97-2000.
In some cases doing a lot of page setup changes either manually or via macros can cause problems. This was a definite problem back with Excel 97-2000.
Use of recorded macros that change print settings often change many settings that do not need to be changed. Optimize such code by eliminating what does not need changing. We suspect this problem is solved with Excel 2003 as we did 100 page setup changes from a recorded macro and memory usage did not change. Use of macros that do very extensive file creating, data manipulation, and graphing have been known to cause memory leak problems.
Such macros are ones that typically run for 30 minutes or longer. Minimizing the number of add-ins installed (especially COM add-ins) and closing all other applications can help. Closing and re-opening Excel after such extensive macro or add-in work is the best way to fix memory problems such intense work causes. Use of many large arrays in VBA can cause problems.
For example, ReDim Array1(10000, 10000) will cause an out of memory problem. Use of too many Public declared variables in VBA can cause problems as these stay in memory even when the application is done running.
Public arrays are a double sin. If you are using Outlook 2007/13, there have been reports of memory and resource problems if it is running at the same time as Excel 2007/13.
We do not use Outlook and thus can not confirm. Try keeping Outlook 2007/13 closed when using Excel macros or add-ins. A side benefit is you will focus on your Excel work. Get a new video card with lots of video memory. Excel 2007-2013 charting system was re-written and may be using far more graphic resources than past versions. We do not have any recommendations on which card to get.
If your PC does not have a video card and you can install one, that will free up memory. Especially if you are using Windows XP and already have 4 GB of memory installed. Changing your resolution to a lower setting will also help. If you do have a video card, you consider disabling the on board video to insure that memory does not get allocated to it. Making changes to BIOS settings can have adverse effects on the way a computer works. Use caution when performing BIOS modifications. Use of Excel workbooks created on a Mac machine can cause problems.
They are supposed to be in interchangeable, but we have had Mac users send up workbooks that will crash our computers. Try not to exchange files between PC and Macs! Close Excel once every hour if you are doing a lot of editing or creating lots of charts. If you have Track Changes turned on in Excel, turn off Track Changes as it uses a fair amount of memory.
The default is Off. Turn off AutoRecovery, as this takes another hunk of Excel memory. However, have a backup if you do. To turn off AuoRecovery:.
Excel 2003: Tools, Options, Save tab. Uncheck AutoRecovery. Excel 2007: Office button, Excel Options, Save. Uncheck Auto Recovery.
Excel 2010-2013: File,Options, Save. Uncheck Auto Recovery Always open Excel as your first application. This gives it first rights to memory (or so we have heard). If you close Excel, close other applications and then re-open Excel to allow it first memory rights.
Always open Excel before opening Outlook. If you workbooks had a lot of conditional formats this can cause problems. Minimize use of condition formats whenever possible. There are reports of a bug in Excel 2007 where just copying and pasting conditionally formatted cells duplicates the formats over and over. Too many conditional formats can also cause slow workbook opening and slow response in Excel. Minimize the number of charts in your open workbooks.
Charts can cause a significant demand on memory. In Excel 97-2003, you can select Tools, Options, View, and click on the option under Objects to 'Show placeholders' to help on memory. If your workbooks have a lot of formulas, see if there is a way to minimize formulas. Users with workbooks with tons of formulas often report memory problems. For example, if you create a lot of Vlookup formulas, consider doing a copy, paste special values to convert the results to values and eliminate the lookup. Avoid Array formula s (ones entered by pressing CTL-Enter) If your workbooks have links to other workbooks, Excel must open and read those workbooks in order to evaluate your formulas. Look for ways to avoid workbook links.
If you have a lot of Windows applications appearing in your system tray, remove any system tray application that are not essential. Each application in the system tray is running and using resources all the time. We try to minimize the number we have. Their removal can often be very difficult and there is no one common way to remove them.
Press ALT-CTL-Delete, go to the Processes tab and click twice on CPU to sort by memory use in descending order. The total CPU use is shown at the bottom. A level below 50% should be a cause of concern. Monitor the results for awhile to see what is running and consuming resources. Then do a internet search on the application name. Some will be routine Windows programs.
Some will be anti-virus programs. Others will be candidates for removal. Problems in your application data folder for Excel can be the cause. The folder is typically 'c: documents and settings%username% application data microsoft excel'.
This is a hidden folder, so set your Explorer options to show hidden folders. After backing up, rename or delete this folder and its subfolders. Reboot the machine and open Excel. Excel will recreate the folder and needed contents. Run the following two commands (change the number 11 (Excel 2003) to 12 for Excel 2007, 14 for Excel 2010 and 15 Excel 2013, and 16 for Excel 2016 ) from the Run box to reset the Excel registry entries: You will need to get the full path to your excel file to do so (The ones below are for our PCs):.
'C: Program Files Microsoft Office OFFICE11 excel.exe' /unregserver. 'C: Program Files Microsoft Office OFFICE11 excel.exe' /regserver These commands remove most of the Excel registry entries and then resets them. However, they do leave some residual settings.
A more extensive way to clean the registry is to rename the Excel registry key and let Excel recreate it. It depends on the version of Excel. First, close Excel.
Then do Run, Regedit and go to the Excel registry key. It will be 'HKEYCURRENTUSER Software Microsoft Office%versionnumber% Excel' where%versionnumber% is 11 for Excel 2003, 12 for Excel 2007, 14 for Excel 2010 and 15 for Excel 2013. Rename this to OldExcel (this will back it up). Then re-open Excel. Excel will rebuild the registry entry. You will need to manually install any needed add-ins.
Lastly, your PC may not have enough memory. Lots of the cheaper PCs one can buy come with only 1 or 2 GB of memory. This is enough for browsing the internet and not much more.
If you are running Windows XP or Windows 7 32 bit, then you should have 4 GB of memory. More doesn't help we have been told. If you have Windows 7 or windows 10, 64 bit, then buy lots of memory. We have 8 GB on our machines. They run fast! If you find other solutions that work, please let us know.