Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Nov 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    link object from excel (2007)

    Subject edited by HansV: the Excel version is 2007, not 7

    Trying to copy 88 lines from excel chart paste special as excel worksheet object then selecting paste link. Results are only 66 lines visible. How do i entire spreadsheet

    Lynette
    Attached Files Attached Files

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

    Re: link object from excel (2007)

    Welcome to Woody's Lounge!

    The range that you want to paste as a worksheet object is taller than a single page, so Word truncates it.
    You can reduce the object in size, so that the entire contents are displayed, although at a smaller scale: right-click the Excel object and select Size from the popup menu.
    Change the height to a number that will fit on the page, e.g. 9" or about 23 cm, then click OK.

  3. #3
    New Lounger
    Join Date
    Nov 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link object from excel (2007)

    Thanks Hans,

    What if I would like to leave it for the 2 pages without truncating it.

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

    Re: link object from excel (2007)

    An Excel worksheet object is contained in a single page of the document; it cannot stretch across two pages.

    One possible workaround is to copy / paste special the top half of the range into one page, then copy / paste special the bottom half into the next page. In other words, you'd have two separate Excel worksheet objects.

    Another workaround is to paste special using HTML format or as formatted text. The Excel data would become a table in Word, and a table can stretch across multiple pages.

  5. #5
    New Lounger
    Join Date
    Nov 2008
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link object from excel (2007)

    Thank you Hans for the quick response, I did paste as an HTML with the update link and it still updates between Excel and Word, that is what I needed.

    Lynette

Posting Permissions

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