Thread: Excel 2000 / How clear drop-down list in Pivottable?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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





Reply With QuoteReply With Quote