 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2007Data validation list limit?
Is there a limit to the number of items that can appear in a data validation drop-down? My source list can grow to be up to 1500 items long, and I don't see any information in excel help or on this board about whether the resulting data validation drop-down will be able to handle so many items. TIA Why bother with DV. The quick way is just type it in a cell instead of looking through the long list of DV > Is there a limit to the number of items that can appear in a data validation > drop-down? My source list can grow to be up to 1500 items long, and I don't > see any information in excel help or on this board about whether the > resulting data validation drop-down will be able to handle so many items. > > TIA Don't believe there is a limit. I stopped at creating one to 11,000 items (rows) without any problem.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Is there a limit to the number of items that can appear in a data validation > drop-down? My source list can grow to be up to 1500 items long, and I don't > see any information in excel help or on this board about whether the > resulting data validation drop-down will be able to handle so many items. > > TIA The range limit is 32,767 cells in a 1 dimensional array (single column or row). If you type in the items as a comma delimited array then the limit is ~255 characters. Biff > Is there a limit to the number of items that can appear in a data > validation [quoted text clipped - 4 lines] > > TIA |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.