My solution for only allowing one selected slicer item

Hi all,

I am working on a project that uses several pivot tables and has one slicer to rule them all, and in the datasource bind them.

I needed this slicer to be restricted to select only one item at a time (in my case, Bill Month in "mmm-yy" format).

I searched online and couldn't find any way to do this without VBA, which I beleive is correct. However the VBA solutions I found seemed over-complicated to achieve the solution. I thought I would post the code I wrote to solve this problem to add it to the collective.

I have my slicer sorted by "Newest to Oldest" so that in the case of multi-selection, the latest date is selected instead because it is higher up on the list.

See below:

Please Login or Register  to view this content.

Replace the slicer name with your slicer's formula name and give it a try.

Hopefully there are enough keywords in this post so it gets stumbled upon by those who seek it.

Working in Excel 2010.

Thanks a lot for the post.

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks