Clearing Old data in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I modify the origial data set to which a pivot table is pointing, deleting
data from the set, the deleted data still shows up in the pivot table pick
lists. For example, I have sales data for each month of the year, but delete
January through March. If I choose "Month" as a field in my Pivot Table, I
can still see the deleted months as options. However, there is no data
associated with them.

Is there a way to remove these deleted entries?
 
Back
Top