Excel® 2013 On Demand

Linking Data

A link can be as simple as a reference to a cell on another worksheet, or it can be part of a formula. You can link cells between sheets within one workbook or between different workbooks. Cell data to be linked is called the source data. The cell or range linked to the source data is called the destination cell or destination range. If you no longer want linked data to be updated, you can easily break a link. Create links instead of making multiple identical entries; it saves time and ensures your entries are correct.

Create a Link Between Worksheets or Workbooks

Select the cell or range that contains the source data.

Click the ...