Hi

How to write a macro to refresh all pivot tables in a workbook?

I'm not a VB expert - but

You should just be able to record a macro while clicking the refresh button
for each pivot table, then assign a button to it.





"nc" wrote:

Hi

How to write a macro to refresh all pivot tables in a workbook?

Hi Phil

I think there is a refresh all keyword.

"Phil Wales" wrote:

I'm not a VB expert - but

You should just be able to record a macro while clicking the refresh button
for each pivot table, then assign a button to it.





"nc" wrote:

Hi

How to write a macro to refresh all pivot tables in a workbook?

Use the RefreshAll method:

ActiveWorkbook.RefreshAll

Or, open the External Data toolbar, and click the Refresh All button.

nc wrote:
Hi

How to write a macro to refresh all pivot tables in a workbook?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html