Fixed: Excel Not Enough Memory

In this article, you will be shown the symptoms and causes of Excel memory error; how to avoid seeing the error message “Excel not enough memory” and how to fix your corrupt Excel with Stellar File Repair.

Dec 03,2019 • Filed to: Recover & Repair Files • Proven solutions

0
Q: My Excel Shows “Not Enough Memory”
“Hello. Whenever I click on my Excel, I keep getting this message: ‘Not enough memory to run Microsoft Excel. Please close other applications and try again’. I have done that but the error persists. Please, what do I do?!”

fix-excel-not-enough-memory

SUMMARY

Microsoft Excel tends to experience memory issues more often than you think, the version of Microsoft notwithstanding. So, do not be shocked when you see the memory error message on your screen while you are trying to work with, or save, files to your Excel.

This article will show you the symptoms of this message and the different causes (to prevent the error from occurring in the future). Also, you will be given various solutions to try in getting rid of the error message, as well as comprehensive steps on how to fix any corrupt Excel file that may result from this error, using the Stellar File Repair software.

CONTENT:

Part 1: Excel Not Enough Memory Symptoms and Causes

For computer users, you may encounter any of the following error messages while working with a file on Microsoft Excel:

If you have encountered any of these messages, then it’s time to get full information on the causes and solutions. You may think you have it all figured out from the instructions in the error messages but these don’t always reveal the real cause of the problem because of their generic nature.

But if you keep seeing the error while performing any of the functions below, then it is time to figure out what is happening within your file:

The causes of Excel Not Enough Memory error include:

  1. Trying to Copy Formulas over A Large Area: If your Excel file is large or contains many features, your memory resources may just be running low. Thus, you are most likely to receive these error messages when trying to copy or fill formulas into a large area on your worksheet. The Excel versions (Excel 2007, 2010, 2013 and so on) 32-bit is limited because of the setting to 2GB (or 32,760 source cells in cases where you use a smart fill option) so trying to work with large sections of the worksheet will only trigger this error.
  2. Problems with Calculations: The error might be related to a recalculation of formulas when you insert rows and columns, copy and paste or perform calculations. For instance, say your spreadsheet contains a million formulas on a sheet, then you insert another column. Of course, Excel will have to recalculate all the formulas in your spreadsheet to make adjustments for the newly inserted column. In this case, you may receive the error message “out of resources” depending on how complex your spreadsheet is, the bit capacity of your Excel, what formulas are involved and how your spreadsheet is built.
  3. Other Elements of Spreadsheet: There are other areas of Spreadsheet that can cause Excel memory errors such as complex PivotTables, exicess shapes, macros, complex charts with many data points and so on. Thus, your computer may have enough space in its local memory but excel will show “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space”. Issues like this are basically related to the security settings innate in Excel 2013 or Excel 2016.
  4. Other Applications: Another cause of the excel memory error may be that the other applications on your PC are taking up the bulk of your ciomputer memory thereby leaving not enough memory for Excel to work with.

Part 2: How You Can Avoid Seeing This Error Message

Here are some actions to take to can avoid seeing the error message “Excel Not Enough Memory”:

If you don’t mind the option of “Recalculate workbook before saving” getting enabled as soon as manual calculation is turned on, then use this faster method to recalculate your worksheets manually:


Part 3: How to Repair Excel Corrupted/Damaged by Various Reasons

Different software are available for repairing Microsoft Excel but we recommend the highly effective Stellar File Repair software. Stellar File Repair is a toolkit that resolves all kinds of file corruption challenges that arise in Microsoft Office application files and restores XLS/XLSX file data. This tool repairs corrupt or damaged files on Excel, Word, and PowerPoint. In addition, it repairs corrupt or damaged Zip files.

Its features for repairing Excel include: recovering tables, chart sheets, formula, etc; preserving cell formatting and worksheet properties, fixing corruptions as unreadable content, unrecognizable format and so on. Stellar File Repair works for Microsoft Excel 2000, 2003, 2007, 2010, 2013 and 2016.

Use the following simple steps to repair your corrupted or damaged Excel and also, recover your data:

  1. First, download and install Stellar File Repair, then launch the software.
  2. repair-corrupt-excel-1

  3. On the home screen, choose the corrupt Excel file you wish to repair by clicking “Browse”. If you don’t know the path to locate the file on your system, just select “Search” to find it
  4. repair-corrupt-excel-2

  5. Select “Repair” to start the repair process
  6. repair-corrupt-excel-3

  7. After scanning, you will see a display of all the recoverable items on the left-hand panel of the software’s interface. Double-click any item here to preview it.
  8. repair-corrupt-excel-4

  9. If you are satisfied with the result, select the “Save File” option from the main menu to save the file that has been repaired.
  10. repair-corrupt-excel-5

  11. You will be prompted to provide the destination you desire to save the file, select “OK”
  12. Afterward, an appropriate message to save the work will pop up on the screen.

Part 4: Other Common Excel Issues You May Encounter

Below are some of the common errors you may encounter as you use Excel, in addition to the already-discussed Excel memory error:

  1. “There was a problem connecting to the server Excel” error: This error message shows up when Excel and Windows SharePoint Services prevent spreadsheet from getting correctly imported into Windows SharePoint. You can fix this problem by creating a new list which is based on your Excel workbook, changing the Site Settings, using a ULS Viewer downloaded from Microsoft’s official website.
  2. “There’s a problem with this formula”: This error is usually experienced in some Windows ten by users on their Excel. When trying to use a formula to make several different calculations, this error may prevent the function from happening. To fix this error, you can: make use of system separators, check the regional settings of your system and change the correct spelling settings.
  3. “Excel Online won’t calculate/won’t open”: The large worksheets (big grids of rows and columns) and different parts that compose the Excel application slow down calculation and analysis of data tasks. Therefore, this error is related to these tasks, as well as the size of the file you are using. Other factors at play include multithreaded calculation and the design and build of your worksheet. You can fix the problems with your Excel Online using these solutions: examine the formulas you use, open your workbook in Excel latest version, calculate across different workbooks, as well as limit the use of volatile functions.

Amy Dennis

staff Editor

0 Comment(s)
Home | Resources | Recover & Repair Files | Fixed: Excel Not Enough Memory