You probably just have manual calculation turned on (if everything updates when you press F9, you have).

Go to options > calculation > automatic and you should be good to go.