Thread: How do I Clear old Pivot Table Fields that no longer exist
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default How do I Clear old Pivot Table Fields that no longer exist
You have a few options....all available at Debra Dalgleish's website

For instructions and the vba code to run:
http://www.contextures.com/xlPivot04.html

OR....for the Pivot Play add-in the clears the items for you:
http://www.contextures.com/xlPivotPlay01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"snowman" wrote:

How can I clear old Field Names that show up on the filter list but no longer
exist in original data table (Pivot Table Source Data)
Reply With QuoteReply With Quote