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.
Any chance you could help me figure out whats wrong with my workbook? I am getting the message as well. I am a complete novice at excel but am trying to put together a workbook to calculate show estimates/costs for venue events. I have been reading lots of answers on how to fix this error but cant figure it out. Any help is appreciated!
SergeiBaklan HI i have an excel spreadsheet that is showing a formula issue but i dont believe i have any formulas on there. Please can it be checked and either the formula removed or point me in the direction of where the error is. thanks.
That's in 'Open Complaints'!M13
'=+CB1413:MGD141413:M13:MA1413Not sure what you'd like to calculate here, just commented it. Please see attached.
SergeiBaklan i have removed that figure - it was not needed! thanks very much for spotting that! 🙂
louise21 , you are welcome