Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Creating Links Between Worksheets and Workbooks

Linking is the process of dynamically updating data in a worksheet from data in another source worksheet or workbook. When data is linked, the linked data reflects any changes you make to the original data.

Linking is accomplished through special formulas that contain references known as external references. An external reference can refer to a cell in a different worksheet in the same workbook or to a cell in any other worksheet in any other workbook.

Excel lets you links data from other worksheets and workbooks in these ways:

• Reference another worksheet in a linking formula using sheet references

• Reference several worksheets in a linking formula using 3D references

• Reference another workbook in ...