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]

I get a excel pop up that says Triggered.

 

[Bram1212]

I get an excel pop up with the message Triggered.

 

[RoryA]

OK, so the event is firing. It should be setting the slicer items in "Slicer_ISO_Year____Week____Day1" to the same ones selected in "Slicer_ISO_Year____Week____Day". Which slicer are you changing?

 

[Bram1212]

I have tried changing both but none is effecting the other. Maybe something with the slicer name? If I change it to a invalid slicer name I do not get a error or something.

 

[RoryA]

That is strange - you should get an error if it's not a valid slicer name. Which version of Excel are you using?

 

[Bram1212]

2016 version

 

[Bram1212]

Any other ideas what could cause the problem?

 

[RoryA]

Not offhand. Can you censor the data and put the workbook on a hosting site (e.g. OneDrive or Dropbox) so I can have a look at it?

 

[Bram1212]

I have the example in an excel file. Is it possible that you pm me a mail adres?

 

[RoryA]

Can you not upload it somewhere?