Thread: Limits to values in auto filter dropdown in Excel 2003??
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Limits to values in auto filter dropdown in Excel 2003??
How about this work-around from Debra Dalgleish's site:
http://contextures.com/xlautofilter02.html#Limits

Eric wrote:

Are the any limits to the # of values displayed in column header dropdown
when using Auto Filter in Excel 2003(SP3)?
I have a list of 25K values many of which are not being displayed in dropdown.

Thanks

--

Dave Peterson
Reply With QuoteReply With Quote