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:
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.
Bookmarks