I recently had a client who was having an issue with excel. When they had cells with formulas, if they updated the cells the formula would not change until they had saved the document. There is a simple option in excel which enables this.

If excel is not updating cells with formulas until you save, use the following method to make it automatic.

  1. Go to File -> Options
  2. Select “Formulas” from the left hand side bar
  3. Under Calculation Options, select automatic for workbook Calculation