Refreshing Multiple Pivot Tables at once?
 

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

Refreshing Multiple Pivot Tables at once?
 

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

Refreshing Multiple Pivot Tables at once?
 

Perfect, just what I needed :)

Thanks for the swift reply Jim

"Jim Thomlinson" wrote:

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

Refreshing Multiple Pivot Tables at once?
 

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.

ArcticWolf wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html