Pivot table update

[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?

 

[Debra Dalgleish]

You can use a dynamic range as the data source. There are some
instructions here:

http://www.contextures.com/xlPivot01.html#Dynamic

 

[Donald Busha]

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

 

[aablank]

Debra: Thank you. This is exactly what I need.

-----Original Message-----
You can use a dynamic range as the data source. There are some
instructions here:

http://www.contextures.com/xlPivot01.html#Dynamic



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.