reference data of other workbook

  • Thread starter Thread starter bingy
  • Start date Start date
B

bingy

When I write a formula, I reference data of other sheets using
sheetname!rowcolumn. How could I reference data in other workbook. Is it
workbookname!sheetname!rowcolumn or something like this?

My appreciation for your answer.
(e-mail address removed)
 
Hi

With other workbook opened:
=[OtherWorkbook.xls]SheetName!A1

With other workbook closed:
='C:\My Documents\[OtherWorkbook.xls]SheetName'!A1
or
='\\ComputerName\SharedFolder\SubFolder1\...\[OtherWorkbook.xls]SheetName'!A
1

When you create a link with opened source workbook, and then close source
workbook, the reference is adjusted automatically, and vice versa.
You can always create links to oupened workbooks:
1. Entering '=' into target cell, and then pointing to source cell in source
workbook;
2. Copiyng the source cell/range in source workbook, and then using
PasteSpecial.Link to insert link(s) into target workbook.
 
Back
Top