Thread: Named Range in another workbook

Hi,

I'd like to be able to refer to a Named Range on another
workbook, let's call it Employees.xls, from a second
workbook, something like this.

=VLOOKUP(A3,Employees.xls!nEmployeeTable,2,FALSE)

Works a treat but only when the Employees workbook is
open. Is there a way around this or is it a 'feature'?

Thanks,

Jon

Feature
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jon C" <jncunliffe@hotmail.com> wrote in message
news:284a01c514ef$5aac2ea0$a501280a@phx.gbl...
> Hi,
>
> I'd like to be able to refer to a Named Range on another
> workbook, let's call it Employees.xls, from a second
> workbook, something like this.
>
> =VLOOKUP(A3,Employees.xls!nEmployeeTable,2,FALSE)
>
> Works a treat but only when the Employees workbook is
> open. Is there a way around this or is it a 'feature'?
>
> Thanks,
>
> Jon
>

Figured so...! Thanks Bernard.