asked on VBA Excel: Refresh pivot tables & tables automatically
Hello experts, I have the following procedure which allows me to refresh the various pivot tables I would like to add some enhancements:
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.
Sub Refresh_Pivot()
Dim PT As pivotTable
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each PT In WS.PivotTables
PT.PivotCache.Refresh
Next PT
Next WS
End Sub
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.
Microsoft OfficeMicrosoft ExcelVisual Basic ClassicVBA
Last Comment
Subodh Tiwari (Neeraj)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok, I added in ThisWorkbook and it works perfectly. Thank you again for your help!
You're welcome! Glad it worked as desired.
Thanks for the feedback.
Thanks for the feedback.
Should I add those procedures inside modules, Sheets or ThisModules?