Believe 1000 is the limit for items to display in the autofilter droplist ..

Try Debra Dalgleish's coverage on this at her page:
http://www.contextures.com/xla*utofilter02.html#Limits
for a possible workaround
(Look under "Limits to Dropdown Lists")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"W Paul" <W wrote in message
...
In Excel 200o, is there a limit to the number of rows that can be
filtered?
I'm having a problem where Excel filters everthing before row number 1155,
but from 1155 forward, it not filtering and including all data from that
row
forward.