Forum Discussion

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 n...

excel

SergeiBaklan
Oct 08, 2018
Hi Alan,

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

SergeiBaklan

Diamond Contributor

Oct 08, 2018

Hi Alan,

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

Alan Taylor

Copper Contributor

Oct 08, 2018

Thanks Sergei - much appreciated I have been looking for the little devil for two hours 😉

SergeiBaklan
Diamond Contributor
Oct 08, 2018
You are welcome