Microsoft Office Tutorials and References
In Depth Information
Creating formulas that reference cells in other workbooks
Break links to other workbooks and convert
to values
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.
Refresh links
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.
Search JabSto ::

Custom Search