Formulas aren't automatically updating

  • Thread starter Thread starter Monica
  • Start date Start date
M

Monica

Help! My formulas have stopped automatically updating
themselves when new values are entered in the cells they
refer to. If I hit F2 to edit, then hit enter, it
updates, but not otherwise.
 
Monica said:
Help! My formulas have stopped automatically updating
themselves when new values are entered in the cells they
refer to. If I hit F2 to edit, then hit enter, it
updates, but not otherwise.
Click to expand...

Look in
Tools > Options > Calculation tab
and check that Calculation is set to Automatic.
 
Back
Top