Excel Out of Memory: 5 Quick Tips to Fix It For Good

Removing the macros from your Excel files can repair memory errors

by Teodor Nechita
Teodor Nechita
Teodor Nechita
Software Managing Editor
Eager to help those in need, Teodor writes articles daily on subjects regarding Windows, Xbox, and all things tech-related. When not working, you may usually find him either... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • No one who is using Excel on a daily basis wouldn't want memory errors to occur. 
  • However, this may happen from time to time so updating your Excel app can solve the issue. 
  • You might consider your antivirus program responsible for this scenario as well.
  • If nothing else works, you can try to disable and remove macros or add-ins from your files.
excel-insufficient-memory
XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

If you work in an organization, you most probably have the latest version of the Microsoft Office suite or Office 365 installed on your PC. Even if you don’t, it’s very unlikely that you have never heard of Microsoft Excel before.

However, this doesn’t make Excel immune to occasional bugs. Such would be the case with an error message users have been reporting, which looks something like this: Out of Memory. Not enough System Resources to Display Completely.

Why does Excel say out of memory?

There is not a single cause for this Excel message to appear, so you should consider a number of reasons. For example, the error may occur because you’re running other consuming apps in the background

Other factors that generate Excel out-of-memory issues are added macros or add-ins included in your sheets.

How do you clear memory in Excel?

The most used and easy solution to clear the memory in Excel is to erase its cache data. In order to do so, you should use the Microsoft Office Upload Center.

You can simply go to Settings and then look for the Delete files from the Office Document Cache when they are closed option. Tick the option and press Delete cached files.

How do I fix Excel not enough memory?

In this article

✅ Pre-checks: Check the contents of the spreadsheet

These are the main things that cause the out-of-memory error messages:

  • Inserting a row or column
  • Performing calculations
  • Copy and pasting
  • Sorting
  • Opening or closing the workbook
  • Running VBA

If you are doing any of the actions mentioned above and you receive the error, check what exactly is wrong. If that is the case, try doing the following:

  1. Recheck the formulas
  2. Recheck the calculations
  3. Avoid using excess shapes
  4. Avoid using complex PivotTables
  5. Try not to use macros and complex charts with many data points

1. Check your Excel Add-ins

If you believe an Excel add-in is responsible for Excel out of memory error, try disabling it and then check if the error appears again. Check the steps below for the support.

1. Click on the File option.

excel file menu

2. Go to Options.

not-enough-disk-space-excel

3. Select Add-ins.

excel-insufficient-memory

4. Click the Go button.

Expert tip:

SPONSORED

Some PC issues are hard to tackle, especially when it comes to corrupted repositories or missing Windows files. If you are having troubles fixing an error, your system may be partially broken.
We recommend installing Restoro, a tool that will scan your machine and identify what the fault is.
Click here to download and start repairing.

5. Select the add-ins you want to disable or remove.

6. Uncheck the box in front of the respective add-in.

7. Click OK and Save.

2. Verify Excel or install the latest updates

  1. Right-click the Start button
  2. Select Apps and Features on the pop-up menu.
  3. Select Microsoft Excel, and select Modify

Depending on whether your copy of Office is Click-to-run or MSI-based install, the next steps will vary a little.

2.1. Click-to-run

A window called How would you like to repair your Office Programs will appear

office 365 not enough system resources to display completely repair
  1. Select Online Repair
  2. Choose Repair to make sure everything gets fixed
    • The Quick Repair option is faster but it only detects and then replaces corrupted files

2.2. MSI-based

  1. In Change your installation, select Repair
  2. Click Continue
  3. Follow the given instruction to complete the process

3. Disable your Antivirus

Antivirus software will usually run in the background scanning your Excel file as you make it. This will usually make Excel run out of memory and thus trigger the error message.

Disable your antivirus program and see if Excel still encounters this error. Remember that each antivirus program is disabled in a different way, so check the documentation on the developer’s website for more info.

4. Use the 64-bit version of Excel

The 32-bit version of Microsoft Excel has a is 2 GB limitation. So, if the processes require more than 2 GB, Microsoft excel will run out of memory and the error message will appear.

Moving to the Microsoft Excel 64-bit version provides more space and will thus solve any memory-related issues you may have with the application.

5. Completely reinstall Microsoft Excel

Sometimes we have no choice but to start from scratch. Such would be the case if all the above-mentioned solutions fail to solve your problem.

  1. Remove your old Microsoft Office completely
  2. Go to the Microsoft Office product page
  3. Buy the Office package of your choice
  4. Log in using your Microsoft account credentials
  5. Select Install Now to save the installation file on your PC
  6. Double-click on the downloaded file and follow the on-screen instructions

Did our guide help you in getting rid of the memory-related error in Excel? Let us know in the comments section below.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: