Not Enough Memory to Run Excel? How to Fix It

The “Not enough memory to run Microsoft Excel” message can appear when opening Excel, loading a workbook, or performing an operation on a large file. The cause may be a demanding workbook, limited available system memory, an add-in, or a damaged Office installation; work through the checks below, starting with the least disruptive.

What You’ll Need

• Access to Windows and Excel settings, and permission to restart your computer.
• A saved copy of any workbook you are troubleshooting. If it contains important data, keep an untouched backup before changing or repairing it.
• An internet connection if you need to update Office or Windows.

Step-by-Step

1. Protect your work and restart. If Excel is open and responsive, save the workbook under a new name or make a copy in File Explorer. Close Excel and other applications that use substantial memory, then restart Windows. Reopen Excel and try the same task. A restart clears temporary resource pressure, but it will not fix a workbook that consistently demands more resources than the computer can provide.
2. Check whether the problem affects one workbook or all of Excel. Start Excel without opening the affected file. If Excel opens, create a blank workbook. If only one file triggers the message, focus on that workbook: it may have a very large used range, extensive formulas, many formatting rules, linked data, or objects. If even a blank workbook fails, continue with the add-in and Office checks below.
3. Check available memory and close resource-heavy apps. Press Ctrl+Shift+Esc to open Task Manager, then select Processes. Look for applications using a large amount of memory, save any work in them, and close what you do not need. Avoid ending unfamiliar Windows processes. On the Performance tab, check Memory to see whether usage is near capacity. If it is, Excel may have too little memory available even when the workbook itself is not unusually large.
4. Open Excel in Safe Mode. Close Excel. Press Windows key+R, enter excel /safe, and press Enter. If Excel works in Safe Mode, an add-in or startup setting may be involved. In Excel, select File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and select Go. Clear the checkboxes to disable add-ins, then restart Excel normally. Re-enable them one at a time, testing after each, to find the one causing the issue. Add-in options can vary by Excel installation.
5. Update Office and Windows. In Excel, go to File > Account > Update Options > Update Now, if those options are available. Install pending Windows updates through Settings > Windows Update, then restart. Updates can resolve compatibility or reliability problems; they do not guarantee that a workbook will fit within the computer’s available resources.
6. Reduce the workbook’s workload. If the problem is limited to one file, make a copy first. In the copy, remove unnecessary worksheets, images, charts, or formatting; clear formatting from unused rows and columns; and reduce formulas that recalculate over entire columns when a smaller range will do. If the workbook has many formulas, save a separate copy and consider changing formulas to values only where you no longer need them to update. Make changes in small batches and reopen the file to check whether the error is resolved.
7. Try opening a copy or recovering the workbook. If the file may be damaged, open Excel first and select File > Open > Browse. Select the file, choose the arrow beside Open, then choose Open and Repair, if shown. Choose repair first; use extract data only if repair does not work and you accept that formulas or formatting may be lost. Do not overwrite your original file.
8. Repair Office if Excel still fails. In Windows, open Settings > Apps > Installed apps (the wording may differ slightly), find Microsoft 365 or Office, and select Modify. Run Quick Repair first. If the error remains, try Online Repair, which may require internet access and a new sign-in. Save your work and close Office apps before starting either repair.

Common Mistakes

• Assuming the error always means the computer needs more RAM. Excel may be constrained by a workbook, add-in, damaged installation, or the particular Excel version. Identify whether the issue occurs in a blank workbook before considering hardware changes.
• Deleting content from the only copy. Workbook cleanup and repair can remove data, formatting, links, or formulas. Keep an untouched backup and check the edited copy before relying on it.
• Disabling every add-in permanently. Safe Mode is a diagnostic test. Re-enable useful add-ins one at a time so you can identify the specific cause rather than losing features unnecessarily.
• Using registry edits or random “memory cleaner” tools. These can cause new problems and are not a reliable first-line fix. Stick to Excel, Windows, and Office settings.

Tips

• Keep the workbook on a local drive while testing, especially if it is normally opened from a network or synchronized folder. A separate copy helps distinguish file-location problems from workbook problems.
• Use formulas only over the ranges needed, remove redundant conditional formatting, and avoid keeping unused objects or sheets in large workbooks.
• If you regularly work with very large files, check whether your Office installation is 32-bit or 64-bit in File > Account > About Excel. A 64-bit version can address more memory, but compatibility with add-ins and other software matters. Consult your organization’s IT support before changing editions on a managed device.
• After each change, test the same action that originally caused the message. This makes it easier to identify what helped.

Troubleshooting

Excel will not start, even in Safe Mode: restart Windows, check for pending updates, and run an Office repair. If Excel still will not open, contact your IT administrator or Microsoft support and note the exact wording of the error.

Only one workbook fails: work on a copy, try Open and Repair, and reduce unnecessary content. If the file is stored on a shared drive, ask its owner for a fresh copy or test a local copy. For a protected or business-critical workbook, involve its owner before removing content or links.

The error returns after a repair: note whether it happens in Safe Mode, with a blank workbook, or only during a particular calculation. Share that information, your Excel version and whether it is 32-bit or 64-bit with IT support. If the computer is managed, do not change installation settings without approval.

Frequently Asked Questions

Does this error mean my workbook is lost?
No. It usually means Excel could not complete an operation with the resources available. Keep the original file and try a copy or Open and Repair if needed.

Can restarting Excel fix the problem?
Sometimes. Restarting Excel or Windows can free resources held by other applications, but a consistently oversized or damaged workbook may need further attention.

Why does Excel show the error for only one file?
That workbook may contain more formulas, formatting, objects, or linked data than other files, or it may be damaged. Test a copy and make changes cautiously.

Should I switch to 64-bit Excel?
It can help with workloads that need more memory, but it is not a guaranteed fix. Check add-in compatibility and consult IT before changing Office editions.

Will Open and Repair recover everything?
Not necessarily. Repair may restore a usable file but can lose some content or formatting. Preserve the original and review the recovered copy carefully.

Related

• Update Your Roku Email and Check Purchase History
• Video and Audio Pausing Automatically on Windows 11
• Make an Image Background Transparent in PowerPoint