Getting Rid of Old Values in Powerpivot Pivot Tables

[dks345]

I have a workbook that has several slicers and powerpivot pivot tables. The problem I have is that the data that is dropped into the table changes on ocassion and old values that no longer exist are still appearing in the slicers as grayed out values. I don't want them to be shown at all but can't figure out how to get rid of the old "ghosts"

 

[Roger Govier]

Hi

In Pivot Table >Options > Data try changing Number of retained items from Automatic to None.

 

[dks345]

Thank you for your response. That setting is grayed out and won't let me change it. I wonder if this is a setting specific to PowerPivot and if there is a way to enable changes?