How do you update a pivot chart when the data is changed?

[trainer07]

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]

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

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