Forum Discussion

Philip Ogley's avatar
Philip Ogley
Copper Contributor
Apr 10, 2018
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...
  • Tomasz Kocur's avatar
    Apr 10, 2018
    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