Refreshing Multiple Pivot Tables at once?

[ArcticWolf]

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

 

[Jim Thomlinson]

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

ThisWorkbook.RefreshAll

 

[ArcticWolf]

Perfect, just what I needed

Thanks for the swift reply Jim

 

[Debra Dalgleish]

You can also open the External Data toolbar, and click the Refresh All
button, to update all the pivot tables and external data in the active
workbook.