O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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

Linking to Data in Other Workbooks

Cutting and pasting data from one workbook to another is a quick and easy way to gather related data in one place, but there is a substantial limitation: if the data from the original cell changes, the change is not reflected in the cell to which the data was copied. In other words, cutting and pasting a cell’s contents doesn’t create a relationship between the original cell and the target cell.

You can ensure that the data in the target cell will reflect any changes in the original cell by creating a link between the two cells. Rather than enter a value into the target cell by typing or pasting, you create a type of formula that identifies the source from which Excel will derive the target cell’s value.

To create ...

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