Sounds like you are typing =employeelist into a cell.

The instructions at Debra's site are quite clear.

You need a named range in source workbook.............employeelist

In Refers to: =sheet!cellrange

You need a named range in DV workbook

In Refers to: =sourcebook.xls!employeelist

In DV book in DV source type =MyList


Gord

On Sun, 3 Aug 2008 09:36:00 -0700, deek
wrote:

deek
I am trying to use this tip and am running into problems. When I list into
the schedule = EmployeeList I get #NAME? not # VALUE! error. Do you have any
suggestions where I am going wrong?


"Gord Dibben" wrote:

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal05.html

Note: the workbook must be open to use the range in another workbook.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 05:16:00 -0700, Don wrote:

morning friends

Is there a way to use the Data/Validation List to use a named range in
another workbook? I want to maintain the list in one place yet have mult
workbooks utilize this so when I have to update the list of dropdowns , I can
do it in one place.

thanks