Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."

[GaneshIyer]

I am having issue with excel sheet which keeps showing me this issue "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas can not be evaluated."

Never had seen this before- pls guide.

[#2]

@SergeiBaklan 

Hello, I've been getting the same error on multiple sheets. Hoping you can help me out with this. 

[#3]

@JohnG0213 

In both files NewQuotationCfm!O11 (commented)

[#4]

@SergeiBaklan 

Really urgent 

I cannot find the wrong formula

[#5]

@SergeiBaklan 

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!

Youtube tutorial 

[#6]

@Tomylor 

Wrong formula is in R1

[#7]

@SergeiBaklan 

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.

[#8]

@Sergei Baklan 

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!

[#9]

@EdelLau 

It's here in Data sheet

[#10]

@Arthur2075 

That is in 'Main Sheet'!LN3

[#11]

@kitsyip 

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. 

[#12]

@steph88 

Hello,

Regarding Ecology Planner 270821.xlsx, this file has two problems. One is circular references, a problem addressed by Sergei Baklan. Another is the "Excel ran out of resources ..." error and this problem is left unadressed so far.

Actually, the style reduction tool sees exactly one "slow calculation" in it, the one triggering the blocking error message in Excel.

It's in September ! N266

 Replace the formula in it :

{=_xlfn.SINGLE(INDEX($I$5:$I$239;SUMPRODUCT(MAX((N$5:N$239=BL266:$FI254266)*(ROW(N$5:N$239))))-ROW($I$5)+1))}

by

 {=_xlfn.SINGLE(INDEX($I$5:$I$239;SUMPRODUCT(MAX((N$5:N$239=BL266:$FI266)*(ROW(N$5:N$239))))-ROW($I$5)+1))}

and that fixes the problem. Hope it helps.

[#13]

@GaneshIyer 

If to change this

on proper formula or constant it shall work.

[#14]

@SergeiBaklan Hi Sergei, appreciate all the help you provide here. I tried getting the inquire add-in to find this error myself, but not having any luck. Are you able to identify where the issue is in the attached spreadsheet? It is so simple and there are not any complicated formulas.

[#15]

@kinokotako 

In D825, the formula is {=D795:DD764844:D803} which is non-sense, and most likely a typo.

[#16]

Thank you so much, is it possible there is more than one error? I deleted that text but am still receiving the message.

[#17]

@kinokotako 

Yes, that's more than one such error

I tried to correct, please check attached.

[#18]

@SergeiBaklan 

Sergei, I'm amazed at how much time and effort you put in to help those of us who do not have near your understanding of Excel!  Mad props to you, and may you be blessed in all ways for all the good you do!  You are an outstanding citizen!

Respects,

Richard

[#19]

@Richard_Parkinson 

Hi Richard, very much appreciate your feedback, thank you. That's mainly experience, some are experienced in Excel, some in finance, some in cooking. Who loves what more.

[#20]

@SergeiBaklan Thank you so much for your help with this!!

[#21]

@SergeiBaklan I am amazed at how much you have helped the online community, thank you. Clearly the people you have helped have known more than me as I can't even figure out how to send you my spreadsheet to get some help 😞 

I am having the same issue as the others in this chain.

Thank you

Nicola