Problem with length of validation list in Excel 2002
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
|