Referencing Defined Names in Other Workbooks
 

Is there a way to reference a defined name in another workbook?

Referencing Defined Names in Other Workbooks
 

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?

Referencing Defined Names in Other Workbooks
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

Referencing Defined Names in Other Workbooks
 

='c:\temp\file.xls'!Name
HTH
Daniel

Is there a way to reference a defined name in another workbook?

I love this board! ExcelBanter is awesome.

I had the same issue where I moved my data to an external spreadsheet (so I wasn't pasting the same data 12 times) and was using a sorter in one of my sheets that referred to a defined name in my data worksheet.

When I stuck the path in the formula and pressed enter - Excel (2010) removed the path and just kept the workbook filename (i.e. file.xlsx!Name) instead of the whole path. If I open the "child" workbook without opening the data ("parent") workbook, then the path will show in the formula.

As long as the workbook that I am referring to is open, the path will not show but if I close the source workbook, then it shows up.

Thank you for the help, once again!!