Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot - drop down list (2003)

    Hi all. I'm attaching a pivot table in hopes that someone else's eyes can pick up the problem I'm having. The pivot drop down list for the "month" field is duplicating some of the months and I can't figure out why. I'm trying to show a co-worker how to use a pivot table and this is just confusing her...and me!

    Can anyone shed some light on this?

    TIA,

    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot - drop down list (2003)

    There are 3 rows that contain <code>"April "</code> (with a space after the name). Excel sees these as different from <code>"April"</code>. You can use Edit | Replace to change all occurrences of <code>"April "</code> to <code>"April"</code> (don't include the quotes), then refresh the pivot table.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot - drop down list (2003)

    Thank you Hans. Can I ask, how did you see this? I know Word has the show/hide tool but I don't know how to pick up on these sort of things in Excel.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot - drop down list (2003)

    I sorted the source table on the month column, then looked at the first and last April items. By pressing F2 I noticed that there was a space after the last one.

  5. #5
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot - drop down list (2003)

    Ah..thanks once again.

Posting Permissions

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