How to get selected items in a slicer without VBA
Slicers is an essential tool in Excel when working with power pivot pivot tables (and "normal/old" pivot tables). But when connecting the same slicers to multiple pivot tables and perhaps place all your slicers on a separate sheet you have to be able to show what your model users have selected in the slicers when they look at the pivot table.
You can create VBA code to read the selected items from the slicer object, but this code cannot be run if you publish your model for use in Excel Web App on SharePoint.
Read more...