Belay that, i stand corrected - see Gord's post.

Regards
Ken..............

"Ken Wright" wrote in message
...
Different workbook or worksheet?

Worksheet OK, Workbook not.

With worksheet, as you say, simply name the list and then put it in the
reference box preceded by an =

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"justmetn" wrote in message
...
I'm using Excel 2003 and have setup a list of data and named it. When I
try
to setup the drop-down list feature and select data validation and select
"List". The list is in a different workbook so I enter the name i have
defined preceded with an equal sign. I get an error message 'You may not
use
references to other worksheets or workbooks for Data Validation
criteria'. I
had the same drop-down list used with a prior version of Excel. Is there
something else I need to do?