A reservation total stays at 10 even after an input changes. Select the total cell and verify that it still contains the formula you expect.

Check Manual and run Calculate Now

In a test copy, put 6 and 4 in B2:B3 and =SUM(B2:B3) in B4. Change B2 to 8. If B4 stays at 10, check Formulas → Calculation Options in Ulet. Use Calculate Now and expect 12.

A valid SUM still shows the earlier result while manual calculation is active.

Illustrated stale result. Inspect the actual formula before diagnosing the mode.

Verify automatic updates with one more edit

Select Automatic if formulas should recalculate as you type. Change 8 to 9 and expect 13. Confirm any summary on another tab agrees. If the result still differs, check the source values and referenced range before saving.

Calculate Now gives 12 and a second edit in Automatic gives 13.

Illustrated control check. Verify a dependent summary too.

Microsoft’s formula recalculation reference