It is easy to do with a macro. It just requires this one line of code...

ThisWorkbook.RefreshAll

--
HTH...

Jim Thomlinson


"ArcticWolf" wrote:

Hi,

I have a worksheet with 10 PT's in, but have to refresh each table when the
source data changes. Is there a way I can refresh all the PT on the
worksheet at once?

Thanks in advance,

AW