Forum Discussion
CharlesPulley
Nov 02, 2021Copper Contributor
Slicers not appearing in excel for office 365
So I have a workbook with multiple pivot tables, all from the same data source. I'm trying to insert a slicer, however after I select the items I'd like to filter on from the options box that pops u...
JKPieterse
Nov 03, 2021Silver Contributor
Hi Charles,
If you open the Selection pane (the looking-glass drop-down button on the Home tab), does it show the slicers?
If you open the Selection pane (the looking-glass drop-down button on the Home tab), does it show the slicers?
- CharlesPulleyNov 03, 2021Copper ContributorHi Jan, yes I’ve checked, unfortunately nothing shows up there either.
- JKPieterseNov 03, 2021Silver ContributorWeird. If you copy one of the pivots to a freshly inserted sheet, can you add the slicers there? If so, perhaps you can then copy the slicers to the tab where you need them?
- CharlesPulleyNov 03, 2021Copper ContributorUnfortunately I’ve tried that one too, no luck.