Named Range in another workbook

J

Jon C

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
 
Top