Forum Discussion
Solved
my auto sum facility
My autosum facility has ceased to update added information i.e. each time I add a value to a autosum column it no longer adds the value to the total and I have to reset the autosum. this has happened to all my spread sheets - can someone please advise - thankyou
- Hi Philip
Go To "FORMULAS" Tab on the ribbon then
on the right end, you have a section named "Calculation"
click on "Calculation Option"
choose "Automatic"
or
go to:
FIle/Options/formulas/Calculation options
click on Workbook Calculation/ Automatic
- Hi Philip
Go To "FORMULAS" Tab on the ribbon then
on the right end, you have a section named "Calculation"
click on "Calculation Option"
choose "Automatic"
or
go to:
FIle/Options/formulas/Calculation options
click on Workbook Calculation/ AutomaticThank you for your help Tomasz - you're a Star - Kind Regards Phil
