Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Excel Auto Filter (XP , 2003)

    When working with the "Auto Filter" function in worksheets with large data, I cannot click on the down arrow and get a complete listing of all the items in that column. Why does this occurr and is there a fix for this?

    Thanks

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

    Re: Excel Auto Filter (XP , 2003)

    According to MSKB article Not all list items are displayed in the AutoFilter list in Excel, AutoFilter dropdown lists show only the first 1,000 unique items. This is a "hard" limit that can't be changed (but it has been increased in Excel 2007).
    Is that what you experience, or can't you display the dropdown lists at all?

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Excel Auto Filter (XP , 2003)

    The # of lines i can view is 1127 from the title cell. I guess it hit the limit.

    thanks

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

    Re: Excel Auto Filter (XP , 2003)

    Yes, I fear so.

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel Auto Filter (XP , 2003)

    One possible way to get around this is to add another column or three. In these columns put the first 1, 2, or 3 characters of your final sort column of interest, converted to upper case, Then for example:
    1. <LI>Filter on all items starting with P
      <LI>Filter on all items starting with PL
      <LI>Filter on all items starting with PLA
    This will leave a much abbreviated list for your final filter.

    I've not tried this but speculate on the basis that the limitation is stated as being the display list not the actual filter capability.

    H.T.H.
    Regards
    Don

Posting Permissions

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