Range limit for auto filter function
 

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

Thanks to all


--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=557205

Range limit for auto filter function
 

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

--
Regards

Roger Govier


"Pierre" wrote in
message ...

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

Thanks to all


--
Pierre
------------------------------------------------------------------------
Pierre's Profile:
http://www.excelforum.com/member.php...fo&userid=3754
View this thread:
http://www.excelforum.com/showthread...hreadid=557205

Range limit for auto filter function
 

Thanks a lot Roger.

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


--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=557205

Range limit for auto filter function
 

Hi Pierre

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

--
Regards

Roger Govier


"Pierre" wrote in
message ...

Thanks a lot Roger.

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


--
Pierre
------------------------------------------------------------------------
Pierre's Profile:
http://www.excelforum.com/member.php...fo&userid=3754
View this thread:
http://www.excelforum.com/showthread...hreadid=557205