Writing slicer selections

  • Try this UDF



    Then in the cell where you want to show the selected slicer item(s), if slicer allows multiselect then each selected slicer item will show separated by a comma.


    =GetSelectedSlicerItems("Name of Your Slicer")


    The slicer Name must be enclosed in the double quotes.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Thanks KjBox - I just came in here to post the same solution I find through a google search! It works pretty good, but a bit resource hungry perhaps.


    However, one thing it is missing is capturing deselected items (using the CTRL button). I'm wondering if/how this would be possible to capture this?

  • I've noticed that using the GetSelectedSlicerItems macro is very resource hungry. Slicers that were taking a few seconds to refresh the data are now taking tens of seconds. I'm wondering if it's because I've set it up on too many slicers (12 all up).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!