The first option is to insert a link to an Excel worksheet in your Word document. For users who want to ensure that the information is updated every time a change is made to the spreadsheet, this is the way to go. A one-way link is created that feeds the data from Excel into the Word document. It will also keep your Word file trim, as the data itself is not actually saved with the document. It isn¡¯t with its limitations, however:
- If you move the Excel file you will need to re-establish the link
- If you plan to transport the Word file for use on another computer, you will need to remember to include the Excel file
- You must do all your editing in Excel ¨C this generally is not a problem unless you require different formats in the Word document
If your Excel file isn¡¯t going to change or if you need greater flexibility with your data in Word, then you should embed the worksheet in Word document. While it will increase considerably the size of your Word document, and changes you make to the source file won¡¯t be updated in Word, you will be able to change the format of the table and the file will be easier to transport.
Linking to an Excel Worksheet
To insert a link to an Excel file, follow these simple steps:
1. Open both the Word document and the Excel spreadsheet
2. In Excel, copy the range of cells you want to include (if you plan to insert more columns or rows into your spreadsheet, select the entire worksheet by clicking the box at the juncture of the row numbers and column letters)
3. In your Word document position the cursor where you would like the table inserted
4. On the Edit menu, select Paste Special¡
5. Click the radio button beside Paste link
6. Under the label As:, select Microsoft Excel Worksheet Object
7. Click OK
discuss this topic to forum
