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
 
Top