Excel 2000 / How clear drop-down list in Pivottable?
 

After having deleted Items in Source Data Table and refreshed Pivottable
Items still in Drop-down list of field in Pivottable.

How can Drop-down list of a field in Pivottable be cleared of all
redundant Items?

--

Charles Janssens

Excel 2000 / How clear drop-down list in Pivottable?
 

Hi Charles;

This should work

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh

Thanks,

Greg
-----Original Message-----
After having deleted Items in Source Data Table and
refreshed Pivottable
Items still in Drop-down list of field in Pivottable.

How can Drop-down list of a field in Pivottable be
cleared of all
redundant Items?

--

Charles Janssens




.

Excel 2000 / How clear drop-down list in Pivottable?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
After having deleted Items in Source Data Table and refreshed
Pivottable
Items still in Drop-down list of field in Pivottable.

How can Drop-down list of a field in Pivottable be cleared of all
redundant Items?

--

Charles Janssens