- 1). Open the source workbook, containing the cell you want to reference.
- 2). Open the destination workbook, where you want to create a link.
- 3). View the workbooks side by side. In Excel 2003, from the menu, choose "Windows," then "Arrange." Select "Tiled." Click "OK." In Excel 2007, under the ribbon's "View" tab, in the "Window" group, click "Arrange All." Select "Tiled."
- 4). Link cells. In the destination workbook, click a cell and type an equal sign ("="). If you are building a formula, type the beginning of the formula, up to the point where you want to insert a value from the other worksheet.
- 5). In the source workbook, click on the cell containing the value you would like to use. The focus will automatically return to the destination workbook. If you started a formula, complete it, ending with a close parenthesis. Click "OK."
- 6). Set up automatic updates.
In Excel 2003, from the menu, select "Tools," then "Options." On the "Calculation" tab, under "Workbook options," select "Update remote references." Click "OK."
In Excel 2007, under the ribbon's "Formulas" tab, in the "Calculation" group, click "Calculation Options." Select "Automatic." - 7). Save and close both worksheets. Later, whenever you change information in the source workbook, linked cells in the target workbook will automatically be updated, even if the other workbook is closed.
previous post
next post