Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated How to find the cells which contain error?
It takes years to open your file, on my more or less modern computers its stays on
consuming all memory.
What I'd suggest if you are able to open your own file
- make a copy of it
- delete sheets one by one, till Out of resource alert disappears. Doesn't matter if you have errors in calculations
- return back to previous step with error and try to find wrong array formula (most probably that's the reason)
- if your Excel version supports Inquiry it helps to localize the formula.
Right now I waited about 15 minutes and still on about 30% of calculations. Sorry, the task is quite time consuming.
If I have more time will try again.