data validation using named range from another file

[pat67]

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

 

[new1]

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

new1@[no/spam]realce.net

 

[pat67]

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

new1@[no/spam]realce.net

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

 

[Gord Dibben]

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

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

new1@[no/spam]realce.net

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