Excel Not Enough Memory Error: Causes and Fixes Explained

If Excel says there is not enough memory to complete an action, first save your work if possible, close other applications, and restart Excel; then check whether the problem follows one workbook or happens with every workbook. The message can mean Excel has run out of usable memory or other resources—not necessarily that your computer has no free RAM. The right fix depends on whether the workbook, Excel’s version, or Windows is the source.

What the error means

Excel needs memory and other system resources to open files, calculate formulas, display sheets, and carry out actions such as copying, sorting, or refreshing data. A workbook can demand more resources than Excel can currently allocate. The resulting message may appear while opening a file, editing a large range, inserting a sheet, refreshing a PivotTable, or calculating formulas. Exact wording varies by Excel version and the action underway.

Free RAM in Windows Task Manager does not guarantee that Excel can use all of it. Excel runs as a process with its own address-space and resource limits, and add-ins or other open workbooks also consume resources. Conversely, Windows can be low on available memory even if the workbook itself is not unusually large. Treat the message as a symptom to investigate, rather than proof that you must buy more RAM.

Why Excel runs out of usable memory

Some causes are specific to one workbook; others affect Excel or the computer generally. Large file size is only one clue. A workbook with many formulas, formatting rules, images, charts, PivotTables, or imported records may require substantial resources even if its saved file is not enormous. Excel’s worksheet limit—1,048,576 rows by 16,384 columns—describes the maximum grid, not how much data or calculation a computer can handle comfortably.

A complex workbook: Numerous formulas, large arrays, repeated conditional-formatting rules, or many objects can increase calculation and display demands.
Bloated formatting or used range: Formatting applied far beyond the actual data can make Excel treat more of a sheet as in use.
32-bit Excel: It has a smaller address space than 64-bit Excel and can reach its limits even on a computer with considerable physical RAM. The exact limit depends on the Excel release and Windows configuration.
Other software or Excel components: Many open workbooks, browser tabs, add-ins, or background applications can compete for resources or cause a specific action to fail.
A damaged file or installation: If the issue is isolated to a file or persists across files, corruption or an Office problem is also possible.

Try these safe recovery steps first

If Excel is still responding, save the workbook under a new name before making changes. If it is frozen, wait briefly for a large calculation or refresh to finish. If it remains unresponsive, Windows Task Manager can close Excel, but unsaved changes may be lost. Reopen Excel and check whether its Document Recovery pane offers a recoverable version.

Close other large applications and extra Excel workbooks, then retry the action. This is a quick way to see whether temporary resource pressure is involved.
Restart Excel. If the issue continues, restart Windows to release resources held by applications that did not close cleanly.
Open a blank workbook and try a simple action, such as typing into a cell. If that works but the original file fails, focus on that workbook. If blank files also fail, investigate Excel, add-ins, or system resources.
Check Windows Task Manager’s Processes or Details view while reproducing the problem. High memory use can point to resource pressure, but the display alone does not identify which workbook feature is responsible.
Update Microsoft 365 from File > Account > Update Options > Update Now. The exact update options can depend on how Office is managed by an organization.

On a Mac, Windows Task Manager and the Windows update path do not apply; use macOS Activity Monitor to review application memory use and update Office through the available Microsoft AutoUpdate or Office account options. Excel for the web also runs in a browser, so closing other tabs and reopening the workbook may help, but desktop troubleshooting steps and features can differ.

Find out whether the workbook is the problem

Test a copy of the affected file, not the only original. If a new blank workbook behaves normally, compare the actions that trigger the error. Does it happen on one sheet, during calculation, or only when refreshing an external data connection? A repeatable trigger narrows the search more effectively than removing features at random.

In Windows Excel, press Ctrl+End to move to the last cell Excel considers used on the current sheet. If that cell is far below or to the right of your real data, excess formatting or past edits may have expanded the used area. The shortcut identifies a possible issue; it does not by itself repair it. On Mac, the equivalent navigation shortcut can depend on the keyboard, so use the sheet’s scroll bars or Go To options if needed.

Look for other signs of workbook complexity: slow saving, long calculation pauses, unexpectedly large file size, or trouble limited to one particular operation. Check whether the file contains a very large number of conditional-formatting rules, embedded images, duplicated sheets, external links, or data connections you no longer need. Avoid deleting items until you understand their purpose, especially if the workbook supports a business process.

Reduce the workbook’s memory demand

Make one change at a time in a duplicate, save it, close and reopen it, and test the original action. This makes it possible to identify what helped and to restore the original if a change removes needed information.

Remove genuinely unused content: Delete obsolete sheets, objects, and data only after confirming they are not needed. Clearing cell contents is not always the same as removing rows, columns, formatting, or objects.
Review oversized used ranges: If excess rows or columns are clearly unused, select them and use Home > Delete > Delete Sheet Rows or Home > Delete > Delete Sheet Columns. Preserve a backup, save, close, and reopen the file; then check the last used cell again.
Limit formula work: Formulas that process entire columns or very large ranges can require more calculation than formulas limited to the actual data. Review repeated formulas and large array calculations, and avoid recalculating data that does not need to update constantly.
Check conditional formatting: Rules applied to huge ranges or duplicated across a sheet can add overhead. Review them through Home > Conditional Formatting > Manage Rules, and remove only rules that are no longer required.
Reduce unnecessary objects and formatting: Oversized images, unused charts, and elaborate formatting across empty areas can add to workbook demands. Compress or remove only what the file’s users do not need.
Consider the file format carefully: Saving a copy as an Excel Binary Workbook (.xlsb) can reduce file size in some cases, but it is not a guaranteed memory fix and may not suit every workflow. Confirm compatibility with the people and systems that use the file.

For formula-heavy workbooks, Excel’s calculation mode is available at Formulas > Calculation Options. Manual calculation can prevent repeated recalculation while you make a series of edits, but results may remain out of date until recalculated. Use it only when you understand that trade-off, and return to Automatic when appropriate. Pressing F9 recalculates in Windows Excel; Mac keyboard behavior can differ.

Check whether you are using 32-bit Excel

In Excel for Windows, choose File > Account > About Excel and look for 32-bit or 64-bit in the version information. A 64-bit version can address substantially more memory than a 32-bit version, which can make it a better fit for very large workbooks. It still depends on Windows, available system resources, workbook design, and other limits; 64-bit Excel does not make every workbook unlimited or automatically faster.

If you regularly work with large data models or very large files, ask your IT administrator whether 64-bit Microsoft 365 is suitable before changing Office installations. Compatibility matters: some older COM add-ins or components designed for 32-bit Office may not work with 64-bit Office. Also check the requirements of any connected software, drivers, or macros used by your organization. A computer running 64-bit Windows does not necessarily have 64-bit Excel installed.

Test Excel and Windows when every workbook is affected

If the error occurs even in new files, check whether an add-in is involved. In Windows, open the Run dialog with Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins disabled. If the error disappears there, an add-in or customization may be contributing, although Safe Mode alone does not identify which one. There is no identical Windows Run command on Mac.

To review add-ins in Windows Excel, go to File > Options > Add-ins. At the bottom, choose COM Add-ins beside Manage and select Go. Note the enabled items, disable them, and restart Excel normally to test. Re-enable items one at a time to find a possible cause. Some add-ins are required for workplace tools, so consult an administrator before removing or disabling managed software.

Also check whether Windows is low on memory or disk space. Closing applications may help with immediate pressure; a restart can clear temporary problems. Leave Windows’ paging-file settings at their system-managed default unless an administrator or qualified support professional advises otherwise. Changing virtual-memory settings is not a dependable substitute for fixing an oversized workbook or a 32-bit Excel limitation. If Office continues to fail, use your organization’s approved repair or support process rather than deleting Office components manually.

Prevent the error from returning

Keep a clean source copy of important workbooks and use version history or an approved backup location where available. Periodically remove obsolete sheets, rules, and external connections, but document changes to files shared with colleagues. For recurring large imports, consider whether every row needs to be loaded onto a worksheet; Power Query can help shape and filter data before loading, while a database may be more suitable when the information has outgrown a spreadsheet workflow.

Before expanding a workbook substantially, consider who needs to open it and what Excel versions, add-ins, and devices they use. A file that works on one 64-bit desktop may not be practical for colleagues using different hardware or Excel for the web. If the same error keeps returning after cleanup and updates, record the exact message, the action that triggers it, the file type, and whether a blank workbook is affected. Those details help IT support distinguish a workbook issue from an Office or Windows problem.

Frequently Asked Questions

Does “not enough memory” mean my computer needs more RAM?

Not necessarily. Excel may be constrained by its own process limits, the workbook’s complexity, or other software using resources. Check whether the error affects one file or all files and review memory use before deciding that adding RAM is the answer.

Will switching to 64-bit Excel fix the error?

It can help when a large workbook is hitting the smaller address space of 32-bit Excel, but it is not a universal fix. Check add-in and system compatibility first, and remember that workbook design and available computer resources still matter.

Why does the error happen in only one workbook?

That file may contain unusually large ranges, formulas, formatting, objects, or data connections, or it may be damaged. Work on a copy, identify the action that triggers the message, and test targeted changes rather than removing content at random.

Can I fix it by clearing cell contents?

Sometimes unnecessary data is part of the problem, but clearing contents does not necessarily remove formatting, excess used rows or columns, or embedded objects. First check the last used cell and make a backup; remove only content and formatting you know are unnecessary.

Is Excel for the web affected by the same memory limits?

It can also run into resource or workbook limitations, but it operates in a browser and does not have exactly the same environment as desktop Excel. Close unused tabs, reopen the file, and try the desktop app if available; the web version may differ in features and troubleshooting options.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.