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.
shaunkagawa
Aug 04, 2021Copper Contributor
What would the correct formula be? SergeiBaklan
SergeiBaklan
Aug 05, 2021MVP
Depends on what it shall to return, I don't know the logic behind.
- TanmayB19Aug 07, 2022Copper Contributor
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
- SergeiBaklanAug 09, 2022MVP
TanmayB19 , file is not shared, I can't access it.
- Yuliya1610Nov 16, 2022Copper Contributor
I have really strange problem with my spreadsheet. It works normally with Excel 2016. But in corporate version of Office 365 the same spreadsheet shows "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated" I have tried to change number of calculation threads in Advanced option, I used 1 and used 2. After entering 2 - message disappear, but formulas do not calculated at all. Maybe you have any ideas ?
Thank you!
Best regards, Yuliya
Link to file:
https://drive.google.com/uc?export=download&id=1DHQL7EkWosmAz4-bo6cC0eVmB17INhvi
- JiaJiaOngAug 13, 2021Copper Contributor
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. ^^
- SergeiBaklanAug 13, 2021MVP
I commented formula in 'S1B DATA'!AZ1
- JiaJiaOngAug 15, 2021Copper Contributor
SergeiBaklan Thank you so so much! I have removed that figure and it works perfectly fine now.