[Carol]

Hi Taz:

Those are Microsoft instructions that I copied off of their website. I was
at the office and didn't have my Excel books and bibles with me. But you're
right....I need to be more careful. I do believe that most of the
instructions were right on to what the OP needed. As always, thanks for
coming to the rescue when I've fallen a wee bit short.

Have a great weekend!
--
Carol A. Bratt, MCP



"CyberTaz" wrote:

Hi Carol - Where did you find these instructions? I think they may be
somewhat out of date... perhaps for a different version of Word?

Although 'accurate' up to that point, the Note at the end just doesn't seem
to apply in Word 2003...The Paste Special dialog doesn't offer either of the
two formatting options described the

Keep Source Formatting and Link to Excel
Match Destination Table Style and Link to Excel

Nor is there any ensuing dialog that offers them.

Likewise the last point about changing the formatting of the Linked object
in Word is totally false, at least if you use the native object type (MS
Office Excel Worksheet Object in this case). The Formatted text (RTF) & HTML
options deliver Word tables which can be reformatted in the doc, and
Unformatted Text - although editable - renders tabular text without table
structure. Any of the other choices render a graphic object.

A linked object rendered as a graphic is essentially a "snapshot" of the
source file's content & updates based on changes that take place there. In
Word it's treated more like a picture - you can apply Borders & Shading,
Brightness & Contrast, but that's about it. Anything else gets overridden
whenever the link is updated.

--
Regards |:)
Bob Jones
[MVP] Office:Mac


"Carol" wrote in message
...
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