hi...

I have a spreadsheet with about a dozen columns and a couple thousand
rows. No empty rows or columns. When I attempt to use autofilter on
one of the columns, it only displays about two thirds of the data that
I know is there. Can anyone offer any suggestions as to why this might
occur?

TIA

Jim

If you're using xl2003 or below, then the list under the dropdown arrow is
limited to 1000 unique entries.

So that could be the trouble.

(If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)

But another problem could be that you let excel guess at the range to filter.
If your data contains any empty rows, then excel will see this as a delimiter
and not include those rows under that first empty row.

If this is the case, you should remove the filter and then select the entire
range that should be filtered -- then reapply the filter.



On 07/01/2010 20:55, jim wrote:
> hi...
>
> I have a spreadsheet with about a dozen columns and a couple thousand
> rows. No empty rows or columns. When I attempt to use autofilter on
> one of the columns, it only displays about two thirds of the data that
> I know is there. Can anyone offer any suggestions as to why this might
> occur?
>
> TIA
>
> Jim

--
Dave Peterson

On 1 July, 22:10, Dave Peterson <peter...@XSPAMverizon.net> wrote:
> If you're using xl2003 or below, then the list under the dropdown arrow is
> limited to 1000 unique entries.
>
> So that could be the trouble.
>
> (If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)
>
> But another problem could be that you let excel guess at the range to filter.
> If your data contains any empty rows, then excel will see this as a delimiter
> and not include those rows under that first empty row.
>
> If this is the case, you should remove the filter and then select the entire
> range that should be filtered -- then reapply the filter.
>
> On 07/01/2010 20:55, jim wrote:
>
> > hi...
>
> > I have a spreadsheet with about a dozen columns and a couple thousand
> > rows. No empty rows or columns. When I attempt to use autofilter on
> > one of the columns, it only displays about two thirds of the data that
> > I know is there. Can anyone offer any suggestions as to why this might
> > occur?
>
> > TIA
>
> > Jim
>
> --
> Dave Peterson

Thank you, Dave - it was indeed the 2003 version. I didn't know about
that limitation.

Debra Dalgleish shares some workarounds:
http://contextures.com/xlautofilter02.html#Limits



On 07/03/2010 10:55, jim wrote:
> On 1 July, 22:10, Dave Peterson<peter...@XSPAMverizon.net> wrote:
>> If you're using xl2003 or below, then the list under the dropdown arrow is
>> limited to 1000 unique entries.
>>
>> So that could be the trouble.
>>
>> (If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)
>>
>> But another problem could be that you let excel guess at the range to filter.
>> If your data contains any empty rows, then excel will see this as a delimiter
>> and not include those rows under that first empty row.
>>
>> If this is the case, you should remove the filter and then select the entire
>> range that should be filtered -- then reapply the filter.
>>
>> On 07/01/2010 20:55, jim wrote:
>>
>>> hi...
>>
>>> I have a spreadsheet with about a dozen columns and a couple thousand
>>> rows. No empty rows or columns. When I attempt to use autofilter on
>>> one of the columns, it only displays about two thirds of the data that
>>> I know is there. Can anyone offer any suggestions as to why this might
>>> occur?
>>
>>> TIA
>>
>>> Jim
>>
>> --
>> Dave Peterson
>
> Thank you, Dave - it was indeed the 2003 version. I didn't know about
> that limitation.

--
Dave Peterson