To clear old items from the pivot table, you can use one of the
techniques shown he

http://www.contextures.com/xlPivot04.html


trainer07 wrote:
When I change/edit the source data in my Pivot Table and then refresh the
pivot table, the new data is displayed. However, when I click on the drop
down arrown of one of my fields in the pivot table, the old data (along with
the new data) is still being displayed. How can I delete the old data from
the drop down box?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html