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

On 12 avr, 21:33, pat67 <pbus...@comcast.net> 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

new1@[no/spam]realce.net

On Apr 12, 6:36*pm, "new1@[no/spam]realce.net" <n...@realce.net>
wrote:
> On 12 avr, 21:33, pat67 <pbus...@comcast.net> 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
>
> new1@[no/spam]realce.net

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


On Tue, 13 Apr 2010 06:08:52 -0700 (PDT), pat67 <(E-Mail Removed)> wrote:

>On Apr 12, 6:36*pm, "new1@[no/spam]realce.net" <n...@realce.net>
>wrote:
>> On 12 avr, 21:33, pat67 <pbus...@comcast.net> 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
>>
>> new1@[no/spam]realce.net
>
>when i do that it says named range not found. but it exists. any ideas?