Create a Link to a Spreadsheet
LO5 :: To be able to select and present information in the development of the solution to meet an identified need
When you Embed an object into a document, it becomes part of the document.
Linked Objects can be updated if the source file is modified. For example, if you link and embed a spreadsheet in a document, every time you update the spreadsheet it will automatically update in the document as well.
To embed a spreadsheet in a document, click on the Insert tab in your word processor.In the Text group click the drop-down arrow for Object and Select Object.
In the Object dialog box, select Create from File.
Choose Browse and select the spreadsheet file that you want to embed.
Click on the option for Link to File.
Click OK to create the link to your spreadsheet file.
An image object of the last saved spreadsheet will be added to the document. You can now resize the image to best fit on your page.
With this method you are not embedding the spreadsheet into the document. You are creating a link to it.
Print out this Page
Linking to a Data Range