Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Embed Large Excel worksheet into Word (Word-Excel

    A client is attempting to embed an Excel 2000 worksheet that is wide (Columns A through O) and many rows high.

    I can't resize the embedded Excel object in Word to display the desired range. A narrower worksheet range slightly wider than the Word document margins can be adjusted, but not this wider range!

    Any suggestions? Is there a size limitation from Excel into Word?

    Thanks,
    Rich

  2. #2
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Re: Embed Large Excel worksheet into Word (Word-Excel

    I faced a similar problem in the past, and my solution for the instance was to embed the Excel as an icon.
    then, when the reader clicks on it, it will open the application in another window.
    beware that it becomes interactive and could be modified, unless you protected certain (or all) cells.
    hope this helps.
    regards,

    daniel rozenberg.

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

    Re: Embed Large Excel worksheet into Word (Word-Excel

    Have you tried putting the worksheet on a landscape page in Word?
    Have you tried reducing the width of the area in Excel, before copying/pasting it into Word?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Embed Large Excel worksheet into Word (Word-Excel

    Another hint would be to change the view to normal instead of print or page layout then you can resize the object

  5. #5
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Embed Large Excel worksheet into Word (Word-Ex

    Hello y'all,

    Thank you for all of your kind suggestions.

    I have tried all of your suggestions to no successful result! :-(

    Eventually, this Word document is going to be converted to a PDF, so an icon doesn't meet our needs.

    Turns out, that in the previous edition, someone made an image of the Excel worksheet and put that in the Word document.

    I still am interested to know if there exists a limitation someone has uncovered?

    Thanks so much,
    Rich <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  6. #6
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Embed Large Excel worksheet into Word (Word-Ex

    There is a width limit to how much Excel worksheet can be pasted into Word - you lose columns from the right if your Excel object is too wide. Refer to this old thread for some hints

    If you are going into PDF anyway why don't you create a PDF page from Excel and then add that page into the PDF created from Word?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Embed Large Excel worksheet into Word (Word-Ex

    If you only need an image ... not an embedded worksheet, copy the cells, go to word choose edit paste choose picture(windows metafile). The image will be resized to fit within the margins of the word document.

Posting Permissions

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