If you link Excel data to a Word document, any updates or changes to the source Excel file will be automatically updated in the Word document. Also, with linking, the size of the Word document will not increase as it does when inserting (embedding) Excel data. On the other hand, if the location of the Excel file is changed, or the Word document with the linked data is relocated, the link will be broken. Linking makes your document less portable.
Linking Excel data to a word document is almost the same as inserting it. Make sure both Word and Excel are open, then select and copy the range of data that you want to link. Position your curser in the word document at the appropriate location, and choose Edit->Paste Special from the Word menu bar.
In the Paste Special dialogue box, click the Paste link radio button instead of the Paste radio button.
Choose Microsoft Office Excel worksheet Object from the list and click OK to link the data.
The Excel data will now be linked to the Word document. To Edit the Excel data you can work with the original Excel source file. Any changes you make to this file will be reflected in the Word document.
You can right click on the data in Word, and choose Linked Worksheet Object->Edit Link to open the corresponding worksheet. Remember, when you edit this data, you are actually editing the original Excel file, not just an embedded object.
You can also link an Excel file to a word document by choosing Insert->Object from the Word menu bar. This will display the Object dialogue box.
Under the Create from File tab in the Object dialogue box, click the Link to file checkbox.
|
