Forum Discussion

CharlesPulley's avatar
CharlesPulley
Copper Contributor
Nov 02, 2021

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 up and hit ok, nothing ever appears.  

 

Has anyone else ever dealt with this issue before?  Is this an issue with the version of office I'm using?  I'm curious what could be causing this to happen.

 

Thank you all for your help,

Chuk

5 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Hi Charles,

    If you open the Selection pane (the looking-glass drop-down button on the Home tab), does it show the slicers?
    • CharlesPulley's avatar
      CharlesPulley
      Copper Contributor
      Hi Jan, yes I’ve checked, unfortunately nothing shows up there either.
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Weird. 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?

Resources