You also have to create a named reference to that external range in the
workbook that contains the data validation list. Then, use the new name
as the data validation source. There are instructions he

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

Cezar DUMITRIU wrote:
I have tried to create a drop-down list in Excel, with references in another
workbook than the one where I wanted to input the data from the list, using
the Data Validation function. Reading the Excel help, I've learned that in
order to do that I have o define a Name (Insert--Name--Define) for the list
in my reference workbook and when validating the data in my destination
workbook, in the Data Validation dialog window, on the Settings tab, in the
Source Box, I have to insert (preceded by an = sign) the Name defined
previously. Unfortunately, although I followed all the steps as described in
the Help item, I keep on getting the following Error Message: "You may not
use references to other worksheets or wokbooks for Data Validation criteria."
and I cannot validate the data.

Can anybody help me with this? Please write to


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html