O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required