Pivot table update

  • Thread starter Thread starter aablank
  • Start date Start date
A

aablank

I have a number of pivot tables based on the same data
worksheet. Right now when I add more data, I have to go
to each table and update the range manually. Is there a
way to do it all at once?
 
There is a refresh button under the data menu in excell
(2000 at least), you can click on any field in the pivot
table then click the refresh button on data tab, should
refresh all the data, i tested in a recent project and it
worked. You can even add it as a custom menu button for
easy recognition. Good luck,
Don
 
Back
Top