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.
Hi I seem to have the same problem too. I tried to find the loop or error but I still don't know why the message is popping up. Are you have to have a look? I suspect it's in the data worksheet.
you seem to be a wizard at these, can you have a look a this one with the same error please.
i have tried the error check and it says its fine, but it is not. also i do not have the inquire tab?
any help is much appreciated, sorry for the hijack!
