View Single Post
  #1   Report Post  
SSD1
 
Posts: n/a
Default Pivot table Data refresh

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?
--
SSD1