There should be a Refresh All feature, enabling all pivot tables .
 

....within a file or workbook to be refreshed with a single click.

Hi
try the following macro
sub foo()
activeworkbook.refreshall
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

"JL1981" schrieb im Newsbeitrag
...
...within a file or workbook to be refreshed with a single click.