Forum Discussion
Help on Error Message "Excel ranout of resources while attempting to calculate one or formulas..."
Hi, I am at a lose here as I have tried everything that I could research on line. I have a file that just suddenly starting giving the "Excel ran out of resources while attempting to calculate one or formulas. As a result, these formulas cannot be evaluated". I did not created the worksheet but it does not look overly complicated but I am not much of a Excel user to know for sure?
Office365 Excel 64bit on Windows 10 machine.
I have tried;
-Disabling multi-threading
-Switched to manual calculation
-Error check formals.
-removed any images or extra data as far as I can tell.
-Modified # of calculation threads from 1-8 in Excel and same with # of processors via the taskbar.
-tried copying values only to another sheet, and still gives there error though there are formulas on the page. How that works I don't know?
-disable add-ins
Of course the person who created the file is no longer working at the company and so I wouldn't even know where to begin to rebuild it.
Any help on this would be appreciated!
Thanks
KQ
7 Replies
- Rohan80Copper ContributorHi Keith. Sorry. I have the same issue with my Excell workbook. But I am not sure how to POST my question to the Community., CAn you tell me how to POST a question/inquiry to the Community dash board pls. Thanks, Rohan.
- SergeiBaklanDiamond Contributor
To check what's wrong we need the file. Please remove sensitive information and attach it to your post
or share through OneDrive or like.
- Rohan80Copper Contributor
SergeiBaklan Thank you for the msg. But I cannot find any link to upload my questioned XL file in to the chat. Can you advise how I can upload the XL file pls.
I can see the screenshot kind of thing you have shown me in your reply. But in my chat page, I cannot see any link / button that would allow me to upload the XL file. PLs help.
Can I e mail to you. Thanks. Rohan.
- SergeiBaklanDiamond Contributor
- keith90Copper ContributorWow! Thanks that works. I guess there was a typo in the worksheet that I missed.
Thanks again for your help!- SergeiBaklanDiamond Contributor
keith90 , you are welcome.
Could be typo and/or you shifted from previous Excel on the one which supports dynamic arrays.