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]

Cannot move from cell to cell without an error message showing- 'excel ran out of resources'. Can you please advise??????

[#3]

@SergeiBaklan 

Hi, I am also facing the issue where all my excel file shows "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." every time when I key in something. 

Could you please help me to find out what's the problem here?

Thank you. ^^

[#4]

@JiaJiaOng 

I commented formula in 'S1B DATA'!AZ1

[#5]

@SergeiBaklan Thank you so so much! I have removed that figure and it works perfectly fine now.

[#6]

@JiaJiaOng you are welcome, glad it helped.

[#7]

@SergeiBaklanI am also getting that error. Could you please take a look and advise/ fix anything you see wrong. 

[#8]

@AmandaLeong , that was here

[#9]

Thanks so much for your speedy help and diagnosis!

[#10]

@AmandaLeong , you are welcome

[#11]

I am also having this error that never occured before i upgraded from Excel 11 recently. I am on a mac

[#12]

@JEssi2125 

I commented formulas in 'Food What'!C91 (circular reference) and in 'Payroll 2021'!AA40 (reference on entire column, '='C:\Users\LEFDPDirector\Downloads\[report1628717061286.xls]report1628717061286'!$1:$1048576)

Not sure which formulas shall be, but now there is no "out of resources" error.

[#13]

@sergei bakln thank you this is so very helpful. what did you do to find the problems? they were ruining my experience of excel.

[#14]

@SergeiBaklan Thank you so much this is very helpful. What is your process for finding the errors? This was ruining my experience of excel and would like to know what to do if it happens again.

[#15]

@JEssi2125 

I check the workbook with 

and review array formulas, usually such kind of errors are in them.

In addition

[#16]

@SergeiBaklan Hi. How do you find the formula errors in the spreadsheet?  I'm getting the same error message as the original post. Thank you for your time.

[#17]

@BVuka Usually with Inquire, please see previous post here.

[#18]

@Sergei Baklan

 I to am having the same error message, any assistance would be much appreciated

[#19]

@steph88 

It was a circular reference in November!J222.  Change ranges here from IF(COUNTIF(J$5:J$230,... on IF(COUNTIF(J$5:J$220,...

Also in

December!J211

October!J195

September!N241

(all commented)

In November!J237 formula contains ...*(H242ROW(J$5:J$218).. . Commented it.

[#20]

@SergeiBaklan 

can help me figure out about this problem, and return back my excel file to normal. every time i run the formula this pop up come out. i dont know how to reverse this error

[#21]

@ieda89 , if you attach the file I could try.