Filtering a list with 67,000 plus records
 

Does anyone know if there is a limit to how many values can be in the
dropdown in an autofilter? I have 67,000 plus records in my database with
that many different values. It is only showing me the first 10,000 values.

Filtering a list with 67,000 plus records
 

Hi Debra

97-2003 = 1000
2007 = 10000


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Debra" wrote in message ...
Does anyone know if there is a limit to how many values can be in the
dropdown in an autofilter? I have 67,000 plus records in my database with
that many different values. It is only showing me the first 10,000 values.

Filtering a list with 67,000 plus records
 

Hi,

You can beat the limit by using VBA but 1000 "Unique Items" in 2003 and
earlier and 10,000 in 2007.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Debra" wrote:

Does anyone know if there is a limit to how many values can be in the
dropdown in an autofilter? I have 67,000 plus records in my database with
that many different values. It is only showing me the first 10,000 values.

Filtering a list with 67,000 plus records
 

Hi,

Here is a sample of the solution to beat the limit, this is for the 1000
item limit but the same idea works in 2007.

http://www.contextures.on.ca/xlautofilter02.html#Limits

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Debra" wrote:

Does anyone know if there is a limit to how many values can be in the
dropdown in an autofilter? I have 67,000 plus records in my database with
that many different values. It is only showing me the first 10,000 values.