Try also Debra's page at:
http://www.contextures.com/xlautofilter02.html#Limits
"Limits to Dropdown Lists"
where she details some workarounds
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Denise Robinson" wrote in message
...
Hi All
I have recently found out that Autofilter only filters the first 1000
unique
records. My database has 24,000 entries and I was wondering if anyone know
if Auto filter can be changed to filter all entries?
Thanks
Denise