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.
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
https://1drv.ms/x/s!AiNFIE1v27Sw_UlQLagKw-Yv6-ts?e=adlv4O
TimMcBrideCanada , I opened the file and had no error alerts. Which exactly error do you have and how to reproduce it?