Linking Slicers to multiple Pivot Tables with External Data Sources

%3CLINGO-SUB%20id%3D%22lingo-sub-1155296%22%20slang%3D%22en-US%22%3ELinking%20Slicers%20to%20multiple%20Pivot%20Tables%20with%20External%20Data%20Sources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1155296%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20externalised%20my%20data%20source%20to%20improve%20performance%20and%20I%20have%20several%20pivot%20tables%20that%20link%20to%20the%20external%20excel%20spreadsheet.%26nbsp%3B%20I%20would%20like%20a%20slicer%20to%20link%20multiple%20pivot%20tables%20but%20when%20I%20use%20the%20Report%20Connections%20tool%20the%20other%20pivot%20tables%20do%20not%20appear%2C%20even%20through%20they%20have%20the%20same%20filters.%26nbsp%3B%20How%20can%20I%20link%20the%20Pivot%20Tables%20to%20the%20Slicer%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1155296%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1155360%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Slicers%20to%20multiple%20Pivot%20Tables%20with%20External%20Data%20Sources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1155360%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20check%20the%20link%20below...%20It%20might%20help%20solve%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftheexceltrainer.co.uk%2Fexcel-slicers-2-pivot-tables-based-on-different-data-sources%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftheexceltrainer.co.uk%2Fexcel-slicers-2-pivot-tables-based-on-different-data-sources%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156012%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Slicers%20to%20multiple%20Pivot%20Tables%20with%20External%20Data%20Sources%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20link.%26nbsp%3B%20Unfortunately%20my%20data%20is%20in%20an%20external%20workbook%20so%20it%20doesn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
Highlighted

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