I created a data validation range (list with a named range). That list is supposed to include an "in cell dropdown" but the dropdown does not show up.
The ultimate problem is that when a change is made in the named range (inside the range) that change is not reflected and no choice is available for that new entry since a dropdown is not there.
The range i creted the data validation for is about 14,000 rows by 1 column. I recreated the data validation on a smaller range and it still does not give me the in cell drop down.
Does this make sense? Any thoughts?
thanks in advance