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 DHL@discussions.microsoft.com> wrote in message
news:EBDA91B7-495A-4667-AAD2-EFB061EFEC37@microsoft.com...
>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?