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.

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" wrote in message ...
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.