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.
Sergei you seem to be quite proficient in resolving this known Excel issue. I have a co worker who has completely formatted their excel sheet and still receiving this memory issue error message. I know your replies are from a couple years back, but I wanted to see if you could assist me as well.
Hello Chris,
Try to find whole column references in formulas, such as $D:$D, and replace them by their actual boundaries, for instance $D1:D$2000. That should go a long way towards getting rid of the error message.
Please note you can use a third-party tool for this.
Hey Stephane,
This error occurs even within fresh Excel sheets through simple data entry with no attached formulas. Would using your solution resolve an issue like this?
Thanks
Hello again Chris,
Formulas of the entire workbook matter, not only the current sheet. So I guess we are talking about formulas from sheets other than the fresh one.