Forum Discussion
jbadams
Sep 03, 2020Copper Contributor
Trying to set up Slicer in Excel but it doesn't appear.
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. St...
- Sep 04, 2020
JKPieterse
Sep 03, 2020Silver Contributor
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?
- EnalyticsJul 12, 2023Copper ContributorThis resolved my issue.
- jbadamsSep 03, 2020Copper Contributor
No, the Slicer isn't listed there - seems it just isn't being created for some reason. Thanks for the idea!
- Detlef_LewinSep 04, 2020Silver Contributor
- jbadamsSep 07, 2020Copper Contributor
Creating a new PivotTable seems to have done the trick, thanks!
Still not sure why this worked, but at least I'm in business! 🙂