Forum Discussion

keith90's avatar
keith90
Copper Contributor
Oct 28, 2021
Solved

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

 

  • Rohan80's avatar
    Rohan80
    Copper Contributor
    Hi 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.
    • Rohan80 

      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.

      • Rohan80's avatar
        Rohan80
        Copper 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.

    • keith90's avatar
      keith90
      Copper Contributor
      Wow! Thanks that works. I guess there was a typo in the worksheet that I missed.

      Thanks again for your help!
      • keith90 , you are welcome.

         

        Could be typo and/or you shifted from previous Excel on the one which supports dynamic arrays.

Resources