Filtering a list with 67,000 plus records

[Debra]

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.

 

[Ron de Bruin]

Hi Debra

97-2003 = 1000
2007 = 10000

 

[Shane Devenshire]

Hi,

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

 

[Shane Devenshire]

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