Forum Discussion

Alan Taylor's avatar
Alan Taylor
Copper Contributor
Oct 08, 2018
Solved

autosum not updating result

If I complete a collumn of 12 cells each with a value of 10 and put an autosum into the box beneath I get the result 120. If I change one of the cell values in the column of 12 cells the total does not update unless I force an update by reintering the formula for autosum in the total box.

 

Why? 

 

Thanks Alan T

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 08, 2018

    Hi Alan,

     

    Please check in ribbon Formulas tab if Calculation options are set on Automatic

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 08, 2018

    Hi Alan,

     

    Please check in ribbon Formulas tab if Calculation options are set on Automatic

    • Alan Taylor's avatar
      Alan Taylor
      Copper Contributor
      Oct 08, 2018
      Thanks Sergei - much appreciated I have been looking for the little devil for two hours 😉

Resources