Validation List

I have a current dilemma when using the validity list. I want to input 37 different words into the list, but the problem arises once I re-open my file. Instead of all the words that should be listed, it always gets cut off on the 27th word.

Now when I first write it the words in, it is not a problem. It is when I choose to open the file at a later date that words are missing.


1
2
3
4
5
6
7
8 etc.

This how I have the words written in the sheet.

I would like to know how can I keep all 37 words to show in a drop down list using Validity?

Originally Posted by foxguy

Hi 500bloc;

Are you saying that you have a cell validation = list? If so how are you assigning the source to the list?

It might be helpful if you uploaded a dummy copy of your workbook. Take out the sensitive data first

Originally Posted by martindwilson

put the words in a range say k1:k37 and use that as the source for your list

Here is the example sheet enclosed.

The problem is on page 1, when I choose a certain hair style (B Column), they are not all listed properly.

Although I have the complete list on sheet 2 (A1:A37 Column).

I'm trying to get Column B on Page 1 to show all the choices that are availble on sheet 2 (Column A), and that is where the problem is.

you may want to change your define name list for your drop down -- I change it on your spreadsheet

Thank you to everyone who helped me find the answer (Foxguy, Grizzly, Martin).

I appreciate it greatly.