[suziep]

I am trying to insert an embedded worksheet into a Word document. But, the
worksheet is over a page long. How can I make the worksheet break at a
particular point so it will display and print properly? Reason being, is
that there are several sections that I need to imput information and have it
total.

[garfield-n-odie [MVP]]

An embedded object in a Word document cannot span a page. If you only
need a simple sum, you might try copying and pasting the Excel range
into Word as a table and then creating a sum formula in the Word table.

suziep wrote:

I am trying to insert an embedded worksheet into a Word document. But, the
worksheet is over a page long. How can I make the worksheet break at a
particular point so it will display and print properly? Reason being, is
that there are several sections that I need to imput information and have it
total.

[Jay Freedman]

suziep wrote:
I am trying to insert an embedded worksheet into a Word document.
But, the worksheet is over a page long. How can I make the worksheet
break at a particular point so it will display and print properly?
Reason being, is that there are several sections that I need to imput
information and have it total.

An embedded spreadsheet is an "object", and Word cannot ever display an
object that crosses a page boundary. You'll have to copy smaller pieces of
the spreadsheet and paste the pieces separately into the Word document.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

[suziep]

Thanks, but if I paste each section separately, how do I get a grand total
for all the sections?

"Jay Freedman" wrote:

suziep wrote:
I am trying to insert an embedded worksheet into a Word document.
But, the worksheet is over a page long. How can I make the worksheet
break at a particular point so it will display and print properly?
Reason being, is that there are several sections that I need to imput
information and have it total.

An embedded spreadsheet is an "object", and Word cannot ever display an
object that crosses a page boundary. You'll have to copy smaller pieces of
the spreadsheet and paste the pieces separately into the Word document.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

[Jay Freedman]

Have Excel calculate the total, and paste that into Word as well.

suziep wrote:
Thanks, but if I paste each section separately, how do I get a grand
total for all the sections?

"Jay Freedman" wrote:

suziep wrote:
I am trying to insert an embedded worksheet into a Word document.
But, the worksheet is over a page long. How can I make the
worksheet break at a particular point so it will display and print
properly? Reason being, is that there are several sections that I
need to imput information and have it total.

An embedded spreadsheet is an "object", and Word cannot ever display
an object that crosses a page boundary. You'll have to copy smaller
pieces of the spreadsheet and paste the pieces separately into the
Word document.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.