SlicerCache Exists But SlicerItems Throws 1004 Error

[goss]

Hi all,

Using Excel 2010

I'm trying to find which slicer a user chose to dynamically build another slicer.

I checked if the SlicerCache Exists and it does

Please Login or Register  to view this content.

But when I try to work with the SlicerItems I get Run-time 1004 error on this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any thoughts on what I'm doing wrong?

Thx
w

[goss]

Got it.

I'm using PowerPivot, so I have to use SlicerCacheLevels

Please Login or Register  to view this content.

Thx
w