Embedding spreadsheets in WORD

[Guest]

Hello all,

I have two pages of an EXCEL spreadsheet that I have embedded into a WORD
document. The spreadsheet is too large to fit on one page in WORD, so I cut
it into two pages -- one inserted on the first spreadsheet page and the
second inserted on the second spreadsheet page.

Presently, the only way I have been able to figure out how to add up all of
the data is to create a subtotal at the bottom of page one and then manually
enter those figures into a "Balance Forward" cell on page 2. Needless to say,
this is not a convenient way of going about things -- especially for the
people I've designed the form for.

Is there a better -- preferably, automated, way of handling this situation?

Thanks for any assitance you can give.

 

[Jezebel]

Create a single spreadsheet. Instead of embedding, link sections of the one
spreadsheet to your Word pages.

 

[Guest]

Thanks for the information. Could you provide me with a little more detail.
For example, when I select "Edit, Paste Special, Paste Link" I am provided
with several choices. Once, I selected the default they gave me ("HTML
Format") and the next time "MS Excel Worksheet Object". On both occasions I
selected OK and then double clicked on the spreadsheet that showed up in
WORD. Then I entered data. When I saved the information, the results showed
in the Excel spreadsheet, but not what I could see in WORD.

Any other thoughts that you could provide to assit me would be greatly
appreciated.

 

[Jezebel]

Open both the document and the spreadsheet. Select the part of the
spreadsheet you want to see on page one of your document. Copy. Switch to
Word. Edit > PasteSpecial > Link. Repeat for page two.