Forum Discussion
Solved
Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."
I am having issue with excel sheet which keeps showing me this issue "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas can not be evaluated."...
In cell D36 you have formula =30:294001 which means you instruct Excel to return all rows from 30 to 294001. Includes row in which the formula is. Kind of cyclic reference and never ended loop.
If you remove this formula it works.
Hey there, thanks for all your support in this thread / issue. how would I go about identifying these types of formulas myself. I have a file that's fairly large and in which I cannot remove sensitive info to give to you. SergeiBaklan
It depends. If you have Inquire in your version of Excel you may do Workbook Analysis and check suspicious array formulae. Not necessary that give an answer. Otherwise delete your sheets / ranges one by one till such error disappears. Other words, try to localize it.