Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserting an Excel spreadsheet as a Word object (Word/Excel 2000)

    I'm trying to insert a 1-page Excel chart into a Word 2000 document. It's a very odd spreadsheet - what the client did (for some strange reason) was mimic a GANTT chart in Excel. Anyway, the problem is that only part of the chart comes into Word when I insert it as an object.

    I tried reducing the size of the chart in Excel, playing around with margins, page orientation, etc. The paper size is A4 with .25" margins (which I duplicated in Word), but a relatively small part of the right side of the chart is truncated every time (no matter what I do).

    Any suggestions?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting an Excel spreadsheet as a Word object (Word/Excel 2000)

    David have you tried making it smaller in Excel first??? It might come across better then. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting an Excel spreadsheet as a Word object (Word/Excel 2000)

    David,

    I had a similar problem when I did a term paper a year ago. As I recall, my solution worked because I didn't need to maintain a link to the sheet. I just used (I hope I remember correctly) Ctrl-Shift-F9 to de-link and convert it to a graphic which I then resized.

    HTH
    Ken

  4. #4
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting an Excel spreadsheet as a Word object (Word/Excel 2000)

    This is an end run rather than a direct solution, but when I ran into a similar problem, I ended up printing it out, scanning it, and inserting the .tif file as a picture [.tif, not .pdf, and only one page at a time]. The picture is smaller than the original, but you can decrease the margins for that page [with continuous section breaks before & after], then go into the Format menu, select Format Picture, go to the Size tab, and increase the % size.

    It's crude, but fast and effective if you're under time pressure.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting an Excel spreadsheet as a Word object (Word/Excel 2000)

    I have used Edit/Paste Special, and pasted my spreadsheets using "Paste Link" and "as a picture". That way they are still linked, but I can use Word's graphic features.
    egghead

Posting Permissions

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