Refresh Pivot Tables with one hit
 

I have the source table and mulitple pivot tables residing in the same file.
Is there a way to refresh multiple pivot tables simultaneously instead of
manually tabbing into each pivot table worksheet to hit refresh?

Refresh Pivot Tables with one hit
 

You could add the Refresh All button to the Pivot Table toolbar, then
click it to refresh all the pivot tables and queries in the workbook.

cockatoo wrote:
I have the source table and mulitple pivot tables residing in the same file.
Is there a way to refresh multiple pivot tables simultaneously instead of
manually tabbing into each pivot table worksheet to hit refresh?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Refresh Pivot Tables with one hit
 

I asked this question sometime ago and it worked fine.

http://www.microsoft.com/office/comm...xp=&sloc=en-us

HTH

AW

"cockatoo" wrote:

I have the source table and mulitple pivot tables residing in the same file.
Is there a way to refresh multiple pivot tables simultaneously instead of
manually tabbing into each pivot table worksheet to hit refresh?

Refresh Pivot Tables with one hit
 

Thanks to all replies. Great help, especially ref to replies to ArticWolf's
same query that stated that the Refresh All button is from the External Data
toolbar.

"cockatoo" wrote:

I have the source table and mulitple pivot tables residing in the same file.
Is there a way to refresh multiple pivot tables simultaneously instead of
manually tabbing into each pivot table worksheet to hit refresh?