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.
Sorry, I'm not able to open your workbook. It says
Try to localize an issue removing sheets/ranges till an error disappears.
Sergei,
Could you check your private messages from me - I have the file there for you to download. Not sure why its not opening with that link...
Could you check your private messages from me - I have the file there for you to download. Not sure why its not opening with that link...
SergeiBaklan here is the file that is getting this error. Can you help me locate the problem?
Not sure what it was exactly. I simply Del few dozens of rows after #181 (they looks like empty) in hidden sheet Lag by Week. Calculation error disappears.
SergeiBaklan I have no idea how you located the problem but all I can say is thank you, thank you!!!!
