How to Fix ‘There Isn’t Enough Memory to Complete This Action’ in Excel

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, or RAND) 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.

  1. Open the affected workbook in Microsoft Excel.
  2. Select your first worksheet.
  3. Press Ctrl + End on your keyboard to navigate to the ‘last used cell’ according to Excel.
  4. 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.
  5. Click the row header immediately below your last row of actual data.
  6. Press Ctrl + Shift + Down Arrow to select all empty rows down to the bottom of the worksheet.
  7. Right-click the selected row headers and click Delete (do not simply press the Delete key; use the right-click Delete option).
  8. Repeat this for columns: click the column header to the right of your data, press Ctrl + Shift + Right Arrow, right-click, and select Delete.
  9. 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.

  1. In Excel, click File in the top-left corner > Account.
  2. Click the About Excel button.
  3. Examine the top line of the modal window: look for either 32-bit or 64-bit.
  4. If it says 32-bit, your software is restricted to a 2GB memory ceiling.
  5. 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.

  1. Navigate to the Formulas tab on the ribbon.
  2. Click Calculation Options.
  3. Change the setting from Automatic to Manual.
  4. Uncheck Recalculate workbook before saving if working with gigantic statistical models.
  5. 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.

  1. Click File > Options > Advanced.
  2. Scroll down to the Display section.
  3. Tick the box labelled Disable hardware graphics acceleration.
  4. Under the General section in Options, uncheck ‘Provide feedback with animation’.
  5. 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.

  1. Press Win + R, type sysdm.cpl, and press Enter to open System Properties.
  2. Switch to the Advanced tab and click Settings under Performance.
  3. Switch to the Advanced tab in the Performance Options window and click Change… under Virtual memory.
  4. Uncheck ‘Automatically manage paging file size for all drives’.
  5. Select your C: drive, choose Custom size, and set Initial size to 8192 MB and Maximum size to 16384 MB.
  6. Click Set, then OK, and restart your computer.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.