Thread: Why do I not see all my data when I use the auto filter drop down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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.


Reply With QuoteReply With Quote