Pivot table refresh

K

Kevin

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

Thanks for any help.
 
J

Jason Morin

From the macro recorder:

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

HTH
Jason
Atlanta, GA
 
T

Toby Erkson

Yep. Use this to refresh all pivot tables in the workbook:
ActiveWorkbook.RefreshAll
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Refresh 5
Pivot table report invalid 0
Power Pivot. Yikes. 0
Write back from pivot table 1
Write back from pivot table 0
Retain pivot table formatting after refreshing data 0
Pivot Table cell values 1

Top