Refresh all pivot tables in a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi Phil

I think there is a refresh all keyword.

Phil Wales said:
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.
Click to expand...
 
Use the RefreshAll method:

ActiveWorkbook.RefreshAll

Or, open the External Data toolbar, and click the Refresh All button.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh order when refreshing all in a workbook 1
Refreshing Pivot Tables 1
Refreshing a pivot table 1
how do i refresh a pivot table report in a shared file 1
Cannot Open Pivot Table Source File 0
Pivot ungrouping on refresh? 3
Pivot table 1
Pivot Table Refresh not working properly 1

Back
Top