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?