Pivot Table Reuse

[joviquynn]

When you reuse a pivot table with an updated database, how do you remove items from the pivot table drop down lists that are no longer in the database? For example, you have a pivot table with a list of colors - blue, red, green and yellow. The info in the database is updated and the color red has been deleted, but the drop down list of colors in the pivot table still includes red. I want to see only blue, green and yellow in the drop down.