SOLVED

Trying to set up Slicer in Excel but it doesn't appear.

%3CLINGO-SUB%20id%3D%22lingo-sub-1629988%22%20slang%3D%22en-US%22%3ETrying%20to%20set%20up%20Slicer%20in%20Excel%20but%20it%20doesn't%20appear.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629988%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20pivot%20table%20set%20up%20reading%20data%20from%20an%20external%20source.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20a%20Slicer%20(from%20the%20PivotTable%20Analyze%20menu)%2C%20but%20it%20doesn't%20appear.%26nbsp%3B%20%26nbsp%3BNo%20error%20messages%20are%20shown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESteps%20I%20am%20following%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EClick%20a%20cell%20in%20my%20PivotTable.%3C%2FLI%3E%3CLI%3EClick%20PivotTable%20Analyze%20on%20the%20menu%3C%2FLI%3E%3CLI%3EClick%20Insert%20Slicer%20(it's%20not%20greyed%20out%2C%20and%20does%20bring%20up%20the%20dialog)%3C%2FLI%3E%3CLI%3EChoose%20my%20field%20(it%20is%20a%20field%20that's%20included%20in%20the%20pivot%20table)%3C%2FLI%3E%3CLI%3EClick%20OK.%3C%2FLI%3E%3CLI%3EThe%20spinning%20%22thinking%22%20icon%20comes%20up%20for%20a%20moment%2C%20but%20the%20Slicer%20never%20appears.%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20I'm%20using%20Excel%202007%20(see%20image%20below)%2C%20but%20every%20time%20I%20search%20for%20help%20the%20resources%20all%20indicate%20Slicers%20aren't%20available%20in%20versions%20prior%20to%202010%2C%20so%20I'm%20coming%20up%20blank.%26nbsp%3B%20Obviously%20the%20feature%20does%20exist%20in%20the%20version%20I'm%20using.%26nbsp%3B%20Attempts%20to%20search%20for%20similar%20problems%20in%20other%20versions%20are%20all%20people%20talking%20about%20the%20button%20being%20greyed%20out%20in%20files%20created%20with%20older%20versions%2C%20which%20also%20isn't%20my%20problem.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22About%20Excel.png%22%20style%3D%22width%3A%20496px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216187iDEEA8603C4370CE3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22About%20Excel.png%22%20alt%3D%22Excel%20version%20info%20from%20File%20%26gt%3B%20Account.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExcel%20version%20info%20from%20File%20%26gt%3B%20Account.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20what%20my%20problem%20could%20be%20or%20where%20I%20could%20look%20for%20more%20info%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1629988%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1631411%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20set%20up%20Slicer%20in%20Excel%20but%20it%20doesn't%20appear.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1631411%22%20slang%3D%22en-US%22%3EAfter%20inserting%20the%20slicer%2C%20click%20the%20Home%20tab%20of%20your%20ribbon%2C%20click%20the%20magnifying%20glass%20and%20choose%20%22Selection%20pane%22.%20Does%20it%20list%20your%20slicer%3F%20If%20so%2C%20click%20on%20it%20there%20to%20select%20it%20(the%20Slicer%20tab%20should%20come%20available%20in%20the%20ribbon)%20so%20you%20can%20change%20its%20properties%2C%20possibly%20the%20size%20is%20zero%20or%20the%20slicer%20is%20hidden%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1633894%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20set%20up%20Slicer%20in%20Excel%20but%20it%20doesn't%20appear.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1633894%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%2C%20the%20Slicer%20isn't%20listed%20there%20-%20seems%20it%20just%20isn't%20being%20created%20for%20some%20reason.%26nbsp%3B%20Thanks%20for%20the%20idea!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a pivot table set up reading data from an external source.

I am trying to add a Slicer (from the PivotTable Analyze menu), but it doesn't appear.   No error messages are shown.

 

Steps I am following:

  • Click a cell in my PivotTable.
  • Click PivotTable Analyze on the menu
  • Click Insert Slicer (it's not greyed out, and does bring up the dialog)
  • Choose my field (it is a field that's included in the pivot table)
  • Click OK.
  • The spinning "thinking" icon comes up for a moment, but the Slicer never appears. 

 

I believe I'm using Excel 2007 (see image below), but every time I search for help the resources all indicate Slicers aren't available in versions prior to 2010, so I'm coming up blank.  Obviously the feature does exist in the version I'm using as the button exists and opens a dialog.  Attempts to search for similar problems in other versions are all people talking about the button being greyed out in files created with older versions, which also isn't my problem.

Excel version info from File > Account.Excel version info from File > Account.

 

Any idea what my problem could be or where I could look for more info?

5 Replies
After inserting the slicer, click the Home tab of your ribbon, click the magnifying glass and choose "Selection pane". Does it list your slicer? If so, click on it there to select it (the Slicer tab should come available in the ribbon) so you can change its properties, possibly the size is zero or the slicer is hidden?

@Jan Karel Pieterse 

No, the Slicer isn't listed there - seems it just isn't being created for some reason.  Thanks for the idea!

best response confirmed by jbadams (New Contributor)
Solution

@jbadams 

Delete the pivot table and create a new one and then add a slicer.

 

@Detlef Lewin 

Creating a new PivotTable seems to have done the trick, thanks!

 

Still not sure why this worked, but at least I'm in business!

@jbadams 

The pivot table probably was created with an older version of Excel when there were no slicers. To recreate the pivot table updates the inner structure and slicers can be added.