Remove old data from pivot

hey guys.. how do u remove old data thats not there anymore from the pivot table filters.. some of the reps are no longer with the company but there name still shows in the drop box in the pivot table..how can i remove them.. thanks !!

Originally Posted by manny_cb

hey guys.. how do u remove old data thats not there anymore from the pivot table filters.. some of the reps are no longer with the company but there name still shows in the drop box in the pivot table..how can i remove them.. thanks !!

Hi,
this question has been answered many times on the forum.
Search around a bit and you will certainly find it.
Cheers