What's the best way to have all your pivot tables refresh in one macro Instead of activating the sheet, and using the following for each PivotTable#
ActiveSheet.PivotTables("PivotTable#").PivotCache.Refresh
I want a loop on all them so you dont need this.
ActiveSheet.PivotTables("PivotTable#").PivotCache.Refresh
I want a loop on all them so you dont need this.