Hi all: New to the community and not an Excel expert so I'm hoping someone can help. I'm using Excel 2016 in Office 365 ProPlus (v1803?).
I created a pivot table and added 3 slicers to help users filter the data. I note that they all have a "multi-select" icon (next to the "clear filter" icon). For 2 of the 3, it works perfectly fine.
However, for the other one (which I anticipate will be the one users would most need to use multi-select) I'm finding that when I activate that button and select multiple items from the selector, those items get deselected in the pivot table. It's almost like it's doing an inverse of what I want to select.
I did delete and rebuild the slicer (though not yet the whole thing) but that didn't help.
Has anyone seen this and if so, do you have any suggestions on how to fix it? This will be distributed to users who may not have the most up to date version of Office so I'm not going to try anything "fancier" like the Power Apps.
I know they could just use the filter in the pivot table column but where's the fun in that??