Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
There is a max of 1000 items in the filter list maybe you hit the limit ?
See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
Not maybe, for sure.
Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
Select the whole filter range and see if you have the same problem when you apply the filter
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
Does somebody know if Excell 2007 has more than 1000 autofiltering rows ?
THANKS "computexcel" wrote: Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
Yes, still name does NOT show, name is under 1000 row.
THANKS. "Ron de Bruin" wrote: Select the whole filter range and see if you have the same problem when you apply the filter -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Does somebody know if Excell 2007 has more than 1000 autofiltering rows ? THANKS "computexcel" wrote: Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
You can send me the workbook private if you want
I wil look at it for you then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Yes, still name does NOT show, name is under 1000 row. THANKS. "Ron de Bruin" wrote: Select the whole filter range and see if you have the same problem when you apply the filter -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter expert needed.
Under 1000 down means more than 1000, to be exact 1100 and the rule for not
autofilterin apply. Thanks anyway. "Ron de Bruin" wrote: You can send me the workbook private if you want I wil look at it for you then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Yes, still name does NOT show, name is under 1000 row. THANKS. "Ron de Bruin" wrote: Select the whole filter range and see if you have the same problem when you apply the filter -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... Not maybe, for sure. Got around 1500 rows. Thanks for the information Ron, and also for the website, appreciate it. "Ron de Bruin" wrote: There is a max of 1000 items in the filter list maybe you hit the limit ? See http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "computexcel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expert in Excel Needed.... HELP | Excel Discussion (Misc queries) | |||
Expert Needed!!!!!!!!!! Pivot problem | Excel Discussion (Misc queries) | |||
expert with formulas needed again | Excel Discussion (Misc queries) | |||
Complex situation, expert needed... | Links and Linking in Excel | |||
MVP...Formula expert needed!!! | Excel Worksheet Functions |