View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
OMIDF OMIDF is offline
external usenet poster
 
Posts: 1
Default PROBLEM WITH AUTOFILTER

..I HAVE A WORKBOOK, AND I ACTIVATED THE AUTOFILTER DROPDOWN BOXES.
I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, I DO
NOT SEE ALL THE DATA THAT IS IN THAT COLOM. IT SEEMS LIKE IT GOES TO A
CERTAIN POINT AND THEN IT STOPS SHOWING ANYTHING AFTER IT.

EXAMPLE: I HAVE A WHOLE BUNCH OF DATES IN THIS COLOM. THE DROPDOWN WINDOW
ONLY GOES TO THE YEAR OF 2003. THERE ARE MORE ENTRIES THAT HAVE DATES AFTER
THAT, BUT I CANT SEE IT IN THE AUTO FILTER

SORRY FOR THE CAP LOCK. NEW USER HERE