I found the correct step-by-step at the site below. I think the problem was
that I didn't keep the file with the list open... somehow I missed that part
of the instruction. Thanks for your help.

http://www.contextures.com/xlDataVal05.html

--
Glenda


"Glenda" wrote:

No it does not work. I still don't know what I am doing wrong, I've tried
everything I can think of.

I am trying to use the name I created in one file as the 'drop down list' in
another file. I get "you may not use references to other worksheets or
workbooks for data validation". This despite the instructions in "Create a
drop-down list from a range of cells" #6. I am preceding with an equal sign
and still the error. Any ideas?
--
Glenda


"vezerid" wrote:

Forget then step 4. Just select everything that might be appearing in
the Refers To: box, and then move to the other window and select the
range. This has the effect that as you are moving about and selecting,
the reference in the box changes to reflect your current selection.

Does this work?

Kostis