Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking multipage Excel on Word (Excel XP)

    HAve an excel spreadsheet that is approximately 150 rows in length. I can link this to a Word document, however when I link it, it will only show up on one page in Word. Obviously, it needs to stretch over a number of word pages to get all 150 lines.

    Tried to force page breaks in Excel in order for it to fill page to page in Word, but this didn't work.

    There must be a way to do this?????? It must be linked as opposed to embed.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking multipage Excel on Word (Excel XP)

    There is no really good way to do what you want. Why don't you put a hyperlink to the spreasheet in the document? (Ctrl+)Clicking on the hyperlink will open the document in Excel, so that all rows are visible.

    The alternative would be to put more than one linked Excel object in the document, one for each page.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking multipage Excel on Word (Excel XP)

    Thanks Hans. The Hyperlink is an alternative that is not acceptable to the users. The information must be in a Word document. Just thought that by having it linked they could make changes in the original Excel sheet and have an automatic update in the word document.

    Thanks, anyway.

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Linking multipage Excel on Word (Excel XP)

    Hi kiazd,

    If you insert the linked object using the formatted or unformatted text options, instead of the worksheet option, you can have the data span multiple pages. The formatted text option will give you a table layout, whilt the unformatted text will give you a tabbed paragraph layout.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •