Forum Discussion
Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."
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.
Sergei, I'm amazed at how much time and effort you put in to help those of us who do not have near your understanding of Excel! Mad props to you, and may you be blessed in all ways for all the good you do! You are an outstanding citizen!
Respects,
Richard
Hi Richard, very much appreciate your feedback, thank you. That's mainly experience, some are experienced in Excel, some in finance, some in cooking. Who loves what more.
SergeiBaklan I am amazed at how much you have helped the online community, thank you. Clearly the people you have helped have known more than me as I can't even figure out how to send you my spreadsheet to get some help 😞
I am having the same issue as the others in this chain.
Thank you
Nicola
