software

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?

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
www.contextures.com/xlautofilter02.html#Limits--
Regards

Roger Govierquot;Jacko at DHLquot; lt;Jacko at gt; wrote in message
...
gt;I am filtering on an excel sheet with around 11,000 rows (all items are
gt; unique) and the filter drop-down only displays the first thousand or
gt; so.
gt;
gt; Is this a bug or am I doing something wrong?
Another possibility is that you Auto filtered by selecting header row which
will work as long as there are no empty rows. Auto filter will not see rows
after the empty row. If there are empty rows, try auto filter by selecting
entire block (all cells)including your header row and activate auto filter.

quot;Jacko at DHLquot; wrote:

gt; I am filtering on an excel sheet with around 11,000 rows (all items are
gt; unique) and the filter drop-down only displays the first thousand or so.
gt;
gt; Is this a bug or am I doing something wrong?