Forum Discussion

Jeffrey Campbell's avatar
Jeffrey Campbell
Copper Contributor
Jul 20, 2018

Excel formulas not updating

HI folks, I am not an excel professional so bear with me. 

 

I use a simple spreadsheet that we've developed over the years to enter certain data into and answer yes or no questions. Based on this information, formulas in other cells calculate costs and time. The end result is our estimate (Ballpark). This has served us well for many years... gradual improvements over that time.

 

Today the worksheet has decided not to automatically calculate the formulas. Old results remain after changing other cells. UNLESS I click on the cell with the formula (double click) and hit Enter. Then the cell updates the figures. Needless to say this is a pain in the butt. 

 

Anyone experience this before and is there a quick fix?

 

thanks in advance.

Jeff

3 Replies

  • James_bikes's avatar
    James_bikes
    Copper Contributor

    Jeffrey Campbell 
    When I link to other spreadsheets, sometimes I have to DELETE (the cells with the LINKS) and SHIFT LEFT to get clean cells to that the links to other spreadsheets start updating again.

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi Jeffrey,

     

    It seems that the calculation option is set to manual!

     

    So, please go to:

    Formulas >> Calculation >> Calculation Options >> Automatic

     

    Regards

    • Jeffrey Campbell's avatar
      Jeffrey Campbell
      Copper Contributor

      BINGO!

       

      Thanks a lot. Not sure how that got changed because I didn't even know it was an option.

       

      Awesome help though... and quick response! Love it!

       

      Jeff

Resources