Hide items with no Data

[Frostygirl]

Hi all,
I built my first pivot table and i am using slicers. I am having an issue with the slicers showing greyed out buttons. I do not want to see them. How can i remove them. The hide items with no data is "greyed out".
Thanks for your help.

Frostygirl

[sandy666]

try this

slicer.jpg

[xlnitwit]

Hi,

Is there actually data for those items in your source data? Slicers usually only show the items that are actually present in the data. The greyed out ones are items that don't apply based on the current filter combinations and you can't remove those buttons.