Refreshing all the pivot tables in my excel workbook with a macro
Yes. ThisWorkbook.RefreshAll Or, if your Excel version is old enough, Dim Sheet as WorkSheet, Pivot as PivotTable For Each Sheet in ThisWorkbook.WorkSheets For Each Pivot in Sheet.PivotTables Pivot.RefreshTable Pivot.Update Next Next