Forum Discussion
Solved
Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."
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."...
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.
Can you help me figure out what's wrong with my workbook. I'm also getting this error. I understand the logic of your proposed solution, I just can't identify where the error is in my workbook. SergeiBaklan
That is wrong formula
'=VLOOKUP('Klabin Hou'!1:1048576,11,0)in hided sheet 'Combined Klabin'!N60
I commented it.
If your Excel version support Inquire analyse workbook with it and check suspicious array formulae.
SergeiBaklan Hey, I have spent hours trying to find the issue with the same error that other people had, and the excel is extremely slow. Would you be able to have a look?
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
