Forum Discussion
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.
SergeiBaklan hi! I have the same issue. How do i find the cell containing the error?
Thank you
First issue in 2021
Second one in 2019
I change both on 2021-12-13m have no ide what it shall be.
I am getting an error as well.
Here is the formula:
=INDEX('VG OF FRISCO-F'!A1:AR263,MATCH('VG OF FRISCO-F'!5:5,'Facility Summary Data'!B6,0),MATCH('VG OF FRISCO-F'!A:A,'Facility Summary Data'!B5,0))
Perhaps you mean
=INDEX('VG OF FRISCO-F'!A1:AR263,MATCH('Facility Summary Data'!B6,'VG OF FRISCO-F'!5:5,0),MATCH('Facility Summary Data'!B5,'VG OF FRISCO-F'!A:A,0))when it works. Not sure what you'd like to calculate.
