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.
I am also having this error that never occured before i upgraded from Excel 11 recently. I am on a mac
I commented formulas in 'Food What'!C91 (circular reference) and in 'Payroll 2021'!AA40 (reference on entire column, '='C:\Users\LEFDPDirector\Downloads\[report1628717061286.xls]report1628717061286'!$1:$1048576)
Not sure which formulas shall be, but now there is no "out of resources" error.
- @sergei bakln thank you this is so very helpful. what did you do to find the problems? they were ruining my experience of excel.
SergeiBaklan Thank you so much this is very helpful. What is your process for finding the errors? This was ruining my experience of excel and would like to know what to do if it happens again.
I check the workbook with
and review array formulas, usually such kind of errors are in them.
In addition
