Forum Discussion
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.
SergeiBaklan Hi Sergei, appreciate all the help you provide here. I tried getting the inquire add-in to find this error myself, but not having any luck. Are you able to identify where the issue is in the attached spreadsheet? It is so simple and there are not any complicated formulas.
In D825, the formula is {=D795:DD764844:D803} which is non-sense, and most likely a typo.
- Thank you so much, is it possible there is more than one error? I deleted that text but am still receiving the message.
SergeiBaklan Thank you so much for your help with this!!
