Learn Excel – Sync Slicers from Different Data Sets
How can you have a slicer drive two pivot tables?
If both pivot tables came from the same data set: Select Slicer, Report Connections, Choose Other Pivot Tables
But if the pivot tables came from different data sets:
Use Save As to change the workbook extension to XLSM instead of XLSX
Use Alt+T M S and change macro security to second setting.
Alt+F11 to get to VBA
Ctrl+R to display the project explorer
Find the worksheet that contains your first pivot table and slicer
Insert the code for Worksheet_Update
Hide the second slicer away so it keeps existing but no one can ever choose from that slicer
via YouTube https://youtu.be/1fOeIS-UpNU