Reply
 
Thread Tools Display Modes
  #1   Report Post  
Kendra
 
Posts: n/a
Default How do I make an embeded Excel worksheet span more than one page?

I'm trying to insert an Excel worksheet into a Word document as an embedded
object. The Excel worksheet is 3 pages long, but when I insert it into Word,
it won't show any more than will fit onto one page. How do I make it span
more than one page while still being able to keep it as an embedded object?
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

Hi Kendra-

Unfortunately an embedded/linked object cannot span a page break.

One option is to copy a certain amount of data from the workbook, then use
EditPaste Special to paste it onto a page in the Word doc, repeat as
necessary for the additional content.

Another option is to use InertFile and insert the worksheet as a table.

Good Luck |:)


On 6/10/05 5:57 PM, in article
, "Kendra" wrote:

I'm trying to insert an Excel worksheet into a Word document as an embedded
object. The Excel worksheet is 3 pages long, but when I insert it into Word,
it won't show any more than will fit onto one page. How do I make it span
more than one page while still being able to keep it as an embedded object?


--



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel worksheet issue JenC Microsoft Word Help 2 May 16th 05 04:11 PM
Linking Word to Excel worksheet Louise Microsoft Word Help 1 May 8th 05 07:51 PM
Auto-split an Excel Worksheet within a Word doc? MikeGaudet Microsoft Word Help 1 February 27th 05 07:29 AM
Auto-split an Excel Worksheet within a Word doc? MikeGaudet Microsoft Word Help 0 February 26th 05 04:53 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 07:21 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"