PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?Rw==?=
Guest
Posts: n/a
 
      21st Feb 2006
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?
 
Reply With Quote
 
 
 
 
Tony Jollans
Guest
Posts: n/a
 
      21st Feb 2006
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.

--
Enjoy,
Tony


"G" <(E-Mail Removed)> wrote in message
news:F26BEB12-174D-4FB4-A8AA-(E-Mail Removed)...
> 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?



 
Reply With Quote
 
Dawn Crosier
Guest
Posts: n/a
 
      21st Feb 2006
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.

"G" <(E-Mail Removed)> wrote in message
news:F26BEB12-174D-4FB4-A8AA-(E-Mail Removed)...
> 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?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel spreadsheet linked into a word doc a compound document? =?Utf-8?B?TWVnaGFuUXVlcnJ5?= Microsoft Excel Misc 2 11th Dec 2010 11:37 PM
Resize linked Excel spreadsheet within Word RW Microsoft Word Document Management 1 17th Nov 2008 03:06 PM
Linked Excel spreadsheet longer than one page =?Utf-8?B?TGlhbU9mRm94Y2hhc2U=?= Microsoft Powerpoint 0 11th Oct 2007 09:07 PM
unable to delete page break on Excel spreadsheet =?Utf-8?B?c29uanN1bGw=?= Microsoft Excel Worksheet Functions 1 3rd Jun 2006 07:16 PM
How do I add another page to a word doc. w/out adding a pg break? =?Utf-8?B?VGFiZWE=?= Microsoft Word Document Management 0 2nd Mar 2006 10:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:11 AM.