Data Validation - but not restricting values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?

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

---
 
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.
 
Clarification:
Nothing wrong there. That's the behaviour when you use Allow: List

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

Just my observations ..

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

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top