Refreshing Multiple Pivot Tables at once?

A

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
 
J

Jim Thomlinson

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

ThisWorkbook.RefreshAll
 
D

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.
 
Top