Microsoft Office Tutorials and References
In Depth Information
Tip For references to cells in the same workbook, the workbook information is omitted.
Likewise, references to cells in the same worksheet don’t use a worksheet identifier.
You can also link to cells in an Excel table. Such links include the workbook name,
worksheet name, name of the Excel table, and row and column references of the cell to which
you’ve linked. Creating a link to the Cost column’s cell in a table’s Totals row, for example,
results in a reference such as =’FleetOperatingCosts.xlsx’!Truck Maintenance[[#Totals],[Cost]].
Important Hiding or displaying a table’s Totals row affects any links to a cell in that row.
Hiding the Totals row causes references to that row to display a #REF! error message.
Whenever you open a workbook containing a link to another document, Excel tries to
update the information in linked cells. If the program can’t find the source, as would
happen if a workbook or worksheet is deleted or renamed, an alert box appears to
indicate that there is a broken link. At that point, you can click the Update button
and then the Edit Links button to open the Edit Links dialog box and find which link
is broken. After you identify the broken link, you can close the Edit Links dialog box,
click the cell containing the broken link, and create a new link to the desired data.
If you type a link and you make an error, a #REF! error message appears in the cell that
contains the link. To ix the link, click the cell, delete its contents, and then either retype
the link or create it with the point-and-click method described earlier in this section.
Tip Excel tracks workbook changes, such as when you change a workbook’s name, very well.
Unless you delete a worksheet or workbook, or move a workbook to a new folder, odds are
good that Excel can update your link references automatically to reflect the change.
In this exercise, you’ll create a link to another workbook, make the link’s reference invalid,
use the Edit Links dialog box to break the link, and then re-create the link correctly.
SET UP You need the OperatingExpenseDashboard_start and FleetOperatingCosts_start
workbooks located in your Chapter07 practice file folder to complete this exercise.
Open the OperatingExpenseDashboard_start and FleetOperatingCosts_start workbooks,
and save them as OperatingExpenseDashboard and FleetOperatingCosts , respectively.
Then follow the steps.
1. In the OperatingExpenseDashboard workbook, in cell I6 , type = , but do not
2. On the View tab, in the Window group, click Switch Windows and then, in the
list, click FleetOperatingCosts .
The FleetOperatingCosts workbook is displayed.