VBA to Automatically Refresh Pivot Tables After Updating Source Data

[AAF]

Hi everyone,


I’m working on a financial model in Excel and I have several pivot tables that are connected to a dynamic data source. Every time I update the data source (e.g., paste in new monthly data), I have to manually refresh each pivot table.


I’m looking for a simple VBA solution that will automatically refresh all pivot tables in the workbook when I update the source data or upon opening the file.


Any help or example code would be greatly appreciated!


Thanks!

 

[Marc L]

Hi !​

Refresh all Pivot Tables

I have below code where i need it to update all the pivot tables if the values between A:C changes. However it is not working. Can anyone help? Thanks Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:C")) Is Nothing Then Call...

chandoo.org