You might have the sheet set to manual calculation - go to Tools |
Options | Calculation (tab) and ensure that Automatic is ticked. If you
want to leave it at manual, you can press F9 to force Excel to
recalculate.

Hope this helps.

Pete