Data Validation - but not restricting values

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

[Max]

"Jon5001" wrote:
> 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[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.

"Jon5001" wrote:

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

The strange thing is that the box is selected and the style is Stop.

"bpeltzer" wrote:

> 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.
>
> "Jon5001" wrote:
>
> > 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?

[Max]

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Max]

Think your defined range covers/carries an empty cell within it.
Remove that empty cell and I believe it'll work
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---