Hello experts, I have the following procedure which allows me to refresh the various pivot tables I would like to add some enhancements:
Dim PT As pivotTable
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each PT In WS.PivotTables
1. Run the procedure after I change a data or after a save
2. Include in the procedure the refresh of the various tables in the workbook
Thank you very much for your help.