Another point.

You may have a blank cell or row at 1155.


Gord Dibben Excel MVP

On Mon, 7 Mar 2005 10:10:11 +0800, "Max" wrote:

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.