Slicer connections

Hi Michael

Thank you for your question.

Slicers only work on PivotTables that have the exact same data range. If one PivotTable has a data range that is out by a single row or column, the slicer won't see that PivotTable.

Also while the slicer can stop the PivotTable from Changing the Data Source if connected to more than one PivotTable, it won't stop you from refreshing any changes to the existing data. You just wouldn't be able to add new records to the PivotTable.

You would need to disconnect the slicer from the PivotTables, update all the PivotTables and then reconnect the slicers. Converting your data to tables before creating the PivotTable can avoid this problem though.

Hope this helps

Kind regards
Wendy Canelas
Microsoft Office Trainer