Copying cells, inserting a new row, applying formatting, or calculating complex formulas in Microsoft Excel only to receive an error prompt stating: ‘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’ halts spreadsheet productivity. While your workstation may boast 16GB or 32GB of physical RAM, Excel throws this error when a single workbook exceeds internal memory structures, when excess empty rows contain ‘ghost’ formatting extending to row 1,048,576, or when running the legacy 32-bit edition of Excel which is strictly hard-capped at 2GB of addressable memory.
Why Does Microsoft Excel Run Out of Memory?
Excel manages individual memory heaps for formulas, shapes, and cell values. Memory exhaustion occurs due to:
- 32-Bit Excel Virtual Memory Limit: Running 32-bit Microsoft 365 or Office 2019 which cannot access more than 2GB of virtual address space regardless of your PC’s installed RAM.
- Ghost Cell Formatting Bloat: Applying fill colors, borders, or conditional formatting to whole columns, forcing Excel to track millions of empty cells.
- Excessive Volatile Formulas: Thousands of volatile functions (such as
INDIRECT,OFFSET,TODAY, orRAND) continuously recalculating in the background. - Unclosed DDE / COM Automation Handles: Add-ins maintaining active references to external data streams without garbage collection.
Step 1: Clear Ghost Formatting and Excess Unused Cells
Shrink bloated workbook file sizes by removing blank cells that Excel mistakenly considers active data.
- Open the affected workbook in Microsoft Excel.
- Select your first worksheet.
- Press Ctrl + End on your keyboard to navigate to the ‘last used cell’ according to Excel.
- If Ctrl + End takes you far beyond your actual data (e.g. to row 500,000 or column XFD), your sheet suffers from ghost formatting.
- Click the row header immediately below your last row of actual data.
- Press Ctrl + Shift + Down Arrow to select all empty rows down to the bottom of the worksheet.
- Right-click the selected row headers and click Delete (do not simply press the Delete key; use the right-click Delete option).
- Repeat this for columns: click the column header to the right of your data, press Ctrl + Shift + Right Arrow, right-click, and select Delete.
- Save the workbook immediately (Ctrl + S), close Excel, and reopen to reclaim massive amounts of memory.
Step 2: Verify Whether You Are Running 32-Bit or 64-Bit Excel
Upgrading from 32-bit to 64-bit Excel eliminates memory allocation ceilings permanently.
- In Excel, click File in the top-left corner > Account.
- Click the About Excel button.
- Examine the top line of the modal window: look for either 32-bit or 64-bit.
- If it says 32-bit, your software is restricted to a 2GB memory ceiling.
- To upgrade: sign in to your Microsoft 365 account at
office.com, choose Install Office > Other options, select 64-bit, and install the native 64-bit architecture.
Step 3: Switch Calculation Mode to Manual
Prevent Excel from executing continuous memory-intensive calculations while editing.
- Navigate to the Formulas tab on the ribbon.
- Click Calculation Options.
- Change the setting from Automatic to Manual.
- Uncheck Recalculate workbook before saving if working with gigantic statistical models.
- When you are ready to update formulas, press F9 to recalculate on demand.
Step 4: Disable Hardware Graphics Acceleration in Excel
Graphics rendering driver leaks often consume large portions of Excel’s GDI memory heaps.
- Click File > Options > Advanced.
- Scroll down to the Display section.
- Tick the box labelled Disable hardware graphics acceleration.
- Under the General section in Options, uncheck ‘Provide feedback with animation’.
- Click OK and restart Excel.
Step 5: Increase Windows Virtual Memory Paging File Size
Ensure Windows has adequate disk paging capacity to back up physical RAM.
- Press Win + R, type
sysdm.cpl, and press Enter to open System Properties. - Switch to the Advanced tab and click Settings under Performance.
- Switch to the Advanced tab in the Performance Options window and click Change… under Virtual memory.
- Uncheck ‘Automatically manage paging file size for all drives’.
- Select your
C:drive, choose Custom size, and set Initial size to8192 MBand Maximum size to16384 MB. - Click Set, then OK, and restart your computer.