Refreshing pivot table drop down lists

  • Thread starter Thread starter Rick Lewis
  • Start date Start date
R

Rick Lewis

How do I get rid of old values in pivot table drop down
lists? The original data has been deleted for months,
even years, yet, the pivot table drop down still shows
them and I have to scroll through the entire list in order
to check off the ones I want to use.

Thanks.
 
Back
Top