Hi,

Right click on the pivot table and choose Table Options.
In the data options area in the bottom left hand corner of the form, tick the "Refresh On Open" checkbox.

Hope that helps...