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

Posted to microsoft.public.excel.programming

No Name

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear the INDIRECT drop down list	rmcdonald76	Excel Discussion (Misc queries)	1	September 22nd 10 10:19 PM
The hide PivotTable items functionality is gone in my excel 2000	Endre	Charts and Charting in Excel	2	September 1st 07 11:26 PM
MS Excel 2000 - Change PivotTable DataSource (Access2000 database)	Scott	Excel Discussion (Misc queries)	0	May 30th 06 03:33 PM
multiple select from the drop down list in excel. list in one sheet and drop down in	sriramus	Excel Discussion (Misc queries)	5	October 27th 05 06:55 PM
PivotTable and PivotChart clear failure	SnoRiidr	Excel Programming	1	March 2nd 04 02:52 PM

All times are GMT +1. The time now is 08:10 AM.

Menu

About Us