Autofilter expert needed.

  • Thread starter Thread starter computexcel
  • Start date Start date
C

computexcel

After autofiltering a worksheet,one name does not show up in the dropdown list.
This is very weird and first time it happes.
I tried : unfilter and autofilter again= still name does not show.
unfilter, erasing and writting the name again, filtering= same
results
Could these be reasons ? 1500 rows,
having blank rows in my data. But is the first time it happens or I notice.
I also installed a couple of add-ins but not recently: CFPlus ( but is off)
and Case L.
Also got a couple of non related macros and Vlookups.
Out all my workbooks and worksheets this is the only one that happens.
Excell 2003, XP. Thanks.
 
Not maybe, for sure.
Got around 1500 rows.
Thanks for the information Ron, and also for the website,
appreciate it.
 
Select the whole filter range and see if you have the same problem when you apply the filter
 
Does somebody know if Excel 2007 has more than 1000 autofiltering rows
Not rows but unique items

There is no 1000 unique items limit in the filter list in Excel 2007
 
Under 1000 down means more than 1000, to be exact 1100 and the rule for not
autofilterin apply.
Thanks anyway.
 
Back
Top