Slicers not appearing in excel for office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-2917206%22%20slang%3D%22en-US%22%3ESlicers%20not%20appearing%20in%20excel%20for%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2917206%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20a%20workbook%20with%20multiple%20pivot%20tables%2C%20all%20from%20the%20same%20data%20source.%26nbsp%3B%20I'm%20trying%20to%20insert%20a%20slicer%2C%20however%20after%20I%20select%20the%20items%20I'd%20like%20to%20filter%20on%20from%20the%20options%20box%20that%20pops%20up%20and%20hit%20ok%2C%20nothing%20ever%20appears.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20ever%20dealt%20with%20this%20issue%20before%3F%26nbsp%3B%20Is%20this%20an%20issue%20with%20the%20version%20of%20office%20I'm%20using%3F%26nbsp%3B%20I'm%20curious%20what%20could%20be%20causing%20this%20to%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%20for%20your%20help%2C%3C%2FP%3E%3CP%3EChuk%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2917206%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2920945%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%20not%20appearing%20in%20excel%20for%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920945%22%20slang%3D%22en-US%22%3EHi%20Charles%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20open%20the%20Selection%20pane%20(the%20looking-glass%20drop-down%20button%20on%20the%20Home%20tab)%2C%20does%20it%20show%20the%20slicers%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2921032%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%20not%20appearing%20in%20excel%20for%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921032%22%20slang%3D%22en-US%22%3EHi%20Jan%2C%20yes%20I%E2%80%99ve%20checked%2C%20unfortunately%20nothing%20shows%20up%20there%20either.%3C%2FLINGO-BODY%3E
New Contributor

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

4 Replies
Hi Charles,

If you open the Selection pane (the looking-glass drop-down button on the Home tab), does it show the slicers?
Hi Jan, yes I’ve checked, unfortunately nothing shows up there either.
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?
Unfortunately I’ve tried that one too, no luck.