Data Validation allows only part of list

[chs4]

Hi All,
I have a worksheet in which I have a data validation that allows values from the "names" list. Originally the "names" list was static and all was well. Then I had to make it dynamic and the data validation subsequently began to show only the first 17 names (out of ~500). When I add new names to the top of the list, it still only shows the first 17 names. The list is defined correctly because the complete list is highlighted when I click "names" from the dropdown box beside the formula bar (if that makes any sense). Does anyone know why it's doing that and how to fix it?
Thanks.
chs4

 

[Von Pookie]

Do you have the list referencing the range name or is it referencing the initial 17 cells?

 

[Yard]

Hi and welcome,

If your name is defined dynamically then it won't be selectable from the dropdown beside the formula bar.

Have you checked the name of your dynamic range to ensure it is the same name used in the data validation list?

If so, you may have a Workbook level name and a Worksheet level name with the same name? You can see this in the Define Names box.

 

[chs4]

Hi Von Pookie and Yard. Sorry for the long delay in responding. I've been traveling a bit. The problem, as Yard pointed out was that there were two lists named "names," one at the workbook level and one at the worksheet level. I didn't realize there was a difference. Thanks to both of you for your responses.
-chs4