F
fritz
I have a datasheet with 6000 rows. When i set the AutoFilter, some columns
includes not all rows.
includes not all rows.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
broro183
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...
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...
B
broro183
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...
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...
F
fritz
Hi broro183,
Thnaks a lot for your Information.
Thnaks a lot for your Information.
B
broro183
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...
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...