Re: Pivot table Data refresh

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Debra Dalgleish <dsd@xxxxxxxxxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 18:08:44 -0400

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

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

SSD1 wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Follow-Ups:
- Re: Pivot table Data refresh
  - From: SSD1

References:
- Pivot table Data refresh
  - From: SSD1

Prev by Date: In Excel the total is off by a penny.
Next by Date: Re: functions do not calculate
Previous by thread: Pivot table Data refresh
Next by thread: Re: Pivot table Data refresh
Index(es):
- Date
- Thread