[WinkinVan]

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.


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

[WinkinVan]

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" wrote:

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


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

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.




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

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


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