data validation using named range from another file

  • Thread starter Thread starter pat67
  • Start date Start date
P

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
 
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
Click to expand...

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
 
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?
Click to expand...
Thanks
Click to expand...

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
Click to expand...

when i do that it says named range not found. but it exists. any ideas?
 
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?
Click to expand...
Thanks
Click to expand...

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
Click to expand...

when i do that it says named range not found. but it exists. any ideas?
Click to expand...
 
Back
Top