Pivot table update

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?

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

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

aablank wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
-----Original Message-----
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: Thank you. This is exactly what I need.


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

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

aablank wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.