+ Reply to Thread
Results 1 to 2 of 2

Why do I not see all my data when I use the auto filter drop down

  1. #1
    trainer07
    Guest

    Why do I not see all my data when I use the auto filter drop down

    When I turn on my Auto Filter and click the drop down arrow under one of my
    column headers (ie. Dates), I don't always see all of the dates that are in
    my Excel database. This seems to happen when I have more than 20,000 records
    of data. Any assistance would be appreciated.

  2. #2
    Ron de Bruin
    Guest

    Re: Why do I not see all my data when I use the auto filter drop down

    See
    http://www.contextures.com/xlautofilter02.html#Limits


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "trainer07" <[email protected]> wrote in message news:[email protected]...
    > When I turn on my Auto Filter and click the drop down arrow under one of my
    > column headers (ie. Dates), I don't always see all of the dates that are in
    > my Excel database. This seems to happen when I have more than 20,000 records
    > of data. Any assistance would be appreciated.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1