Auto Filter does not show all the data in the column

[Guest]

My worksheet that has 21 columns and 3007 rows. I have Auto Filters on all
but 2 of the columns. The Auto Filters work on all but 1 column.
Approximately 850 items are shown from the column which has 3007 unique
values.The range is the same for all the filters and no print range has been
set.

I've tried removing the filters from the other columns, and I continue to
get the same result.

Does anyone know what's going on here?

Please respond to my work email ([email protected]). I had to sign on
using my personal email, but due to the firewall I cannot access it from work.

Thank you.

 

[Ron de Bruin]

Hi Char

See
http://www.contextures.com/xlautofilter02.html#Limits

 

[Guest]

Thanks Ron!

That was just the info I needed!

Hi Char

See
http://www.contextures.com/xlautofilter02.html#Limits