Hi,
I'm trying to use VBA to refresh a pivot table when its data source changes. However, to make things complicated, the data source is a look up table pulling data from another pivot table (lets call this the master pivot).
I first attempted to use worksheet_change, but unfortunately this...