Excel formula fails to update

B

barry

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.
 
R

Roger Govier

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.
 
Top