sodcalculator

10 Tech How-To

Excel Not Enough Memory Error: Fixes That Work

Guide 10-55085 · Updated · Step by step

If you see “Not enough memory” when opening or working in Excel on Windows, the fix is usually closing other programs, disabling add-ins, or repairing the Office installation—not buying more RAM. This error is often caused by a single large file, a conflicting add-in, or a corrupted Excel state, and it can be resolved in minutes with the steps below.

Why Excel Shows “Not Enough Memory”

Excel is a 32-bit or 64-bit application. The 32-bit version, which is still common, can only use about 2 GB of memory (RAM) by default, even if your PC has 16 GB. When a workbook, add-in, or many open workbooks push Excel past that limit, Windows displays the “Not enough memory” error. On 64-bit Excel, the limit is much higher, but the error can still occur if your system is low on RAM or if a specific file has become corrupted.

Another common trigger is a poorly designed add-in or a macro that leaks memory. Excel also reserves memory for every open workbook, so having many files open at once can exhaust the available space. In some cases, the error appears even with a small file because of a temporary glitch in Excel’s own settings.

Step-by-Step Fixes for the Error

Try these fixes in order, from simplest to most involved:

  1. Close other programs and restart Excel. Press Ctrl+Shift+Esc to open Task Manager, look at the Memory column, and close any programs using a lot of RAM. Then fully quit Excel (check the system tray for a lingering Excel icon) and reopen your file.
  2. Open Excel in Safe Mode. Press Windows+R, type excel /safe, and press Enter. If the file opens without the error, an add-in is the culprit. Go to File > Options > Add-ins, select “COM Add-ins” at the bottom, click Go, and uncheck all add-ins. Restart Excel normally.
  3. Disable Hardware Graphics Acceleration. Go to File > Options   Advanced, scroll to the Display section, and check “Disable hardware graphics acceleration.” This helps if the error appears when scrolling or zooming.
  4. Repair Office. Open Control Panel > Programs and Features, select Microsoft Office, and click Change. Choose Quick Repair first; if that fails, try Online Repair. This fixes corrupted installation files.
  5. Check for updates. Go to File > Account > Update Options > Update Now to install the latest Excel patches, which often fix memory-related bugs.
  6. Convert the file to .xlsx or .xlsb. If the file is an older .xls format, save a copy as .xlsx (or .xlsb for very large files) via File > Save As. The newer formats use memory more efficiently.

How to Prevent the Error in the Future

Once you’ve cleared the error, adopt these habits to avoid it recurring:

  • Keep only essential add-ins enabled. Each add-in consumes memory even when idle.
  • Close workbooks you aren’t using. Excel keeps every open file in memory.
  • Avoid formatting entire columns or rows. Formatting A1:XFD1048576 (the whole sheet) can eat gigabytes of RAM. Instead, format only the used range.
  • Break up huge workbooks. If a file has hundreds of thousands of formulas, consider splitting it into smaller files or using Power Query to handle data externally.
  • Use 64-bit Excel if you have a 64-bit Windows and regularly work with large files. You can check your Excel version under File > Account > About Excel. If you have 32-bit, you can install the 64-bit version from your Office account, but note that some older add-ins may not work.

What to Do If the File Itself Is the Problem

If the error only happens with one specific workbook, the file may be corrupted or contain a memory-hogging element. Try these steps:

  1. Copy the data to a new workbook. Open a blank workbook, go to Data > Get Data > From File > From Excel Workbook, and import the problem file. This often bypasses corrupted parts.
  2. Delete unused sheets and named ranges. Right-click any sheet tab and choose Delete. Go to Formulas > Name Manager and remove names you don’t need.
  3. Remove volatile formulas. Functions like OFFSET, INDIRECT, and NOW() recalculate constantly and can slow Excel. Replace them with static values where possible.
  4. Check for hidden sheets. Right-click any visible sheet tab and choose Unhide to see if there are hidden sheets with large data. Unhide and delete them if they’re not needed.

When the Error Is Actually a Windows Problem

Sometimes Excel is just the messenger. If your entire system is low on memory, you’ll see the error in Excel first because it’s a large application. Check your overall RAM usage:

  • Open Task Manager (Ctrl+Shift+Esc) and look at the Performance tab. If “Memory” is above 90%, you have too many programs running.
  • Restart your PC to clear background processes that accumulate over time.
  • If you have less than 8 GB of RAM, consider closing browser tabs (they are notorious memory hogs) or upgrading your RAM if possible.

If the error appears in every application, not just Excel, then the problem is system-wide, and you should focus on reducing startup programs (Task Manager > Startup) and updating your graphics drivers, which can sometimes leak memory.

Frequently Asked Questions

Does the error mean I need more RAM?

Not necessarily. Most of the time, the error is due to Excel’s 32-bit limit or a specific add-in, not your computer’s total RAM. Try the safe mode and add-in fixes first. If you have less than 4 GB of RAM, upgrading could help, but it’s not the first thing to try.

Why does Excel say “Not enough memory” even though I have 16 GB?

Because the 32-bit version of Excel can only use about 2 GB of RAM, regardless of how much your system has. If you have 64-bit Windows, install the 64-bit version of Office to access more memory. You can check your version under File > Account > About Excel.

Will disabling add-ins delete my data?

No. Disabling an add-in only prevents it from loading; it doesn’t remove any data or settings. You can re-enable it later if needed. Some add-ins, like Solver or Analysis ToolPak, are built-in and safe to disable temporarily.

Can a single large file cause the error?

Yes. A workbook with many complex formulas, large pivot caches, or millions of cells can exceed Excel’s memory limit. Try splitting the data into multiple files, or use Power Pivot (if available) to work with large datasets without loading them entirely into memory.

What is the difference between Quick Repair and Online Repair?

Quick Repair fixes common issues like corrupted files in the Office installation without downloading anything. Online Repair downloads fresh installation files and is more thorough, but it takes longer and requires a stable internet connection. Start with Quick Repair.

Will converting to .xlsb really help?

Yes, .xlsb (Excel Binary Workbook) saves files in a binary format that loads faster and uses less memory than .xlsx, especially for large files. It’s a good option if you have a workbook that’s close to the memory limit.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →