software

I am using Excel 97. I have set the autofilter feature in Excel to the
column labels.
When I select the drop down arrow on column B, it does not show me all the
unique data that could be selected in the list. I only see a portion of
unique values.
The list is contiguous (no blank rows). Is there a limit to how much data
will display in the drop down list?

TIA
Jan

Jan

bad news ...

support.microsoft.com/kb/q295971/

Not all list items are displayed in the AutoFilter list in Excel
This article was previously published under Q295971
SYMPTOMS

When you use the AutoFilter command in Microsoft Excel, the AutoFilter list
may not display all the unique visible items in a column as expected.
CAUSE

In the products that are listed in the quot;Applies toquot; section, the limitation
of the amount of entries in the AutoFilter list is 1,000. If you have more
than 1,000 unique items in the list, only the first 1,000 items appear.
WORKAROUND

To work around this issue, use the AutoFilter command on several smaller
sections of the data instead of on all the data at the same time. All list
items will be visible if each subset has no more unique members than the
limit for the particular version of Excel.
Regards

Trevorquot;Janquot; gt; wrote in message
...
gt;I am using Excel 97. I have set the autofilter feature in Excel to the
gt; column labels.
gt; When I select the drop down arrow on column B, it does not show me all the
gt; unique data that could be selected in the list. I only see a portion of
gt; unique values.
gt; The list is contiguous (no blank rows). Is there a limit to how much data
gt; will display in the drop down list?
gt;
gt; TIA
gt; Jan
Trevor,

At least that explains it. I was going nuts trying to determine why. I
also searched KB at Microsoft, but I guess I wasn't entering the correct
search criteria.

Thank you.
Jan

quot;Trevor Shuttleworthquot; wrote:

gt; Jan
gt;
gt; bad news ...
gt;
gt; support.microsoft.com/kb/q295971/
gt;
gt; Not all list items are displayed in the AutoFilter list in Excel
gt;
gt;
gt;
gt; This article was previously published under Q295971
gt;
gt;
gt;
gt; SYMPTOMS
gt;
gt; When you use the AutoFilter command in Microsoft Excel, the AutoFilter list
gt; may not display all the unique visible items in a column as expected.
gt;
gt;
gt;
gt; CAUSE
gt;
gt; In the products that are listed in the quot;Applies toquot; section, the limitation
gt; of the amount of entries in the AutoFilter list is 1,000. If you have more
gt; than 1,000 unique items in the list, only the first 1,000 items appear.
gt;
gt;
gt;
gt; WORKAROUND
gt;
gt; To work around this issue, use the AutoFilter command on several smaller
gt; sections of the data instead of on all the data at the same time. All list
gt; items will be visible if each subset has no more unique members than the
gt; limit for the particular version of Excel.
gt;
gt;
gt;
gt; Regards
gt;
gt; Trevor
gt;
gt;
gt; quot;Janquot; gt; wrote in message
gt; ...
gt; gt;I am using Excel 97. I have set the autofilter feature in Excel to the
gt; gt; column labels.
gt; gt; When I select the drop down arrow on column B, it does not show me all the
gt; gt; unique data that could be selected in the list. I only see a portion of
gt; gt; unique values.
gt; gt; The list is contiguous (no blank rows). Is there a limit to how much data
gt; gt; will display in the drop down list?
gt; gt;
gt; gt; TIA
gt; gt; Jan
gt;
gt;
gt;

You're welcome ... glad to know I could put your mind at rest, if nothing
else.quot;Janquot; gt; wrote in message
...
gt; Trevor,
gt;
gt; At least that explains it. I was going nuts trying to determine why. I
gt; also searched KB at Microsoft, but I guess I wasn't entering the correct
gt; search criteria.
gt;
gt; Thank you.
gt; Jan
gt;
gt; quot;Trevor Shuttleworthquot; wrote:
gt;
gt;gt; Jan
gt;gt;
gt;gt; bad news ...
gt;gt;
gt;gt; support.microsoft.com/kb/q295971/
gt;gt;
gt;gt; Not all list items are displayed in the AutoFilter list in Excel
gt;gt;
gt;gt;
gt;gt;
gt;gt; This article was previously published under Q295971
gt;gt;
gt;gt;
gt;gt;
gt;gt; SYMPTOMS
gt;gt;
gt;gt; When you use the AutoFilter command in Microsoft Excel, the AutoFilter
gt;gt; list
gt;gt; may not display all the unique visible items in a column as expected.
gt;gt;
gt;gt;
gt;gt;
gt;gt; CAUSE
gt;gt;
gt;gt; In the products that are listed in the quot;Applies toquot; section, the
gt;gt; limitation
gt;gt; of the amount of entries in the AutoFilter list is 1,000. If you have
gt;gt; more
gt;gt; than 1,000 unique items in the list, only the first 1,000 items appear.
gt;gt;
gt;gt;
gt;gt;
gt;gt; WORKAROUND
gt;gt;
gt;gt; To work around this issue, use the AutoFilter command on several smaller
gt;gt; sections of the data instead of on all the data at the same time. All
gt;gt; list
gt;gt; items will be visible if each subset has no more unique members than the
gt;gt; limit for the particular version of Excel.
gt;gt;
gt;gt;
gt;gt;
gt;gt; Regards
gt;gt;
gt;gt; Trevor
gt;gt;
gt;gt;
gt;gt; quot;Janquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am using Excel 97. I have set the autofilter feature in Excel to the
gt;gt; gt; column labels.
gt;gt; gt; When I select the drop down arrow on column B, it does not show me all
gt;gt; gt; the
gt;gt; gt; unique data that could be selected in the list. I only see a portion
gt;gt; gt; of
gt;gt; gt; unique values.
gt;gt; gt; The list is contiguous (no blank rows). Is there a limit to how much
gt;gt; gt; data
gt;gt; gt; will display in the drop down list?
gt;gt; gt;
gt;gt; gt; TIA
gt;gt; gt; Jan
gt;gt;
gt;gt;
gt;gt;