Range limit for auto filter function

[Pierre]

Hi everybody,
I am having a little problem here..
I have around 10,000 rows x 20 columns and it seems that my auto filte
function does not show the last numbers...
Does aybody knows if there is a max size for using the Autofilte
function ???
And if so, is there any way to increase this max...

Thanks to al

 

[Roger Govier]

Hi Pierre

There is a limit of 1000 to the displayed range.
Debra Dalgleish has a workaround on her site at
http://www.contextures.com/xlautofilter02.html#Limits

 

[Pierre]

Thanks a lot Roger.

(And I imagine that there is no way to customize this limit...)

 

[Roger Govier]

Hi Pierre

No, I'm afraid not, you will have to work with Debra's suggestions.