Pivot table Data refresh

[Guest]

I have a Pivot table with 40 names. Each has some numeric data in columns.
The names and data are extracted from other worsheets in the same workbook.
The Pivot table is then used to produce a Pivot Chart.

When I delete the names and data to start a new analysis I refresh the Pivot
Table and the Pivot Chart but the names still remain on the field name drop
down box. How can i remove these permanently?

 

[Debra Dalgleish]

There are instructions here for clearing old items from the dropdown lists:

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

 

[Guest]

There are instructions here for clearing old items from the dropdown lists:

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




--
Debra Dalgleish


Many thnaks, tried this solution abd it works.

GD SSD1