Hi All

I was wondering whether anyone can answer my query
I am creating a report which contains a Power Pivot Report where the data comes from a power pivot table and another Pivot table where the data comes from a regular Pivot table in excel 2010.

What I need to do is to create a Slicer connection so that when I change the department names in PP Table it changes the Slicer Values accordingly in the Regular Pivot Table's slicer.

I know how to do this if both were generated from PP but in this case it does not give me the option of connecting the slicer as one is generated from a regular Pivot.

Is there any way I can do this?

Hope this makes sense.

Thanks in advance