How to Fix the Out of Memory Error in Excel? Here Are Solutions!

When you open or work with an Excel file, you may encounter the out of memory error Excel or Excel not enough memory error. The full message may be as follows:

• Not enough memory.
• Out of Memory.
• Not enough memory to run Microsoft Excel. Please close other applications and try again.
• 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.

Of course, there are other variants of the Excel not enough memory error or the out of memory error Excel. When you encounter these Excel memory errors, you can try the following ways to solve them.

MiniTool Partition Wizard DemoClick to Download100%Clean & Safe

Way 1. Close Other Apps

Are you opening other apps when dealing with Excel files? If so, I recommend you close them to save the memory resources. In addition, many third-party applications like Tuneup Utilities, Abby FineReader, Kaspersky Anti Virus, etc. may also cause the problem.

Here is how to close these unnecessary apps:

1. Press the Windows logo key + X and then select Task Manager from the menu.
2. On the Processes tab, right-click on the unnecessary apps and select End task from the menu.

If you want to find more incompatible software, you can try performing a clean boot.

Way 2. Update Office

Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities. Therefore, if the Excel not enough memory issue occurs, Microsoft may fix it in the next update. Here is how to update Office:

1. Open any Office app, such as Word, and create a new document.
2. Go to File > Account.
3. Under Product Information, choose Update Options > Update Now.

Error 1935 When Installing Office – 6 Solutions!

This post tells you why the MS Office install error 1935 occurs and offers 6 solutions to this issue.

Read More

Way 3. Open Excel in Safe Mode

Add-ons may cause the out of memory error Excel. Opening Excel in safe mode can disable any add-ons. Here is how to open Excel in safe mode:

1. Press the Windows logo key + R to open the Run box.
2. In the box, type “excel /safe” and click OK to open Excel in safe mode.
3. Then, open the Excel file to deal with it to see if the Excel not enough memory error disappears.

Way 4. Disable Add-Ons

You can also disable add-ons manually. Here is the guide:

1. Open the Excel file and go to File > Options > Add-ins.
2. Under Active Application Add-ins, you can see what add-ins are active.
3. Expand the Manage menu to select an add-in category. For example, in my case, my active add-in belongs to COM Add-ins. So, I select this category and then click Go.
4. On the pop-up window, uncheck the add-in and click OK to disable it. You can disable these add-ins one by one to find what add-in cause the out of memory error Excel.

How to Fix Error Code 0-2031 in Office 365? [4 Solutions]

What to do if you encounter error code 0-2031 in Office 365 when trying to install Office 365. And this post shows you how to fix it.

Read More

Way 5. Split Large Excel Files into Small Ones

If you have a lot of data in your spreadsheet, Excel may be unable to handle it, causing the Excel memory error. Then, you just need to split the large Excel file into multiple small files and then work with them.

Way 6. Turn Off Auto Calculation in Excel

If your spreadsheet contains formulas, every time you make a change, Excel will calculate the data once. This may cause the Excel not enough memory error. Therefore, you can turn off the auto calculation in Excel to solve the issue. Here is the guide:

1. Open the Excel file and click the Formulas tab.
2. Click Calculation Options and select Manual. Your formulas will stop auto-calculating.

Way 7. Use the 64-bit Version of Excel

If you’re using the 32-bit version of Excel, the RAM usage of Excel will be limited to 2GB. Using the 64-bit version removes this limit. Therefore, uninstalling the 32-bit Excel and installing the 64-bit Excel can solve the Excel not enough memory issue.

Way 8. Increase RAM

If your memory is not enough, the out of memory error Excel will also happen. Then, you can increase the virtual memory or upgrade the RAM to solve it.

Bottom Line

Have you gotten the Excel not enough memory error? This post offers you 7 solutions. You can have a try.