Feb 06 2020 03:16 AM
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
Feb 06 2020 03:53 AM
Feb 06 2020 08:21 AM
@Abiola1 Thanks for the link. Unfortunately my data is in an external workbook so it doesn't work.
Oct 27 2021 06:06 AM