Forum Discussion
Philip Ogley
Apr 10, 2018Copper Contributor
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...
- Apr 10, 2018Hi 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
Tomasz Kocur
Apr 10, 2018Brass Contributor
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
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
Philip Ogley
Apr 10, 2018Copper Contributor
Thank you for your help Tomasz - you're a Star - Kind Regards Phil