Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide.
When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing
Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo

Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

When starting a new post, to receive a quicker and more targeted answer,
Please include a sample file in the initial post.

Attached Files:

Hi @Smallman :
It works fine. But can you please help to accommodate with this situation. I have 2 slicers with the same name. When I modify the above provided code, only one picks up & lists out the data but the other throws up an error. I think some data model & cube work at the background.

Can you please look into this. I have attached a file with screenshots and slicer values.

Great post guys. It seems that this only works when you are connected to a traditional pivot table and not to the data model. I get an 1004 error in that situation. I looked at the properties of a slicer connected to a traditional pivot table and a a slicer connected to a power pivot model and they have different properties. I thought they would have the same properties.

Hi @Smallman :
It works fine. But can you please help to accommodate with this situation. I have 2 slicers with the same name. When I modify the above provided code, only one picks up & lists out the data but the other throws up an error. I think some data model & cube work at the background.

Can you please look into this. I have attached a file with screenshots and slicer values.