Automatic Update of Pivot Table Data
Automatic Update of Pivot Table Data
(OP)
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
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





RE: Automatic Update of Pivot Table Data
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.