Inserting Excel Spreadsheet

[Flexagon]

I have a Word document in which I want to include an Excel spreadsheet and I would like the Word document to update whenever the spreadsheet is changed. When I use Insert Object / spreadsheet, it works but the inserted spreadsheet is larger than one page and anything leftover just goes off into never never land. I tried using Insert File. This brings in the spreadsheet as a table. This works fine, except that every time the spreadsheet is changed, I have to manually delete then re-insert into the Word doc. I am not an Excel user and know only a few basics. Your suggestions are much appreciated.

[Twinnell]

Hi,
Open the workbook in Excel and then select only the range you want to see in the Word document (should fit on one page). Copy it to the clipboard and switch to the Word document, position the insertion point where you want the table, select Edit | Paste Special... and then click the option Paste Link. There you can choose between several different formats:
- To preserve the Excel formatting, select Microsoft Excel worksheet object.
- To insert as a Word table, select Formatted text (RTF)
when finished click OK.