| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Basing Average function range on Date? | Excel Discussion (Misc queries) | |||
| function problem regarding cell range | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
Linear Mode
