Forum Discussion

GaneshIyer's avatar
GaneshIyer
Copper Contributor
Dec 19, 2020

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."...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 19, 2020

    GaneshIyer 

    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's avatar
SergeiBaklan
MVP

GaneshIyer 

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.

courtneykeene18's avatar
courtneykeene18
Copper Contributor
Jun 03, 2021

SergeiBaklan 

 

Any chance you could help me figure out whats wrong with my workbook?  I am getting the message as well.  I am a complete novice at excel but am trying to put together a workbook to calculate show estimates/costs for venue events.  I have been reading lots of answers on how to fix this error but cant figure it out.  Any help is appreciated!

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 03, 2021

    courtneykeene18 

    I see no problems with your file, it works correctly (at least without mentioned error).

    • khoang975's avatar
      khoang975
      Copper Contributor
      Jun 07, 2021

      SergeiBaklan 

      I have a problem with my excel error.  The error message is "Excel ran out of resources while attempting to calculate one or more formulas...." I tried many tips and corrected formula errors but still has this error message when I save.  Hopefully you can detect the problem.  

      Thanks very much, Sergei

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jun 08, 2021

        khoang975 

        I found two issuee

        -  'WB7-STS Structure IPL Cal.'!J473 had reference as =-475:29776.432, I changed value on zero

        -  'FWD Cargo Bay'!I35 had circular reference (==I35+I117+I342+I490), changed on =I117+I342+I490

         

        Please check attached file if works in your environment.

  • louise21's avatar
    louise21
    Copper Contributor
    Jun 16, 2021

    SergeiBaklan HI i have an excel spreadsheet that is showing a formula issue but i dont believe i have any formulas on there. Please can it be checked and either the formula removed or point me in the direction of where the error is. thanks. 

      • louise21's avatar
        louise21
        Copper Contributor
        Jun 17, 2021

        SergeiBaklan i have removed that figure - it was not needed! thanks very much for spotting that! 🙂

Resources