drop-down list validation won't allow a different worksheet

[Guest]

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?

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Gord Dibben]

Have a look at Debra Dalgleish's site on using a named range from another
workbook and see if you've done all the steps in the right order.

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


Gord Dibben Excel MVP

 

[Ken Wright]

Well I'm............

Didn't know you could do that :-(

Do now though

Thanks Gord (and Debra)

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

 

[Ken Wright]

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

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