Hi Jacko

No this is not anything wrong by you, Autofilter will only display 1000
rows.
For more information and some work arounds, take a look at
http://www.contextures.com/xlautofilter02.html#Limits


--
Regards

Roger Govier


"Jacko at DHL" <Jacko at wrote in message
...
I am filtering on an excel sheet with around 11,000 rows (all items are
unique) and the filter drop-down only displays the first thousand or
so.

Is this a bug or am I doing something wrong?