Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    I am using Excel 2003 and creating pivots, does anybody know a way of cleaning the Pivot Field filter dropdowns.

    I have a field which had some bad data loaded, when you look at the dropdown filter is showed the correct data and the wrong data, having cleaned up the source data the dropdowns still showed the rubbish data and I have never been able to get rid of it, unless I rebuild the pivot again.

    Anyway of reseting these dropdowns

    Regards

    Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do the replies in the thread Pivot Table Drop Down Question (2003) help?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •