Refresh all pivots

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a command that allows me to refresh all the pivot tables in my workbook. I have about 5 and don't want to refresh 1 by 1.
Thanks in advance!
 
Hi
use the following macro:
sub refresh_it()
activeworkbook.refreshall
end sub
 
Open the External Data toolbar (View>Toolbars>External Data)
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
How do I save Pivot Table Data 4
Pivot ungrouping on refresh? 3
Pivot Table Refresh not working properly 1
grouping multiple tables Excel 2007 3
Refreshing a pivot table 1
Access Form Refresh 1

Back
Top