Linking Slicers to multiple Pivot Tables with External Data Sources

[alitrace]

I have externalised my data source to improve performance and I have several pivot tables that link to the external excel spreadsheet.  I would like a slicer to link multiple pivot tables but when I use the Report Connections tool the other pivot tables do not appear, even through they have the same filters.  How can I link the Pivot Tables to the Slicer?

Thank you

[#2]

Hello,

Kindly check the link below... It might help solve your question

https://theexceltrainer.co.uk/excel-slicers-2-pivot-tables-based-on-different-data-sources/

[#3]

@Abiola1 Thanks for the link.  Unfortunately my data is in an external workbook so it doesn't work.

[#4]

I have the same problem. Any solution ?