How to remove 'blanks' from Slicers

Hi,

I often use formatted tables to then have Pivot Tables; Picot Charts and Slicers. If my data-set originally had some blank cells that I add information in to ensure all cells contain data, my slicers still retain the old options from that column. The pivot tables also display them in the filter options but not on the tables themselves.

I have tried deleting the Picot Tables and starting from scratch and it still pulls through the old options in the slicers (greyed out).

Is there a way to remove old data from slicers completely when using pivot tables? It ruins the look of the dashboard.

Much appreciated!

yes there is.. it is a setting

See this page.
https://www.contextures.com/xlPivot04.html

just start with changing the setting that should be enough.
This solves the problem for both pivot filters as slicers.

If you only want to remove them from slicers you can do it by right-clicking the slicer with unwanted values pick slicersettings at the bottom of the popup menu.
then bottom right there is a setting. "Show items deleted from data source" just uncheck that.
And have a look at other options there to determine what to show in the slicer.

Much appreciated, this is very satisfying for me!... It's worked a treat and no longer haunting me! haha