Excel named ranges across workbooks

 Hi

I am using excel named ranges in a grid - so a set of horizontal named ranges like rows 2:10 being 'vendor' (eg 'vendora' 'vendorb' etc and vertical ranges B:E being function eg 'function1' 'function2' 'function3' etc

I can use the named ranges in the same workbook in the standard way

cell content '=vendora function2'

where the two names act as a cross reference to give me the single value where the two ranges intersect

problem is if i have two workbooks (spreadsheets) open and want to ref the named ranges from the other workbook, it just errors

 

cell in workbook2 '='workbook1.xls'!vendora function2'

either the format of the entry is wrong (have tried single / double quotes around all / part of it), or the function of named ranges across books like this doesnt work.

 

i can of course name all the cells individually in workbook1 like 'vendora_function1' but that is tedious with hundreds of cells.

anyone know if this works via named ranges across workbooks ??

regards

mark

 

Range Names

Try
=workbook1.xls!vendora workbook1.xls!function2