[MB]

The spreadsheet is on one sheet, but 5 pages (portrait) long. Should each
page be separated into sheets, then insert each sheet separately?
--
MB


"Carol" wrote:

I believe you have to do this on a sheet by sheet basis. I am not aware that
you can just link and entire workbook in one fell swoop.

Open both the Microsoft Word document and the Microsoft Excel worksheet that
contains the data you want to create a linked object or embedded object from.
Switch to Microsoft Excel, and then select the entire worksheet, a range of
cells or the chart you want.
Click Copy .
Switch to the Word document, and then click where you want the information
to appear.
On the Edit menu, click Paste Special.
To link or embed the object, do one of the following:
To create a linked object, click Paste link.
To create an embedded object, click Paste.
In the As box, click the entry with the word "object" in its name. For
example, click Microsoft Excel Worksheet Object.
Note If you link data from a worksheet and select the Keep Source
Formatting and Link to Excel option, the linked data will match the
formatting in the Excel source file (source file: The file that contains
information that was used to create a linked or embedded object. When you
update the information in the source file, you can also update the linked
object in the destination file.). If you select the Match Destination Table
Style and Link to Excel option, the linked data will be formatted in the Word
default table style.

With either option you can change the formatting of the linked object in the
Word document. Formatting changes you make will remain when the data is
updated in the source file

--
Carol A. Bratt, MCP



"MB" wrote:

I'm trying to link a spreadsheet into a Word document. When I InsertObject
and link the file, the spreadsheet includes other columns that are not in the
print area. Also, only one page will be inserted. (It's a 5-page
spreadsheet.) The "set print area" is correct. (By the way, it's important
that the spreadsheet is linked.)

I tried copy and paste special, but that only appears very small and still
on one page in Word.

I'm using Word and Excel 2003.

Thanks so much!
--
MB