Change Data Source For Multiple PIvot Tables With Multiple Slicers

[wsnyder]

Hi all,

Using Office 365.

Is there a way to update the Data Source for all of my Pivot Tables that are connected to 9 Slicers?
When I try to update the first Pivot Table, I receive a warning message

The data source of a PivotTable connected to filter controls that are also connected to other PivotTables cannot be changed. To change the data source, first disconnect the filter controls from the PivotTable or from the Other PivotTables.

How can I update all Pivot Tables at the same time to defeat the warning?

Thanks,
-Lou