Linking Slicers to multiple Pivot Tables with External Data Sources

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 ...