VBA to Refresh All Pivot Tables

Описание: In this video I demonstrate how to create a VBA macro that will refresh all of the pivot tables in your worksheet. VBA code below:


Sub RefreshPivotTables()
Dim PT As PivotTable
For Each PT In ActiveSheet.PivotTables
PT.RefreshTable
Next PT
End Sub