Sep 02 2020 08:06 PM - edited Sep 03 2020 06:25 PM
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:
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.
Any idea what my problem could be or where I could look for more info?
Sep 03 2020 05:10 AM
Sep 03 2020 04:38 PM
No, the Slicer isn't listed there - seems it just isn't being created for some reason. Thanks for the idea!
Sep 04 2020 06:32 AM
SolutionSep 06 2020 11:46 PM
Creating a new PivotTable seems to have done the trick, thanks!
Still not sure why this worked, but at least I'm in business! :)
Sep 07 2020 12:05 AM
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.
Jul 12 2023 11:56 AM
Sep 04 2020 06:32 AM
SolutionDelete the pivot table and create a new one and then add a slicer.