How to Link Data in Other Excel 2007 Workbooks

1. Open the Excel 2007 workbook that contains the data for which you want to link to other workbooks.
2. Double-click in the cell on the Excel workbook the contents of which you want to link to other workbooks. This will select all the contents in that cell.
3. Right-click in the selected cell and then click 'Copy.'
4. Open the other Excel 2007 workbook to which you want to link the data you selected from the workbook that you opened in Step 1.
5. Right-click in an empty cell on the workbook, click the 'Home' tab, click the downward pointing arrow below 'Paste' and then click 'Paste Special.'
6. Click the 'Paste Link' button on the Paste Special dialog box that opens and then click 'OK.' Repeat steps 3 to 6 in other workbooks to which you want to link the selected data.