Filter

William Schmitz · Nov 12, 2003

Are their any filter limits on the number of values you can see... I have a 3 thousand row file and can only see 1000 diffeent values in the filter mode..

Ron de Bruin · Nov 12, 2003

1000 is the limit

See this site for more information about this
http://www.contextures.com/xlautofilter02.html#Limits

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

William Schmitz said:
Are their any filter limits on the number of values you can see... I have a 3 thousand row file and can only see 1000

diffeent values in the filter mode...