Problem with length of validation list in Excel 2002

V

Vladimir

I've found a strange problem:

I have a validation list containing several releases (information like
1.1 > 1.3, 1.0.2 etc.)

However, for some reasons Excel doesn't show the entire list in the
drop-down menu
and limits the number of entries.

Is there any restriction for the length of the validation list? How
many characters can I enter there?

If so, don't you possibly know a workaround solutions for this problem?
My list can easily expend in the future.

Any advice is highly appreciated,

Vladimir Kornev
 
V

Vladimir

Hello John,

Thank you for the prompt reply. I will try the idea with custom
validation Combobox.

I noticed another interesting thing. If I just put all the values in a
column and then choose Validation : List and enter A1 : A21 as source,
everything is ok.

However, if I try to put all the data in the "Source" string directly
using "," as a separator, Excel doesn't allow me to enter more than ca.
220 characters...

Vladimir
 
D

Debra Dalgleish

Is there a reason that you don't want to store the list on a worksheet?
Then you'd be able to create a much longer list. To use a list on a
different worksheet, you can name the list, as described here:

http://www.contextures.com/xlDataVal01.html
Hello John,

Thank you for the prompt reply. I will try the idea with custom
validation Combobox.

I noticed another interesting thing. If I just put all the values in a
column and then choose Validation : List and enter A1 : A21 as source,
everything is ok.

However, if I try to put all the data in the "Source" string directly
using "," as a separator, Excel doesn't allow me to enter more than ca.
220 characters...

Vladimir
Click to expand...
 
Top