I could not reproduce the problem using any Excel version: 2003, 2002, 2000
or 97. I created a list, named it "ValList" and on another sheet created a
list Data Validation using ValList as the list range. The Stop alert popped
up as it should when I manually entered something not in ValList.

--
Jim
"brodiemac" wrote in message
...
| I'm using data validation for a drop down list in several sheets in a
| workbook. I have them all accessing a list that is on worksheet one.
Access
| is through defining a name for the list called =salespeople. The problem
is,
| I can't get the Invalid Data Stop message to work. If I access the list
| without the using the name =salespeople for the source and just use direct
| cell references it works fine. Is this a glitch or by design?