Link slicer to pivot table from different source (not power pivot)

[mahmed1]

Hello

i have created multiple pivot tables from 1 table source

i have created 1 pivot table linked to another data source

the tables are pretty much identical except a few fields

is there a way I can link all the slivers to the other 1 pivottable without using power pivot as the not all users might not have PowerPivot installed

I have 8 slicers linked to multiple pivots from the first data source and 1 pivot linked to the other data source...

please help me with some code or advise how to get around this

many many thanks

 

[mahmed1]

Any advice is appreciated

 

[dhunton]

This worked really well for me:

https://www.mrexcel.com/news/sync-slicers-in-excel/#podcast-video