Excel Not Enough Memory to Complete This Action: Fixes

If Excel says “There isn’t enough memory to complete this action,” it usually means the workbook or operation has exceeded available memory, or Excel cannot use memory efficiently—not necessarily that your computer has no free RAM. Close unnecessary work, check the workbook and Excel version, then try the targeted fixes below; save a copy first if the workbook contains important data.

What the Excel memory message means

The message can appear when opening, saving, calculating, copying, filtering, formatting, or inserting data. Excel needs memory for the workbook itself as well as temporary work such as recalculation, undo history, pasted ranges, add-ins, and graphics. A workbook with extensive formulas or formatting can therefore fail during an action even when it opened successfully.

There is no single memory limit that applies to every Excel installation and task. Available physical memory, whether Office is 32-bit or 64-bit, other running applications, workbook structure, and the specific operation all matter. The warning is not proof that the file is corrupt, and deleting data at random is not a good first response.

Try these steps first

Save a separate copy. If the workbook is open, use File > Save As and work on the copy. If Excel will not save, avoid repeatedly changing the original; try closing other applications and then save under a new name or location.
Close other programs and workbooks. Save other work, close unneeded browser tabs and applications, and quit extra Excel windows. Reopen Excel and test the same action. This can free memory without changing the workbook.
Restart Excel, or restart the computer. Excel may have accumulated temporary memory use during a long session. A restart clears the session; it does not repair a workbook that is inherently too large or complex.
Test Excel in Safe Mode on Windows. Close Excel, press Windows key + R, enter excel /safe, and press Enter. If the action works in Safe Mode, an add-in or startup customization may be involved. In normal Excel, open File > Options > Add-ins; use the Manage list to review Excel add-ins or COM add-ins, select Go, and disable add-ins temporarily. Re-enable them one at a time to identify a cause. Menu wording can vary by Office version.
Try the action on a smaller selection. If copying, formatting, or deleting, select only the used cells rather than entire rows, columns, or a whole sheet. If filtering or recalculating, test a smaller range or a copy of the workbook.

Check workbook size and structure

A sheet can appear mostly empty but still have a large used range. Applying a format to entire columns, pasting data far below or to the right of the real table, or deleting visible content without clearing old formatting may make Excel treat many extra cells as used. Press Ctrl+End on Windows (or the corresponding End shortcut on your Mac) to see where Excel considers the last used cell to be. If it is far beyond your actual data, remove genuinely unused rows and columns after the real data, save, close, and reopen the copy to test whether the used range has contracted. Do not delete rows or columns that contain data, formulas, or formatting you need.

Other common sources of excess work include large numbers of formulas, volatile or complicated calculations, duplicated conditional formatting, embedded images, shapes, and links to other workbooks. Inspect formulas and formatting before removing them. If a calculation is no longer meant to update, a copy of the workbook can sometimes retain its displayed results by copying the relevant cells and using Paste Special > Values. This removes the formulas in the pasted copy, so it is not suitable when future recalculation is needed.

Check Excel’s bitness and calculation settings

A 32-bit version of Excel has a more constrained address space than 64-bit Excel, regardless of how much physical RAM is installed. If large workbooks are a regular part of your work, check the installed version through File > Account > About Excel in many Windows versions. The dialog identifies whether Excel is 32-bit or 64-bit. Moving to 64-bit Office may help with memory-intensive work, but compatibility with older add-ins and other software should be checked first; it does not make an inefficient or oversized workbook automatically fast.

For a workbook with many formulas, check Formulas > Calculation Options. Automatic calculation can trigger a full recalculation after changes. Switching temporarily to Manual can help you make several edits before recalculation, but displayed formula results may then be out of date. Use Calculate Now or restore Automatic when appropriate, and do not treat manual calculation as a fix for insufficient memory during every operation.

When Excel will not open the workbook

First close other applications, restart Excel, and try opening the file again. If the problem continues, start Excel in Safe Mode and use File > Open > Browse. In the Open dialog, select the file, use the arrow beside the Open button, and choose Open and Repair if that option is available. The exact dialog can differ across versions. Repair may not recover every feature, so preserve the original and save any recovered version under a new name.

If the workbook is stored in a synced folder or network location, make a local copy and test it; this can help distinguish a file-access issue from a workbook or memory issue. If only one workbook fails, its contents or structure are more likely involved. If several unrelated workbooks fail, investigate Excel, add-ins, available system resources, and Office updates. Install Office updates through the update controls available for your installation, then retest.

Common mistakes and limits

Assuming more RAM is always the answer: a 32-bit installation, add-in, huge used range, or costly formulas may be the limiting factor.
Selecting entire columns for a small task: operations over a million-row column can require far more work than selecting the actual data.
Deleting formulas without a backup: replacing formulas with values or removing formatting can change how a workbook works.
Changing calculation to Manual and forgetting: the numbers shown may no longer reflect the latest inputs.

If a repaired copy still fails after these checks, narrow down the failing sheet or operation using a duplicate and smaller selections. For business-critical files, keep the original untouched and ask the workbook’s owner or your organization’s IT support before removing links, macros, or data. The best remedy depends on what Excel is doing when the warning appears.

Frequently Asked Questions

Does this error mean my computer has run out of RAM?
No. It indicates Excel could not complete the operation with the memory or resources available to it. Excel’s bitness, workbook complexity, other applications, and add-ins can all contribute.

Will switching to 64-bit Excel fix the error?
It may help with large, memory-intensive workbooks if the current installation is 32-bit. It is not a guaranteed fix, and compatibility with add-ins or other software should be considered.

Why does the error happen when I format cells?
Formatting a very large range, especially entire rows or columns, can make Excel process many cells. Try formatting only the cells containing data and check whether the sheet has an unnecessarily large used range.

Can I recover a workbook that will not open?
Try Excel’s Open and Repair option on a copy of the file. Recovery is not guaranteed, so preserve the original and save recovered content as a separate file.

Is it safe to set calculation to Manual?
It is a temporary workaround for some formula-heavy tasks, but results can become stale until you recalculate. Restore Automatic or recalculate before relying on the displayed values.

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 →