I am glad you asked that first question about Excel... I had no idea that "linking" files could be done. It is very handy for updating tables on my website!!
I am pretty sure this will work!!
I tried this out and it seemed to work.
1) select cells from excel, copy
2) paste in Word
3) click on Paste Options (Office XP) - this is where the cells can be linked to the spreadsheet
Or see below from Microsoft
How Do I Link My Excel Worksheet to My Word Document?
To link to the entire worksheet, just follow these steps:
1. After you quit Excel, position your pointer in the Word document where you want to insert the worksheet.
2. On the Insert menu, click Object, and then click the Create from File tab.
3. Select the Link to file check box.
4. Type the file name, or click Browse to locate your file and then click Insert.
5. Click OK to insert the contents of the file into your document and create a link to the Excel file.
How Do I Link Selected Cells from My Excel Worksheet to My Word Document?
To link to selected cells from the worksheet, just follow these steps:
1. In Excel, select the cells to copy.
2. On the Edit menu, click Copy.
3. In Word, position your pointer where you want to insert the cells.
4. On the Edit menu, click Paste Special.
5. Click Paste link.
6. Select Microsoft Excel Worksheet Object.
7. Click OK to insert the cells into your document and create a link to the Excel file.
Note All data in the Excel file, not just the pasted range, may be available to the reader of the linked Word document.
How Do I Update the Link?
After you or your colleagues make changes to the Excel worksheet and save and close the file, open the Word document. Your linked information is automatically updated. If you already have Word open and Excel is closed, just select the linked information and press F9.
What If the Linked Object Appears Cut Off?
Depending on where you insert your worksheet, it may look cut off. For example, your worksheet involves 12 rows, but only 10 appear. Don't worry! You have not lost any data. To prevent part of your worksheet from appearing cut off when it is linked, follow these steps:
1. In Excel, open the file.
2. On the File menu, click Page Setup, and then click the Page tab.
3. Click Fit to 1 page(s) wide by 1 tall.
4. Click OK to save your selections.
5. Save and close the file.
6. Update the link, if necessary.
If the line spacing in your document is set to an exact amount that is smaller than the height of the worksheet, perform the following steps:
1. In the Word document, select the worksheet.
2. On the Format menu, click Paragraph, and then click the Indents and Spacing tab.
3. In the Line spacing box, click Single. If you select Exactly, be sure to increase the point size in the At box to the height of the graphic.
If your worksheet still appears cut off, select it in the Word document so that sizing handles appear at the corners and along the edges. Drag a corner until it is the size that you desire.
How Do I Reposition the Linked Object?
When the worksheet is linked to your Word document, its default placement is in line with your text. If you want to reposition it, follow these steps:
1. In Word, click the worksheet once to select it.
2. On the Format menu, click Object, and then click the Layout tab.
3. Click Advanced.
4. On the Text Wrapping tab, select the Top and bottom wrapping style. (This is recommended; however, you may select another style.)
5. If you want to specify the worksheet's Distance from text, use the Top and Bottom boxes or type in a distance in inches. Some elements may be dimmed, depending on the selections you make.
Note Don't forget that you can right-click an element in the dialog box if you need further explanation to make your selections.
6. Click the Picture Position tab to select the worksheet's horizontal and vertical placement, as well as other options. Some elements may be dimmed, depending on the selections you make.
7. Click OK to close the Advanced Layout dialog box and save your selections.
8. Click OK to close the Format Object dialog box and reposition your worksheet.
http://office.microsoft.com/en-au/assistance/HA010448901033.aspx
