Can I Sync a Slicer to Another Slicer If....

Can I sync the selections made in two slicers if...

Slicer1's data source is a table in PowerPivot and it has report connections to PivotTable1,2,3,4,5,6,7,8,9,10
Slicer2's data source is a table in Excel and its only report connection is to the Excel Table (not PivotTables)

End-User selections would always be in Slicer 1. Both data sources have the same fields and data, the only reason I'm doing this is because you can't "showdetails" on data in PowerPivot that has been filtered by more than 1 Slicer.

If so, I would appreciate some code to get me started....

I've attached a sample workbook and did a little more work on this, but i'm running into an error. Hopefully that will help you guys understand what I'm trying to do:

Here is a description of my process:
1. Import External Data into Excel Table called "CleaningTable"
2. Clean data, Add calculated columns, etc...
3. Export CleaningTable to PowerPivot called "CleanedData"
4. Build Slicer1 off of RegionCode in CleanedData
5. Build Slicer2 off of RegionCode in CleaningTable
7. Attempt to sync slicers using below code:

Please Login or Register  to view this content.

I keep getting "Application-define or object-defined error".

End-User selections would always be in Slicer_RegionCode on the Lead worksheet. I would like Slicer_RegionCode1 on the Follow worksheet to mimic the selections. Both data sources have the same fields and data, the only reason I'm doing this is because you can't "showdetails" on data in PowerPivot that has been filtered by more than 1 Slicer.

Things I've learned in the past Day....
For Slicers connected to PowerPivot (OLAP) tables the .VisibleSlicerItemsList property is only one that can be viewed.

Add this code to my sample workbook and run it after making a selection in Slicer_RegionCode.

Please Login or Register  to view this content.

According to what I'm reading I can then Split the value of the VisibleSlicersItemsList to my other non-OLAP slicers. (I don't know how to write the VBA to do that though)... but before you try and do it for me....

It doesn't appear that the property value for VisibleSlicersItemsList can articulate multiple filtering critera. Ala, if your selection is A & D in the Lead Slicer's VisibleSlicersItemsList it will only provide you with

Please Login or Register  to view this content.

However, I have seen some code around various blogs were folks write an Array for VisibleSlicersItemsList to pull Multiselections from one slicer out. For example.

Please Login or Register  to view this content.

So if that makes sense to someone, I could really use your help splitting out VisbileSlicerItemsList into my non-OLAP slicer.