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.
Any chance you could help me figure out what's wrong with my workbook? I am getting the message as well.
I am trying to put together a stock dashboard. One of the functions I want to implement is to sort out my current holdings. But my formula (on Dashboard!B5, highlighted in yellow) returned the same error that everybody here did. Not sure why is it happening since there should be no cyclic referencing and the lady on Youtube could do it. Attaching the link for the Youtube tutorial as well. Many thanks in advance!
https://www.youtube.com/watch?v=D44EDant0rs&t=1201s
Not sure what you'd like to calculate, but this formula
=SORT(UNIQUE(FILTER(Ledger[Stock],SUMIF(Ledger[Stock],Ledger[Stock],Ledger[Position])<>0)))won't work, I guess internal cycling.