How do I find the cause of the error described below?

The error indicates that Excel is hitting resource limits (memory/CPU) while recalculating formulas on that specific worksheet. To find the cause and resolve it, focus on what in that sheet is expensive to calculate.

Follow these steps on the problematic workbook, starting with the worksheet that shows the error:

1. Check if the issue is isolated to this workbook/sheet
   • Try similar actions (insert row, sort, recalc) in a brand‑new blank workbook.
   • If the error only occurs in this one workbook or sheet, the content or structure of that file is the cause.
2. Look for heavy or excessive formulas
   Typical triggers are:
   • Very large ranges with formulas (e.g., thousands of rows/columns).
   • Complex formulas that reference many cells or entire columns.
   • Volatile or iterative functions (e.g., many dependent formulas recalculating at once).
   Actions:
   • Press Ctrl+~ (Show Formulas) to see all formulas on the sheet.
   • Identify areas with dense formulas and large ranges.
   • Temporarily clear or simplify formulas in a copy of the file to see if the error stops.
   • Where possible, replace complex formulas with simpler ones or with static values (Paste Special → Values) for data that no longer needs to recalc.
3. Reduce recalculation load
   • Avoid formulas that reference entire columns (e.g., A:A) if the sheet is large; use exact ranges (e.g., A1:A1000).
   • Break very complex formulas into helper columns so each step is simpler.
   • Remove unused named ranges, links, or formulas.
4. Check other heavy elements on that sheet
   The following can also consume resources and trigger the error:
   • Many shapes/objects (images, icons, text boxes).
   • Complex PivotTables or many PivotTables pointing to large ranges.
   • Complex charts with many data points.
   • Macros/VBA that run on calculation.
   Actions:
   • Delete or reduce unnecessary shapes and objects.
   • Simplify PivotTables (smaller source ranges, fewer fields) and charts.
   • Temporarily disable macros that run on Worksheet_Change or Worksheet_Calculate to see if the error disappears.
5. Test calculation mode and recalc behavior
   • Set calculation to Manual (Formulas → Calculation Options → Manual).
   • Press F9 to recalculate and see if the error appears immediately or only after certain edits.
   • This helps pinpoint which action or area of the sheet triggers the error.
6. If the workbook is small but the error persists
   The context shows that even small workbooks can show this error when Excel or Windows is corrupted. In similar cases, users resolved persistent “ran out of resources” errors only by reinstalling Windows or fully repairing Office. Before going that far:
   • Close all other apps and Excel files and try again.
   • Run an Online Repair of Office (from Windows Settings → Apps → Installed apps → Microsoft 365/Office → Modify → Online Repair).
   • If the error appears even in a new, tiny workbook with a simple formula, this strongly suggests an environment/installation issue rather than the workbook content.

If, after simplifying formulas and objects on that one worksheet and repairing Office, the error still appears only for that file, create a new workbook and copy data over in sections (values first, then formulas in small blocks) to identify the specific range or feature that triggers the error.

References:

• How to troubleshoot "available resources" errors in Excel
• Problem with ran out resources when canculation in excel - Microsoft Q&A