How to automatically update pivot tables using VBA

How to automatically update pivot tables using vba?
I find this useful when building files for others and wanting to make sure that after they update their data, the pivot tables and charts are updated.
Sure, we can manually update them but this simple trick saves time and attention.
Here is the code used in the file, 3 simple lines :
Private Sub Worksheet_Deactivate()
ActiveWorkbook.RefreshAll
End Sub
––––––––––––––––––––––––––––––
Track: Travel With Us — Vendredi [Audio Library Release]
Music provided by Audio Library Plus
––––––––––––––––––––––––––––––

[gmc]

Hey bud, did you ever re-record this tutorial as we cannot see how you created the VBA

[brentmawhinney]

Error in your video. You talk about putting in the VBA etc but the screen does not move from the Data sheet originally in view. You mention 3 lines of code but do not show them in the VBA editor I realize they may be in the downloadable, but not showing them shows you didn't review this before posting it. Better luck on the repost. Like the channel BTW.