Microsoft Office Tutorials and References
In Depth Information
Linking an Object from Excel to Word
To break the link between the Hospital Letter document and the
Growth Table workbook:
1. In the Word window, right-click anywhere in the linked table, point to Linked Worksheet
Object on the shortcut menu, and then click Links to open the Links dialog box. There is
one entry in the Source file list box. See Figure 1-18.
Links dialog box
file might be
in a different
Trouble? Depending on the disk drive used for your Data Files, the filename path in the
Links dialog box might be different from the one shown in Figure 1-18.
2. With the link selected in the Source file list box, click the Break Link button. A dialog box
opens, asking you to confirm that you want to break the selected link.
3. Click the Yes button. The link is broken, and the dialog box closes.
You’ll confirm that the link is indeed broken by editing the growth table in Excel, and then
verifying that the change is not made in the letter.
4. Switch to the Excel workbook, and then enter 500 in cell F10.
5. Switch to the Word document, and then right-click the table. Note that the various Link
commands no longer appear on the shortcut menu.
6. Click a blank area in the document window to close the shortcut menu, and then click Edit
on the Word menu bar. The Links command is grayed out on the Edit menu, which means
that this command is not available because there are no links in the document. This con-
firms that the link between the two files is broken.
7. Click a blank area in the document window to close the Edit menu.
8. Switch to the Excel workbook, click the Close Window button on the Excel menu bar,
and then click the No button when prompted to save the changes to the file. You do not
want to save the change you made to the data, because this change was made simply to
test the broken link. The workbook closes.
9. Switch to the Word document, and then save the Hospital Letter document.
If you had closed the Hospital Letter document without saving it, the link to the Excel
object would still be intact. Because you saved the letter, the link remains broken.