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.
That is wrong formula
'=VLOOKUP('Klabin Hou'!1:1048576,11,0)in hided sheet 'Combined Klabin'!N60
I commented it.
What would the correct formula be? SergeiBaklan
Depends on what it shall to return, I don't know the logic behind.
SergeiBaklan can you help me out . facing the same error . tried lots of solutions still wont work.https://onedrive.live.com/edit.aspx?cid=dd327ff56d76308c&page=view&resid=DD327FF56D76308C!566&parId=DD327FF56D76308C!101&app=Excel&wacqt=mru
TanmayB19 , file is not shared, I can't access it.
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. ^^
I commented formula in 'S1B DATA'!AZ1
