See Debra Dalgleish's site

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

NOTE: the source workbook must be open when selecting from the DV dropdown.


Gord Dibben MS Excel MVP


On Tue, 13 Apr 2010 06:08:52 -0700 (PDT), pat67 wrote:

On Apr 12, 6:36*pm, "
wrote:
On 12 avr, 21:33, pat67 wrote:

I am setting up a list for cells. I am using data validation and
picking a named range. I have no issue if the range is in the active
workbook. but i need to use a range from a different workbook. is that
possible? if so how?

Thanks

Hello,

If you want to use a named range from a closed workbook, in a
worksheet formula for example like average, you can enter your formula
like this
= average("[path to the closed workbook]\[closed workbook name].xls"!
[name of the range]

HTH



when i do that it says named range not found. but it exists. any ideas?