Excel Performance Problems

How to Fix Excel Cannot Recalculate and Runs Out of Resources Error

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

Question details

The user needs to resolve an Excel workbook that reports an out-of-resources error while calculating formulas when pressing Enter and to identify the worksheet or formulas causing the calculation failure.

How to Fix Excel Cannot Recalculate and Runs Out of Resources Error
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is editing a formula-heavy Excel workbook and pressing Enter triggers recalculation, after which Excel reports that it has run out of resources.
Observed behavior
Excel shows an out-of-resources error during recalculation and cannot complete the formula calculation.
Before you start

Create a workbook copy before deleting any worksheets, and set Excel calculation to Manual through Formulas > Calculation Options so the file does not attempt to recalculate while you test.

Solution 1Recommended

Identify the worksheet that triggers the out-of-resources error

Use this method first to isolate the corrupted or overloaded worksheet without damaging the original workbook.

Work on a copy because you will delete worksheets during the test. Manual calculation prevents Excel from recalculating while you save and close.

1
Create a test copy

In File Explorer, copy the workbook and rename the copy so the original remains untouched.

2
Set calculation to Manual

Open the copy, go to the Formulas tab, click Calculation Options, and select Manual.

3
Save and close the workbook

Save the copy and close Excel so the manual calculation setting is retained.

4
Remove worksheets one at a time

Reopen the copy, delete one worksheet, save the copy under a different name, close Excel, and reopen the saved file.

5
Repeat until the issue stops

Continue deleting one worksheet per test until the workbook no longer reports the resource error; the last removed worksheet is the likely source.

Identify the worksheet that triggers the out-of-resources error
Workbook isolated: Once the problematic sheet is identified, restore the original workbook and apply cleanup only to that sheet.
Free Microsoft Office alternative

Open Excel Workbooks in WPS Spreadsheets to Reduce Resource Strain

WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx workbooks, preserves formulas and formatting, and offers a familiar ribbon interface so you can continue reviewing or rebuilding the calculation model without Excel's resource error.

  1. 1. Download WPS Office: Go to the official WPS website and download WPS Office, then install it.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx workbook that shows the resource error in Excel.
  3. 3. Review and continue the calculation model: Use the Formulas tab to check and edit formulas, or rebuild heavy parts of the workbook with helper columns and PivotTables in WPS Spreadsheets.
Free to download and use for spreadsheet editing and formula workReads and writes .xlsx files with formula and formatting compatibilityLightweight design uses fewer system resources on large workbooksFamiliar ribbon interface shortens the learning curve when moving from ExcelSeamless migration for Excel workbooks, charts, and common formulas
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say it ran out of resources while calculating formulas?

This usually happens when a volatile function, full-column reference, circular reference, oversized array formula, or corrupted worksheet forces Excel to recalculate too many cells at once. Set calculation to Manual and isolate the worksheet to find the trigger.

How do I set Excel calculation to Manual?

Open the workbook, click the Formulas tab, click Calculation Options, and select Manual. You can then press F9 when you want to manually recalculate the workbook.

How can I identify which worksheet is causing the resource error?

Make a copy of the workbook, set calculation to Manual, save and close it. Delete one worksheet, save the copy under a different name, close Excel, and reopen the saved file. Repeat until the error stops; the last removed worksheet is the likely cause.

Can WPS Office open an Excel workbook that has formula calculation problems?

Yes, WPS Spreadsheets supports .xlsx files and can often open the workbook with lower resource usage. You can then review formulas, remove bottlenecks, or rebuild the calculation model in WPS Office.

How can I reduce volatile formulas in Excel?

Search for volatile functions such as OFFSET, INDIRECT, TODAY, NOW, RAND, and RANDBETWEEN. Replace them with static values or helper columns where possible, and use Tables, PivotTables, or Power Query for repeated calculations.