I use a spreadsheet (Excel 2002 SP3) for maintaining a database of archived
client files. It has about 3,100 rows and uses Autofilter on each of the 10
columns.

I find that the drop down list from the Autofilter in the column by which
the sheet is sorted only displays around half to two-thirds of the items in
the column below, yet the other columns appear to be complete.

Is this a normal limitation of the Autofilter function, or can it be avoided
by better configuration issue?

Thanks for your help.

Lawman