Forum Discussion
Alert on Excel unable to recalculate
Hi I keep getting an alert every time I hit return in a cell " "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." Pleas...
olly_35 Sounds like your spreadsheet has a serious issue! Without seeing your spreadsheet this is very hard to troubleshoot however. Tip:
- Open a copy of the file
- Delete one worksheet
- Save-as to a different name
- Close Excel
- Open newly saved file
- If issue persists, repeat from step 2
Once you have located the sheet, go back to 1 and delete just that sheet to make sure it is that sheet causing your issue.
If you have pinned down the worksheet, you could do similar actions by removing formulas from the sheet until the problem goes away.