I use an excel list to maintain 2 years worth of data on operator validations. We have deleted out data which is over 2 years old and realigned the pivot table dataset however, the drop down filter list on rows (operators name) in my pivot table still shows the names of operators who no longer feature in the raw data.

Why is this? and How can I get rid of them without having to reprodcue the pivot table from scratch? I don;t want to do this as there is a lot of conditional formating and furthter calcuyations that are done from the current pivot table.

I hope someone can help or point me at a thread which already answers this (I do did look and none of the titles I tried were what I needed)

Dr M