Forum Discussion

Howard Coffinger's avatar
Howard Coffinger
Copper Contributor
Aug 10, 2018

Formulas have quit working

The formulas in my worksheet have quit functioning. All are very simple add/subtract.

  • Philip West's avatar
    Philip West
    Steel Contributor

    Have you accidently changed the cells the formula are in to Text, or changed the sheet to manual calculation (formula ribbon->calculation options)

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        In ribbon as Philip mentioned or File->Options->Formulas and be sure Automatic is selected

Resources