We select Excel Table Sliders items through Cache object, and not Slider object. Why?

[Jamualson]

sc: SlicerCache
s: Slicer

We use this way

With sCache
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With

and not this way:

With s
.SlicerItems("1").Selected = True
.SlicerItems("2").Selected = False
.SlicerItems("3").Selected = True
End With

My understanding currently:

- a table column can have a slicer cashe object attached to it
- if I create another SlicerItem from same cache, then it will look the same
- and I can set item selection through the SlicerCache, and not through the Slicer object itself

Is this 3 lines correct? And if yes, what is the function of creating multiple Slicer from same cache? It will just give the same output, so making 1 Slicer from 1 cache is the most you can do. When would it be useful to make more slicers from same cache?

Thank you very much for your answer, I am really confused about this. Have a nice day.

 

[RoryA]

The same Slicer object model applies for Pivot tables and regular tables so, while it probably doesn't make sense for a table, it is quite reasonable for pivot tables.