Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    auto filter limitation (97 sr 2)

    Hi all

    Is there a limit to the number of values that show in the drop down list when using the auto filter feature in Excel?

    We have a sales spreadsheet that goes back to 1997, and the dates on the filter list on the date column only go to Sept 03, all the ones after that do not show in the list, but can still be seen when you do a custom filter.

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

    Re: auto filter limitation (97 sr 2)

    See MSKB article XL: Not All List Items Are Displayed in the AutoFilter List. A maximum of 1,000 unique entries is displayed in the AutoFilter lists.

Posting Permissions

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