My formulas aren't updating

My formulas are on sheet 1 and all the values are on other sheets. When I change the values on the other sheets, sheet 1 stays the same until I click in each cell with the formulas and press enter.

Why is it doing this??

Good afternoon AnnaV

It sounds as though your recalculation mode has been set to manual. Set it back to automatic via Tools > Options, under the Calculation tab.

HTH

DominicB

Lifesaver!!

No problem.

Thanks for the feedback.

DominicB

Same here! thank you