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.
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.
Can someone please help me, I have been getting this error recently and i have searched every sheet but cant find what is causing it. When i first released this sheet to my coworkers it had no issues but recently i cant do anything without the error popping up all the time and I don't know what's causing it.
Could someone take a look and see if they can see what im getting worng.
Thanks
Tim
There are whole-range references, such as $D:$D all over the place in hidden sheet "PM-SS Labour location".
Take this formula in H7 : =SUMIFS(' BTTimeClockDataImport'!$L:$L;' BTTimeClockDataImport'!$E:$E;'PM-SS Labour Allocation'!$B$5;' BTTimeClockDataImport'!$D:$D;$C7;' BTTimeClockDataImport'!$S:$S;LEFT($D7;10);' BTTimeClockDataImport'!$C:$C;">="&F$1;' BTTimeClockDataImport'!$C:$C;"<"&I$1)
Just replacing $D:$D (and $E:$E, ...) by $D1:$D2000 (and ...) everywhere goes a long way towards avoiding Excel slow down to a crawl.
TimMcBrideCanada , I opened the file and had no error alerts. Which exactly error do you have and how to reproduce it?
