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.

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.

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.

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.