| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoFilter
I have a datasheet with 6000 rows. When i set the AutoFilter, some columns
includes not all rows. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoFilter
Hi Fritz, Autofilter dropdown lists have a limit of 1000 unique items - this may be the cause of your problem. For possible solutions have a look at Debra Dalgleish's page: http://www.contextures.com/xlautofilter02.html#Limits. hth, Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=502816 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoFilter
Hi Fritz, Autofilter dropdown lists have a limit of 1000 unique items - this may be the cause of your problem. For possible solutions have a look at Debra Dalgleish's page: http://www.contextures.com/xlautofilter02.html#Limits. hth, Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=502816 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoFilter
Hi broro183,
Thnaks a lot for your Information. "broro183" wrote: Hi Fritz, Autofilter dropdown lists have a limit of 1000 unique items - this may be the cause of your problem. For possible solutions have a look at Debra Dalgleish's page: http://www.contextures.com/xlautofilter02.html#Limits. hth, Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=502816 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoFilter
Hi, no problemo, thanks for the feedback -I hope you find Debra's suggestions useful. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=502816 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
| Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
| Improve autofilter combine conditionals with filter criteria | Excel Worksheet Functions | |||
| New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Hybrid Mode
