pivot table field keeps growing

[Paul Tallo]

When I refresh a pivot table, the pivot table field "Date"
keeps old dates in the pull down list box. How can I get
rid of these Dates that carry on. List keeps growing and
growing even though the data is no longer there.

 

[Andy Brown]

How can I get

rid of these Dates that carry on. List keeps growing and
growing even though the data is no longer there.

See this link - http://www.contextures.com/xlPivot04.html

Rgds,
Andy