How To Fix Excel Ran Out of Resources While Attempting To Calculate

Excel ran out of resources while attempting to calculate one or more formulas means Excel hit a memory or calculation ceiling before it could finish recalculating, so it stopped and left those formulas unevaluated. Your data is not corrupted. The usual cause is a formula referencing far more cells than it needs, most often a whole-column reference inside a lookup or array formula.

The fix is almost always to shrink what Excel is being asked to calculate, not to buy more memory. This guide walks through eight fixes in the order that resolves the error fastest, explains what the message actually means, and covers the three related memory errors that people confuse with this one.

Last updated: August 23, 2026

What this guide covers

• What does "Excel ran out of resources" actually mean?
• Why does the error pop up?
• The Excel limits that trigger it
• How do you fix "Excel ran out of resources"?
• Which fix should you try first?
• Why does Excel keep running out of resources?
• The other Excel memory errors, and how they differ
• Does this happen on Windows 11 and Mac?
• Frequently asked questions

What Does "Excel Ran Out of Resources" Actually Mean?

The full message reads: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."

Read literally, it says Excel gave up mid-calculation. It is a calculation-engine message, not a file-integrity message. Excel began recalculating, the work required more address space or more calculation steps than it could allocate, and rather than crash it abandoned the recalculation and told you.

The rule to remember: this error is about how much Excel is being asked to calculate at once, not about how much data your file contains. A 200 KB workbook with six badly written formulas throws it far more often than a 40 MB workbook with clean ones.

Three things the message does not mean:

• It does not mean your file is corrupted. The affected formulas simply hold their last calculated values, or show as unevaluated. Your data is intact.
• It does not mean you are out of RAM. On 32-bit Excel the constraint is address space, which is a fixed ceiling regardless of how much physical memory the machine has.
• It does not mean you have too many rows. An Excel worksheet holds 1,048,576 rows by 16,384 columns. Almost nobody hits that. What people hit is a formula that references all of them.

Why Does the "Excel Ran Out of Resources" Error Pop Up?

The error usually comes from one of these, roughly in order of how often they turn out to be the culprit.

1. Whole-column references. A formula like =VLOOKUP(A2,Sheet2!A:D,4,0) copied down 50,000 rows asks Excel to consider more than a million cells per row, fifty thousand times over. This is by far the most common trigger and the easiest to fix.
2. Complex or deeply nested formulas. Excel allows 64 nested levels of functions and 255 arguments in a single function. Formulas that approach either figure are expensive to evaluate.
3. Volatile functions used at scale. NOW, TODAY, OFFSET, INDIRECT, RAND and RANDBETWEEN recalculate on every single change anywhere in the workbook, and everything that depends on them recalculates too.
4. Array formulas over huge ranges. Array logic multiplies the work. Applied to a whole column, it multiplies it by a million.
5. Too many unique cell formats. A workbook can hold 65,490 unique cell formats. Files that have been copied between workbooks for years quietly accumulate them, and format bloat consumes the same address space calculation needs.
6. Add-ins competing for the same memory. On 32-bit Excel, add-ins share the process address space with Excel and the workbook. Several heavy add-ins can take a meaningful slice of it.
7. Running 32-bit Excel on a large workbook. The ceiling is far lower than most people assume, as the next section shows.
8. Multiple large workbooks open at once. They share one Excel process and one memory pool.

The Excel Limits That Trigger This Error

These are the published limits from Microsoft's Excel specifications and limits reference. Knowing the actual numbers saves a lot of guessing.

One correction worth making, because it is repeated everywhere: the often-quoted "32-bit Excel is capped at 2 GB" is out of date. Since 2016, 32-bit Excel 2013 and Excel 2016 onward are Large Address Aware, which raises the user-mode ceiling to 4 GB on 64-bit Windows and 3 GB on 32-bit Windows. It is still a hard ceiling, and it is still shared with every add-in in the process. It is just higher than the number most articles quote.

How Do You Fix "Excel Ran Out of Resources"?

Work through these in order. The first three resolve the great majority of cases, and none of them require reinstalling anything.

1. Replace whole-column references with real ranges

This is the highest-yield fix and the one most guides leave out. Find any formula that references an entire column and bound it to the rows that actually hold data.

• Press Ctrl + F, click Options, set Look in to Formulas, and search for :A, then :B, and so on, or search for your lookup function name.
• Rewrite =VLOOKUP(A2,Sheet2!A:D,4,0) as =VLOOKUP(A2,Sheet2!$A$2:$D$5000,4,0).
• If your data grows, convert the source range to a Table with Ctrl + T and reference the Table name. A Table expands automatically without ever referencing empty rows.

The rule: never let a formula reference more rows than your data will realistically ever have.

2. Simplify and correct your formulas

Complex and incorrect formulas are major contributors to Excel running out of resources. Excel uses valuable memory and processing power when one or more formulas are too complicated. This is particularly true for nested formulas, where one formula is embedded within another, and for volatile functions, which recalculate whenever any change occurs in the workbook.

• Break down large formulas. Instead of one complex formula, split it into smaller steps across multiple cells. This reduces the computational burden and makes it easier for Excel to manage calculations. Instead of one long IF formula with multiple conditions, create intermediate cells for each condition and reference them in a final formula.
• Reduce the use of volatile functions. NOW, TODAY, OFFSET, INDIRECT, RAND and RANDBETWEEN recalculate every time Excel refreshes. Replace them with static alternatives where possible. Instead of OFFSET, use structured references or INDEX combined with a range, which is not volatile and is considerably cheaper.
• Use array formulas wisely. They are powerful but strain Excel when applied over large ranges. Limit their range rather than applying them to a whole column.
• Trace the culprit with Formula Auditing. On the Formulas tab, use Trace Precedents and Trace Dependents to see how far a formula's dependency chain actually reaches. A single cell feeding thousands of dependents is a red flag.
• Step through it with Evaluate Formula. Go to Formulas > Evaluate Formula and walk the calculation one step at a time to see where the work explodes.

3. Switch calculation to manual so you can work again

If the error fires every time you touch a cell, you cannot edit your way out of it. Turn recalculation off first, fix the formulas, then turn it back on.

• Go to Formulas > Calculation Options and select Manual.
• Make your edits. Excel will not recalculate until you press F9.
• Press Shift + F9 to recalculate only the active sheet, which is much lighter than a full workbook pass.
• Set it back to Automatic when the workbook is healthy again.

4. Reduce the number of calculation threads

Multi-threaded calculation is normally faster, but each thread claims its own slice of the same limited address space. On a workbook that is already near the ceiling, fewer threads can be the difference between finishing and failing.

• Go to File > Options > Advanced and scroll to the Formulas heading.
• Select Manual under number of calculation threads and set the value to 1.
• Recalculate. If the error clears, you have confirmed the problem is memory pressure rather than a broken formula.
• You can raise the thread count again once the workbook is slimmed down.

5. Limit add-ins

Add-ins are third-party tools that extend Excel's functionality but consume system resources. Some run background processes or perform constant calculations, straining the same memory pool your formulas need. On 32-bit Excel they share the process address space directly, so a heavy add-in genuinely reduces the memory available for calculation.

• Go to File > Options to open the Excel Options window.
• Select Add-ins from the left menu to see everything installed.
• At the bottom, in the Manage box, choose Excel Add-ins and click Go.
• Uncheck anything non-essential, then click OK.
• Repeat with COM Add-ins in the same Manage box. COM add-ins are usually the heavier ones.

6. Close unused workbooks

Excel allocates memory and processing power to each open file. The larger or more complex the workbook, the more it consumes, and every open workbook shares one process. If you have several large workbooks open, Excel may struggle to manage them all.

Closing unused workbooks lets Excel reallocate memory to the active file, which reduces the chance of running out of resources on large datasets or complex calculations. Go to the File menu and select Close for each workbook you no longer need, saving any changes first.

7. Clear out unused cell formats

Workbooks that have been copied, pasted and merged over years accumulate thousands of unique cell formats, and that bloat competes for the same memory calculation needs.

• Select the rows below your last row of data, press Ctrl + Shift + Down Arrow, then right-click and choose Delete.
• Do the same for the columns to the right of your data with Ctrl + Shift + Right Arrow.
• Save, close and reopen the file. The used range resets and the file size usually drops noticeably.
• If a workbook still misbehaves, copy the data into a brand new workbook rather than trying to salvage the old one.

8. Move to 64-bit Excel, or repair your installation

If the workbook genuinely needs more headroom than a 32-bit install can offer, 64-bit Excel removes the hard address-space ceiling entirely. It is the right answer for large data models in finance, research and engineering, and the wrong answer for a small file with one bad formula.

• Check compatibility. You need 64-bit Windows. A 32-bit Windows install cannot run 64-bit Excel.
• Install it. Download the 64-bit version from your Microsoft account. You must uninstall the 32-bit version first, because the two cannot coexist.
• Verify. Open Excel and go to File > Account > About Excel to confirm the version.
• Check for add-in compatibility first. Older 32-bit COM add-ins and some VBA declarations will not run on 64-bit Excel without changes.

If the error appears even on a small, simple file, the installation itself may be the problem. Start Excel in safe mode by holding Ctrl while launching it, or by running excel /safe. If the error disappears in safe mode, an add-in is the cause. If it persists, run an Office repair from Settings > Apps, choosing Quick Repair first and Online Repair only if that fails.

Which Fix Should You Try First?

Why Does Excel Keep Running Out of Resources After You Fix It?

If the error keeps coming back, the underlying formula has not changed. It is worth being systematic about why.

• You fixed the symptom, not the formula. Restarting Excel or closing other files frees memory temporarily. The next full recalculation asks for the same amount again.
• The formula was copied further down. An expensive formula that worked over 500 rows will fail over 50,000. Check whether the range grew.
• There is a circular reference. Circular references force repeated iteration and can push a workbook over the edge. Check the status bar, or use Formulas > Error Checking > Circular References. Our guide to finding a circular reference in Excel walks through it.
• Conditional formatting rules have multiplied. Copying rows duplicates the rules attached to them. Open Home > Conditional Formatting > Manage Rules and look for the same rule listed dozens of times.
• The file lives on a slow network drive or a synced cloud folder. Copy it locally, fix it, then put it back.
• Excel is not actually finishing the calculation. If the application also hangs, see Excel not responding, and if formulas simply show stale results, see Excel formulas not calculating.

The Other Excel Memory Errors, and How They Differ

Three other messages get mistaken for this one. They have different causes and different fixes, so it is worth checking which one you actually have.

The pattern: "ran out of resources" is a calculation problem, "not enough memory" is an action problem, and "not enough system resources to display" is a rendering problem. Naming which one you have narrows the fix immediately.

Does This Happen on Windows 11 and Mac?

Yes on both, with a couple of differences worth knowing.

• Windows 11. The error behaves identically to Windows 10. There is no Windows 11 specific cause and no Windows 11 specific fix. If you upgraded and the error started, the more likely explanation is that a 32-bit Excel install carried over, or that an add-in was reinstalled. Check your bitness under File > Account > About Excel.
• Mac. Excel for Mac has been 64-bit only since Excel 2016, so the address-space ceiling that causes most Windows cases does not apply. When the error appears on a Mac it is almost always genuine formula scope, fix 1 and fix 2. The calculation-threads setting lives under Excel > Preferences > Calculation rather than File Options.
• Excel for the web. The web version runs calculation on Microsoft's servers and has its own separate limits. If a workbook fails in the desktop app, opening it in the browser is a reasonable way to confirm whether the formulas themselves are sound.

Final Thoughts

The "Excel ran out of resources while attempting to calculate" error looks alarming and is usually mundane. In most workbooks it comes down to one or two formulas asking Excel to consider a million cells when a few thousand would do. Bound the ranges, cut the volatile functions, and the error disappears without touching your hardware.

If it survives all eight fixes on a file that is genuinely small, treat it as an installation problem rather than a spreadsheet problem, and start with safe mode.

You can visit our homepage for more easy-to-follow how-to and step-by-step guides. Check the links in related articles for further details about Excel and Google Sheets templates.

Frequently Asked Questions

What does "Excel ran out of resources while attempting to calculate" mean?
It means Excel hit a memory or calculation ceiling partway through recalculating and abandoned the attempt, leaving the affected formulas unevaluated. It is a calculation-engine message. Your data is not damaged and the file is not corrupted.

Will upgrading my system's RAM fix this error?
Only if you are running 64-bit Excel. On 32-bit Excel the binding constraint is virtual address space, which is capped at 2 GB, or 4 GB on 64-bit Windows with Large Address Aware, and shared by Excel, the workbook and every add-in in the process. Adding physical RAM does not raise that ceiling. Check your bitness under File, Account, About Excel before spending anything.

Why does Excel keep running out of resources even on a small file?
Because file size is not what triggers it. A small workbook with whole-column lookups, volatile functions or a circular reference asks for far more calculation than a large workbook with clean formulas. If a genuinely simple file throws the error, test in safe mode to rule out an add-in.

How do I find the formula that is causing the error?
Switch calculation to Manual, then recalculate one sheet at a time with Shift + F9 to isolate which sheet fails. On that sheet, use Formulas, Trace Precedents to find formulas with unusually deep dependency chains, and search the sheet with Ctrl + F set to look in Formulas for whole-column references.

Is "not enough system resources to display completely" the same error?
No. That one is a rendering limit rather than a calculation limit, and it is normally caused by too many objects, shapes or conditional formatting rules on a single sheet. Turning off hardware graphics acceleration in File, Options, Advanced fixes it more often than any formula change.

How do I prevent this error in the future?
Bound every formula to a real range or a Table rather than a whole column, keep volatile functions out of large ranges, delete unused rows and columns before saving, and keep the number of simultaneously open large workbooks down. Those four habits prevent almost every recurrence.

Related Articles

Excel Not Responding? How To Fix It

How to Fix Excel Formulas Not Calculating, Working, or Updating

How To Clear Excel Cache on Windows and Mac

How to Find a Circular Reference in Excel

How to Add a Total Row in Excel

How to Calculate Percentage Change in Excel

How to Alternate Row Colors in Excel