• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Building Basic Formulas > Working with Links in Formulas

Working with Links in Formulas

If you have data in one workbook that you want to use in another, you can set up a link between them. This action enables your formulas to use references to cells or ranges in the other workbook. When the other data changes, Excel automatically updates the link.

For example, Figure 3.11 shows two linked workbooks. The Budget Summary sheet in the 2005 Budget—Summary workbook includes data from the Details worksheet in the 2005 Budget workbook. Specifically, the formula shown for cell B2 in 2005 Budget—Summary contains an external reference to cell R7 in the Details worksheet of 2005 Budget. If the value in R7 changes, Excel immediately updates the 2005 Budget—Summary workbook.

Figure 3.11. These two workbooks are linked because the formula in cell B2 of the 2005 Budget—Summary workbook references cell R7 in the 2005 Budget workbook.


NOTE

The workbook that contains the external reference is called the dependent workbook (or the client workbook). The workbook that contains the original data is called the source workbook (or the server workbook).


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint