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.
I found two issuee
- 'WB7-STS Structure IPL Cal.'!J473 had reference as =-475:29776.432, I changed value on zero
- 'FWD Cargo Bay'!I35 had circular reference (==I35+I117+I342+I490), changed on =I117+I342+I490
Please check attached file if works in your environment.
can help me figure out about this problem, and return back my excel file to normal. every time i run the formula this pop up come out. i dont know how to reverse this error
ieda89 , if you attach the file I could try.