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