How to Fix Excel Cannot Recalculate and Runs Out of Resources Error
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.

- 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.
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.
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.
In File Explorer, copy the workbook and rename the copy so the original remains untouched.
Open the copy, go to the Formulas tab, click Calculation Options, and select Manual.
Save the copy and close Excel so the manual calculation setting is retained.
Reopen the copy, delete one worksheet, save the copy under a different name, close Excel, and reopen the saved file.
Continue deleting one worksheet per test until the workbook no longer reports the resource error; the last removed worksheet is the likely source.

Clean up formula bottlenecks on the problem worksheet
After isolating the sheet, use this approach to reduce formula load and prevent recalculation from exhausting resources.
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. Download WPS Office: Go to the official WPS website and download WPS Office, then install it.
- 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. 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.

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.




