Autofilter expert needed.

[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.

 

[Ron de Bruin]

There is a max of 1000 items in the filter list maybe you hit the limit ?

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

 

[computexcel]

Not maybe, for sure.
Got around 1500 rows.
Thanks for the information Ron, and also for the website,
appreciate it.

 

[Ron de Bruin]

Select the whole filter range and see if you have the same problem when you apply the filter

 

[computexcel]

Does somebody know if Excell 2007 has more than 1000 autofiltering rows ?
THANKS

 

[computexcel]

Yes, still name does NOT show, name is under 1000 row.
THANKS.

 

[Ron de Bruin]

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

 

[Ron de Bruin]

You can send me the workbook private if you want
I wil look at it for you then

 

[computexcel]

Under 1000 down means more than 1000, to be exact 1100 and the rule for not
autofilterin apply.
Thanks anyway.