Clearing Old data in Pivot Tables
 

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?

Clearing Old data in Pivot Tables
 

Debra Dalgleish has some notes at:
http://contextures.com/xlPivot04.html

Craig wrote:

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?

--

Dave Peterson