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.