You can refer to another file but the other file *must* be open for it to
work. This is usually not desireable. See this for instructions:

http://contextures.com/xlDataVal05.html

It might be easier if you just put the list in the file you want it in.

Biff

"skysusan" wrote in message
...
How can I create a drop down list refering data in aonther workbook?

I have created a NAME (says CUSTCODE) referencing a list of customer codes
in another workbook. And I would like to make a drop-down list refering
this
list, using the Data Validation, but it would not allow me to select this
reference name.