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.
Hey, I'm suddenly having this issue, I do have one crazy sheet full of sumifs formulas but I don't think this is an end-of-game excel workload. Can you please take a look at my spreadsheet? The sheet that gives trouble is "DCF Flujo". You can trigger the problem by cutting rows 179:183 and pasting them at row 143. That's what Im trying to do and can't.
https://1drv.ms/x/s!Av2KjWsNOTPLgstHqKEITj7MMqGijA?e=KaMpGA
Much appreciated!
I'm not sure which exactly formula gives an error, but if you add in AU1 next month (Jan 01, 2023) it works.