Microsoft Office Tutorials and References
In Depth Information
Extending Your Reach: Referring to Cells in Different Workbooks
on Sheet1, even if the range Scores is on Sheet2.
Extending Your Reach: Referring to Cells in Different Workbooks
But there’s still another possibility: you can even reference cells in your formulas that come from
other workbooks, that is, completely different Excel files. It’s possible you’ll need to calculate some
bottom- l i n e total for sal e s or budg e t data assi g n e d to di ffe r e n t wor kbooks, an d hav e i t al l di sti l l e d i n to
just one workbook; and that sort of task is eminently doable once the relevant cells are referenced.
True, you’ll want to proceed with care here, because if you email someone such a workbook—one
containing cell references to data in another workbook—and you don’t send along the latter workbook
as well, your data will be missing something.
The way to go about referencing, or linking, data across workbooks is actually pretty easy, and
similar to the method we described above for referencing cells across worksheets in the same
workbook. Let’s try this:
1.
Open two new wor kbooks, and save one as Link, the other as Link2.
2.
In cell G13 in Link type 65. In cell I2 in Link2 type 17. Now we’re going to try
and add the two numbers (needless to say, you can add many more than two,
and you can link ranges as well this way).
3.
Remaining in Link2, type =I2+ in cell A1.
4.
Click on Link, and simply click cell G13. You’ll see (Figure 7–12):
Figure 7–12. Note the more elaborate cell reference, pointing to a different worksheet in a different
workbook
5. Then press Enter. The answer appears.
Note the syntax of the formula we’ve just written. Because we’re working with cells in two
different workbooks, Excel needs to specify two things: the workbook in which the linked cell(s) is
 
Search JabSto ::




Custom Search