Sync pivot slicers from different database by vba

Hi there,


I have 2 pivot tables from different sources with slicers. Is that possible to have a VB code to sync the slicers (i.e., select in slicer A, and slicer B will automatically follow it )?


Have a sample attachment as well.

It has 2 lead slicers, and also 2 follow slicers, if anyone could help with the sync between the lead and follow slicers, I would highly appreciate it.


Thanks,


Stanley

Do you wish that the lead slicers control everything or that any slicer can be used? For the second option we may dispense with the follow slicers.

Originally Posted by Izandol

Do you wish that the lead slicers control everything or that any slicer can be used? For the second option we may dispense with the follow slicers.

Hi, thanks for your reply. Actually I only want lead slicers(for users) to control everything. Hope it's not too hard to achieve..

You may delete the follow slicers and then right-click the worksheet tab, choose View Code and add this code to your code window:

Please Login or Register  to view this content.

Originally Posted by Izandol

You may delete the follow slicers and then right-click the worksheet tab, choose View Code and add this code to your code window:

Please Login or Register  to view this content.

Wow, thanks, that works very well!! But just one more thing: I noticed that you have a code "On Error Resume Next" to deal with missing items in follow slicers, but I am wondering is there any other ways to handle the missing slicer items? I have tried the code in my dashboard, but the thing is there is no next item in the following slicers. Not sure whether I explained it clearly, but I have attached the new sample which shows my situation.

I suggested to delete the follow slicers - the code therefore manipulates the pivot filter fields and not the slicers. If you wish the follow slicers to remain the code must be changed.