I have a list of names that I am using to sort a pivot table. (left hand vertical column). When I hit the little drop-down and start unchecking names I realized that the list is really long. I went to the original data and moved a bunch of names to a differnt column and replaced them with "Old". Since they don't apply but I don't want to delete the data.
Problem: they are still appearing in check/uncheck drop down on the pivot table. This is after I refreshed the table and saved the sheets,etc.
How can I get that list to refresh so it only shows what is currenlty in the name column? I searched that column to be sure.
Thanks for the help.
Bookmarks