none
excel formulas stop working RRS feed

  • Question

  • I have a co-worker who has been working with a few spreadsheets and at times, the formulas stop working, meaning when he puts info in, it does not update the totals.

    What do we do.

    Ken Basche

    Tuesday, November 20, 2012 9:42 PM

Answers

  • Let your co-worker try the following:

    Activate the Formulas tab of the Ribbon.

    In the Calculation group, click Calculation Options and make sure that Automatic is selected.


    Regards, Hans Vogelaar

    Tuesday, November 20, 2012 9:48 PM