Data Validation items limit

  • Thread starter Thread starter Vinod
  • Start date Start date
V

Vinod

Hi All,

Is there any limit for number of items to place in data validation list?
Since I tried with 90 items to assign in datavalidation list but I couldn't.

Please share your thought or ideas.

Advanced Thanks,
Vinod
 
I just created a DV List with 10,000 items with no difficulty. Perhaps more
information on your setup is necessary.
 
If you create a delimited list, by typing the entries in the Data
Validation dialog box, the limit is 255 characters.

If you need a longer list, you could enter the items on a worksheet,
name the range, then refer to that named range. There are instructions here:

http://www.contextures.com/xlDataVal01.html
 
Back
Top