Hi all,
I'm trying to create a macro that fresh all the pivot tables within a sheet of a shared workbook.
I do not want to use the Activeworkbook.RefreshAll because I don't want to refresh other people works on a different sheets.
Is there an "ActiveSheets.RefreshAll"?
Right now I have:
ActiveSheet.PivotTables("PivotTable1").RefreshTable
ActiveSheet.PivotTables("PivotTable2").RefreshTable
and so on....
everytime I add/delete a table, I have to go back and change the macro.
I do not have a "Refresh All" Exclamation sign in the Excel, just "Refresh Data" only.
Thanks
I'm trying to create a macro that fresh all the pivot tables within a sheet of a shared workbook.
I do not want to use the Activeworkbook.RefreshAll because I don't want to refresh other people works on a different sheets.
Is there an "ActiveSheets.RefreshAll"?
Right now I have:
ActiveSheet.PivotTables("PivotTable1").RefreshTable
ActiveSheet.PivotTables("PivotTable2").RefreshTable
and so on....
everytime I add/delete a table, I have to go back and change the macro.
I do not have a "Refresh All" Exclamation sign in the Excel, just "Refresh Data" only.
Thanks