I suspect that you have Calculation set to manual with recalc before saving.

Try this:
Tools.Options.Calculation
Select Automatic

Does that help?

Ron