Adding a page break to a Word doc with an Excel spreadsheet linked

[Guest]

I've linked an Excel Spreadsheet into a Word doc but the Excel doc, a page
long, remains on the second page and will not page break in the Word
document. I've added page breaks to the Excel doc but with no luck. Any
suggestions?

 

[Tony Jollans]

Excel Worksheets are effectively single graphical objects as far as Word is
concerned when it comes to page / document layout and they cannot break
across pages. If they are too big to fit on the current page they will be
moved to the start of the next page. The structural content of them is
beyond Word's reach.

 

[Dawn Crosier]

An Excel Spreadsheet embedded inside of Word is an Object. Word will
treat it the same as though it was a graphic and keep it all on one
page, and hide the portions which don't fit.

However, if you open it, select all the information stored inside it,
copy, click into your Word document and Paste, Word will convert it to
a Word Table.

Another alternative will be to have more than one embedded object each
showing a different "page" worth of information.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message is posted to a newsgroup. Please post replies and
questions to the newsgroup so that others can learn as well.