View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vladimir Vladimir is offline
external usenet poster
 
Posts: 2
Default 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