Sync Slicers in Excel

[Bram1212]

Hi!

I tried to use the sync slicers guide (https://www.mrexcel.com/news/sync-slicers-in-excel/) but it's not working for me.

This is the code I have:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    Dim sc1 As SlicerCache
    Dim sc2 As SlicerCache
    Dim SI1 As SlicerItem


    ' These names come from Slicer Settings dialog box
    Set sc1 = ThisWorkbook.SlicerCaches("Slicer_ISO_Year____Week____Day")
    Set sc2 = ThisWorkbook.SlicerCaches("Slicer_ISO_Year____Week____Day1")


    Application.ScreenUpdating = False
    Application.EnableEvents = False


    sc2.ClearManualFilter


    For Each SI1 In sc1.SlicerItems
            sc2.SlicerItems(SI1.Name).Selected = SI1.Selected
    Next SI1


    Application.EnableEvents = True
    Application.ScreenUpdating = True
End Sub

The 2 slicers are on worksheet 1. The pivottables are on 6 other worksheets. So:
Worksheet 1: 2 slicers
Worksheet 2: 1 pivottable connected to slicer 1
Worksheet 3: 1 pivottable connected to slicer 1
Worksheet 4: 1 pivottable connected to slicer 1
Worksheet 5: 1 pivottable connected to slicer 2
Worksheet 6: 1 pivottable connected to slicer 2
Worksheet 7: 1 pivottable connected to slicer 2

Is that something I need to specify in the code?

Thanks!

 

[Bram1212]

Unfortunately not. I have uploaded it onto a different forum. You should be able to acces it without an account.

 

[Bram1212]

Might be helpful to post the link:

http://www.helpmij.nl/forum/showthread.php/935747-Slicers-koppelen-van-verschillende-data-sets

 

[RoryA]

Yes, that would have sped things up.

You've put the code in the Combined data sheet, which doesn't have a pivot table on it.

 

[dhunton]

Finally got this to work. Please note that if the items in the slicers are not exactly the same, the code will produce an error. I had one item missing on the secondary slicer. Added a line with 0s for data, and it works fine.

The annoying bit is that I can't get Application.Enable Events to stay set to true. Any thoughts would be appreciated.

 

[RoryA]

Are you using the code exactly as posted here? It sounds like your code is disabling events and not re-enabling them.

 

[dhunton]

It sounds like your code is disabling events and not re-enabling them.

Yep, because it errored out due to lack of the one item... once that was fixed, all was good. LOL