Microsoft Office Tutorials and References
In Depth Information
Creating formulas that reference cells in other workbooks
Break links to other workbooks and convert
1 Click the cell that contains the formula that you want to edit.
2 Select the part of the formula representing the link that you want to
3 Press F9.
4 Press Enter.
1 Click the Data tab.
2 In the Connections group, click Refresh All.
TIP You can use the techniques here to link to a cell on a
different worksheet in the same workbook. Just create the
formula, and when you want to put in the cell reference, move to the
target worksheet and click the appropriate cell.