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.
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
