Automatic Update of Pivot Table Data

[nornrich]

Hello All,

I am looking for a way to automatically update pivot table data, upon opening of an Excel file. Is this something that I can set to do automatically everytime the worksheet is open, or do I have to go in and hit the refresh data button?

Regards,

Rich

Richard Nornhold, PE
nornrich@redrose.net

 

[joerd]

Right click inside the Pivot table, and select Table Options...
At the bottom, under Data options, check the mark near Refresh on open.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.