Excel Spreadsheet Error Message

First determine whether the resource error occurs only in this workbook or also in a new blank workbook, because that separates a workbook calculation problem from an Excel-wide installation or add-in problem.^1^

If only one workbook is affected

1. Save a backup copy before changing formulas or workbook elements.
2. Check the bottom-left Excel status bar for Circular References. A circular reference occurs when a formula refers directly or indirectly to its own cell—for example, placing =SUM(A1:A11) in cell A10. Correct the referenced range or formula.^2^
3. Identify what triggers the message: calculation, inserting rows or columns, sorting, copying, or saving. These operations can force large numbers of formulas to recalculate.^1^
4. Review the affected formulas for:
   • Invalid or undefined names.
   • Functions missing required arguments.
   • References to unexpectedly large ranges.
   • Repeated or unnecessarily complex calculations.
5. Remove or simplify unnecessary shapes, complex charts, PivotTables, macros, and extensive formatting; these can also consume workbook resources.^1^
6. If this is a legacy shared workbook, go to View → Custom Views, remove unneeded custom views, and then reapply any required print areas or filters. Deleting custom views removes those settings but not worksheet data.^1^

As a temporary way to open, edit, and isolate the problematic formulas:

1. Go to File → Options → Formulas.
2. Under Calculation options, select Manual.
3. Clear Recalculate workbook before saving.
4. Reopen the workbook and test it.^3^

Manual calculation is a diagnostic workaround, not the final fix: formulas will not update automatically. After correcting the workbook, return Formulas → Calculation Options to Automatic.

If new blank workbooks are also affected

Work through these application-level checks:

1. Update Office and Windows. Updates can replace outdated files and resolve Excel stability problems.^4^
2. Test Excel in Safe Mode:
   • Press Windows+R.
   • Enter excel /safe and select OK.
   • Create a blank workbook and test a simple formula.
   Safe Mode bypasses Excel and most COM add-ins. If the error disappears, disable add-ins under File → Options → Add-ins, selecting each add-in type from Manage → Go, and re-enable them individually to identify the conflict.^4^
3. Repair Microsoft 365: Windows Settings → Apps → Installed apps → Microsoft 365 → Modify, then run the available repair option.^4^
4. If large workbooks are involved, check File → Account → About Excel to see whether Office is 32-bit or 64-bit. The official troubleshooting guidance documents a 2-GB application limit for 32-bit Excel and recommends considering 64-bit Excel when calculations require more memory.^1^
5. If closing other applications or restarting Windows temporarily clears the error, use a Windows clean boot to identify a background process or service competing with Excel for resources.^1^

Avoid reinstalling Windows as an initial remedy; workbook isolation, Safe Mode, updates, and Microsoft 365 repair are the appropriate earlier checks.

References

1. How to troubleshoot "available resources" errors in Excel
2. Formula values in cells are changing to Nil and formulas do not work - Microsoft Q&A
3. Excel Error: "Ran out of resources to calculate one or more formulas" - Microsoft Q&A
4. Excel not responding, hangs, freezes or stops working