VBA TO AUTO-UPDATE PIVOT TABLE

Hi everyone! There is an easy way to implement Microsoft Excel VBA code to update the data range/source data automatically. Here you can actually just copy the below code and paste it on your Excel file's VBA Editor, then simply run your code! That's all!!

You can also check the video for further information..

Copy This: 

1. Sub UpdatePivotTables()
2. Dim ws As Worksheet
3. Dim pt As PivotTable
4. 
   
5. For Each ws In ThisWorkbook.Worksheets
6. For Each pt In ws.PivotTables
7. pt.RefreshTable
8. Next pt
9. Next ws
10. End Sub