Forum Discussion
GaneshIyer
Dec 19, 2020Copper Contributor
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."...
- Dec 19, 2020
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.
AmandaLeong
Copper Contributor
SergeiBaklanI am also getting that error. Could you please take a look and advise/ fix anything you see wrong.
SergeiBaklan
Aug 18, 2021MVP
- AmandaLeongAug 18, 2021Copper ContributorThanks so much for your speedy help and diagnosis!
- SergeiBaklanAug 18, 2021MVP
AmandaLeong , you are welcome