Referencing Defined Names in Other Workbooks

C

Charles Williams

The syntax looks like this, where Volsheet is the name in the other
workbook:
lFormula in this workbook referring to Global Name in External book
-Names2.xls!Volsheet

lFormula in this workbook referring to Local Name in External book
-[Names2.xls]Sheet2!Volsheet


regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
B

Bernard Liengme

With both files open: on the required sheet of file 1 type =, then click on
the named cell in file 2.
This results in a formula like ='Annual data 2008.xls'!mydata
best wishes
 
Top