Pivot table refresh

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Is it possible to refresh a pivot table through the use of
a macro and command button?

Thanks for any help.
 
From the macro recorder:

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh

HTH
Jason
Atlanta, GA
 
Yep. Use this to refresh all pivot tables in the workbook:
ActiveWorkbook.RefreshAll
 
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

Pivot Table Refresh 5
Automatically Refresh Pivot Table Data 2
PivotTable auto-refresh with external data 4
Refreshing Pivot Tables 2
Adding data to a 2007 pivot table 2
Pivot tables - Refresh issues 2
Excel VBA For excel 0
Pivot Table Refresh Not Updating Drop Down List 1

Back
Top