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.
Hope it'll be sorted out. I deleted the attachments, in addition you may destroy your link.
Hi I am having a similar issue. I sent you a direct message. Please let me know if you are able to assist. Would very much appreciate your help. Thank you.
Yes, applying any filter I receive such error as well. I tried to play with variants and setting, but so far I didn't find the way how to correct this, if only rebuild workbook. But it is huge.
Lot of formulas which use entire columns for calculations, INDIRECT, stack of many sheets,...
One-processor calculation option also didn't help.
Will try later to play bit more
Office 365 - Tried so far on Excel versions 2210 and 2211 (Monthly Enterprise Channel).
Sometimes the error happens right when I open it. Other times it will be randomly when I update something on a tab. I've noticed it does it frequently when I go to the QV Inventory tab and filter.
Okay, I got your file, on opening and recalculation I see no one error. On which Excel platform/version you are which gives an error?