Maximum value to use autofiler feature in excel

[Roath Kanel]

Hi, does anybody know the maximum value to use autofilter
in ms excel? I heard my friend told me that excel could
filter only select data is less than 1000. He told me that
he has 4000 row and use autofilter, an expected record is
more than a thousand but the record display only 1000
maximum. I want to test like him too but I don't have any
file that contain alot many thousand of record.

Does anybody have any idea?

 

[Frank Kabel]

Hi
see: http://www.contextures.com/xlautofilter02.html#Limits