Data Validation - but not restricting values

J

Jon5001

I've applied data validation (list setting) to some cells in my workbook. The
source is a named range in another sheet. When I click on the cells with
validation, the dropdown list with the values I expect appears and I can
choose them as normal. However, I can also type in any other value I choose
and excel will not complain. Anyone know what's causing this?
 
M

Max

Jon5001 said:
I've applied data validation (list setting) to some cells in my workbook. The
source is a named range in another sheet. When I click on the cells with
validation, the dropdown list with the values I expect appears and I can
choose them as normal. However, I can also type in any other value I choose
and excel will not complain. Anyone know what's causing this?
Click to expand...

Nothing wrong there. That's the behaviour when you use Allow: List
 
B

bpeltzer

Go back to one of the validated cells and, from the menu bar, select Data >
Validation. Click on the Error Alert tab. What selections have you made
there? Unless the first checkbox is selected, there won't be any
notification.
 
M

Max

Clarification:
Nothing wrong there. That's the behaviour when you use Allow: List
Click to expand...

should read as:
Nothing wrong there. That's the behaviour when you use Allow: List
and the named range covers an empty cell within it
Click to expand...

Just my observations ..
 
M

Max

Think your defined range covers/carries an empty cell within it.
Remove that empty cell and I believe it'll work
 
Top