Excel formula fails to update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Excel formulae used to always update immediately, and now they don't. I
have a formula: =(K10-F10)*E10. Now when I insert new values for K10, F10
or E10, the result does not update until I click on the results cell and make
to edit it, and press return. Can anyone explain why I have lost the
automatic updating of formulae? TIA.
 
Hi Barry

Calculation must have been set to Manual.
Tools>Options>Calculation>Automatic

Calculation mode gets set as the value in the first workbook that you
open in an Excel session.
 
Back
Top