Change Pivot Source Data in multiple pivot tables

Hi All

Any help with this would be appreciated. I have a single workbook with multiple worksheets. Each worksheet has a different pivot table displaying a different view of the data. Each pivot table uses the same source data at worksheet1.

Each week i add new data to the end of the source data, which means that I need change the source data reference separately in each pivot table to update each pivot table view to include the new data. This is laborious as there are quite a few pivot tables.

Was wondering if there is some way of changing the pivot table source data reference on all pivot tables at the same time.

Thanks

Hi,

An alternate way would be to select the entire columns as data source instead of just the data range. i.e, If your data source is from A1: AB2,000, select A:AB as the data source in Pivot Table. This way you don't need to change the data source in each Pivot every week.