Embedded Excel

[Dennis Visentin]

I have a Word document with an embedded EXCEL cells.
The Excel Worksheet/Cells has many rows of information.
The number of rows is longer than what one WORD page can
hold.

Due to its length I was hoping that the embedded excel
section would continue to display on the subsequent
pages. Instead it just truncates. It only shows the rows
of information that can be visible on the first page.

How can I make it show the complete embedded excel
information on as many pages as needed, within Word?

Thanks

 

[macropod]

Hi Dennis,

You can't insert more than 1 page at a time from Excel into Word. Probably
the simplest way to insert multiple pages is to copy one page of Excel data
& paste into Word as a link (via Edit|Paste Special), then do the next page,
and so on.

Cheers

 

[KFinleyson]

Dennis,

It is true that Inserting a spreadsheet as an embedded
object will not correctly display all the cells in Word
when the worksheet is very long. I've also had this
problem and know exactly what you are talking about.

However, there is a work-around, and though it may not be
the most elegant solution, the worksheet will be updated
in Word just the same as if it were embedded with Insert
Object.

Essentially, all you do is use Edit|Paste Special, and
insert the worksheet as a linked Excel object. Using
Paste Special allows you to specify exactly what to
include from the file and gives you more control over
what exactly will/will not appear in Word. Use this
technique to manipulate the displayed portions of the
worksheet so that it appears your worksheet is embedded
and is spanning multiple pages.

Here's how to do it:

1. First, open your Excel worksheet. Select only those
columns/rows that will fit on the first page where the
worksheet will appear (for example, if your worksheet
displays halfway down the page, you may only want to
select 50 rows or so).

2. Copy the selected cells to the clipboard (Ctrl+C).

3. Switch to your Word document and position to the place
in the document where the selected cells will be
embedded.

4. Use Edit|Paste Special and paste the cells as a linked
Excel object.

5. Switch back to the Excel worksheet and select the next
set of cells. Copy the cells. Switch back to Word.
Position to where the next page would normally begin (you
may want to add a hard page return, Ctrl+Enter). Use
Paste Special to paste this set of cells as a linked
Excel object.

6. Repeat this process until the entire spreadsheet is
embedded in your Word document.

** If the data from the original spreadsheet changes, the
data in the Word document automatically updates, just as
if you embedded it the other way. The difference is that
Word uses a "Link" field code rather than an "Embed"
field code, but the end result is the same.

There is a good article on the web that explains how to
edit the link field code inside Word in order to re-set
which cells will appear in the document. See
http://www.computorcompanion.com/LPMArticle.asp?ID=33.

HTH,

-- Kim