Autofilter expert needed.

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

computexcel

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

Ron de Bruin

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

computexcel

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

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
 
R

Ron de Bruin

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

computexcel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top