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

"wx4usa" wrote in message
...
Is there a way to reference a defined name in another workbook?