wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
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
How can I update all Pivot Tables at the same time to defeat the warning?
Thanks,
-Lou
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