Excel 'Not Enough Memory' Error: Causes and Fixes

Tech & Gaming
1

The “Not enough memory to complete this action” error in Excel is misleading – it often has nothing to do with how much RAM your PC has. Here’s what’s actually causing it and the fixes that work.

Why the error message is misleading

Excel’s memory model is complex. The error can appear because:

  • Excel’s internal memory allocation for a specific operation failed
  • The workbook has too many conditional formatting rules or named ranges
  • You’re using a 32-bit version of Excel, which is limited to about 2GB of addressable memory regardless of your system RAM
  • Add-ins are consuming Excel’s memory allocation
  • The file is corrupt
  • COM object caching issues in the session

A PC with 32GB of RAM can still show this error in Excel if the root cause is one of the above.

Fix 1: Use 64-bit Excel

If you’re on 32-bit Excel, it can only address ~2GB of memory no matter how much RAM your system has. For large workbooks with extensive data, formulas, or charts, 64-bit Excel is necessary.

Check: File > Account > About Excel – the title bar shows either 32-bit or 64-bit. If 32-bit, reinstall Office and select the 64-bit version during setup. Microsoft 365 defaults to 64-bit now but older installations often installed 32-bit.

Fix 2: Reduce conditional formatting

Excessive conditional formatting is one of the most common hidden causes. Workbooks accumulate formatting rules over time, especially from copy-paste operations that bring rules from other sheets.

Home > Conditional Formatting > Manage Rules > change “Show formatting rules for” to “This Worksheet.” Delete any duplicate or unnecessary rules. For large sheets, clearing all conditional formatting and reapplying only what’s needed often resolves persistent memory errors.

Fix 3: Disable add-ins

File > Options > Add-ins > Manage: COM Add-ins > Go. Uncheck all add-ins, restart Excel, and test. Re-enable them one at a time to identify the problematic one.

Fix 4: Clear named ranges

Formulas > Name Manager. Look for named ranges that reference deleted or invalid ranges (shown with errors). Delete them.

Fix 5: Open in safe mode

Hold Ctrl while launching Excel to start in safe mode (or run excel.exe /safe from Run). If the error doesn’t appear in safe mode, an add-in or startup configuration is the cause.

Fix 6: Repair the Office installation

Control Panel > Programs > Microsoft Office > Change > Quick Repair. This fixes corrupted Office files that can cause memory errors.

2

The 32-bit vs 64-bit Excel issue is the one that catches people. They’re running a modern PC with 16GB of RAM and Excel tells them there’s not enough memory. The problem is Excel itself is 32-bit and capped at 2GB addressable. Switching to 64-bit solves it completely for large workbooks.

3

the conditional formatting accumulation thing is real and annoying. copy-pasting cells between sheets drags formatting rules along silently. over time a workbook can build up hundreds of duplicate rules that it’s carrying around in memory for no reason. clearing and reapplying is tedious but it works.

4

The Name Manager audit is worth doing periodically on any long-lived workbook. Named ranges that reference deleted sheets or moved data accumulate silently and contribute to memory overhead. They’re invisible until you open Name Manager and see the error indicators.

5

Excel safe mode for diagnostic purposes is useful beyond just memory errors. Any time Excel is behaving unexpectedly, starting in safe mode to rule out add-ins is a good first step. It’s faster than manually toggling add-ins one by one to find the problematic one.

6

the office quick repair option is something i didn’t know existed until recently. it runs in a few minutes and fixes corrupted installation files without needing to reinstall everything. worth trying before doing a full office reinstall for any persistent excel weirdness.