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
Dividing Line


If you need to print this page out, type your name in the box below.

Your Name : 



Information

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.


Information

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.

Word Processing


In the Object dialog box, select Create from File.

Choose Browse and select the spreadsheet file that you want to embed.

Word Processing


Click on the option for Link to File.

Word Processing


Click OK Word Processingto 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.

Word Processing


With this method you are not embedding the spreadsheet into the document.  You are creating a link to it.


PrintITPrint out this Page

Next Linking to a Data Range


Last modified: Tuesday, 14 July 2020, 1:19 PM