Forum Discussion
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
Hi Alan,
Please check in ribbon Formulas tab if Calculation options are set on Automatic
Hi Alan,
Please check in ribbon Formulas tab if Calculation options are set on Automatic
- Thanks Sergei - much appreciated I have been looking for the little devil for two hours 😉
You are welcome
Richard QuanMicrosoft
On ribbon File->Options->Formulas and check your calculation is automatic
Thanks Richard.
Problem sorted
Alan
