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 have a problem with my excel error. The error message is "Excel ran out of resources while attempting to calculate one or more formulas...." I tried many tips and corrected formula errors but still has this error message when I save. Hopefully you can detect the problem.
Thanks very much, Sergei
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.
I am having the same error come up with my file. Can you please help me with this error? I have tried the various help options listed and cannot rectify. Can I send you the file for help?
I could try, please send the file with Private Message here.
SergeiBaklan How did you find the circular reference? I have a similar issue in my workbook, but xcel "can't show it"
Thanks
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.
