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.
Sir, I am getting the "Excel ran out of resources error from the following file.
Can you please help me rectify the same, further can you please explain how to diagnose the same.
I can do nothing without the file. If you have Inquire in your version of Excel, you may analyse workbook and check which array formula is wrong.
