Microsoft Office Tutorials and References
In Depth Information
Linking to Office documents from workbooks
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter13 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Linking to Office documents
One benefit of working with Excel 2013 is that, because it is part of Office 2013, it is
possible to combine data from Excel and other Office programs to create informative
documents and presentations. Just as you can combine data from one Excel workbook into
another, you can combine information from another Office document with an Excel
workbook, either by pasting the other document into the Excel workbook or by creating a link
between the two.
There are two advantages to creating a link between your Excel workbook and the other
file. The first benefit is that linking to the other file, as opposed to copying the entire file
into your workbook, keeps the file size of your Excel workbook small. If the workbook is
copied to another drive or computer, you can maintain the link by copying the linked file
along with the Excel workbook or by re-creating the link if the linked file is on the same
network as the Excel workbook. The second benefit of linking to another file is that any
changes in the file to which you link are reflected in your Excel workbook. If the linked file
has been moved or isn’t available over a network, then any changes to the linked file won’t
be reflected in your workbook.
You create a link between an Excel workbook and another Office document by clicking the
cell in which you want the document to appear, clicking the Insert tab and then, in the Tex t
group, clicking Object to display the Object dialog box. In the Object dialog box, click the
Create From File tab.