The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Office 2007: problem putting Excel sheets in Word documents

    Discussion in 'Windows OS and Software' started by Malia, Oct 5, 2007.

  1. Malia

    Malia Notebook Evangelist NBR Reviewer

    Reputations:
    273
    Messages:
    657
    Likes Received:
    0
    Trophy Points:
    30
    I've had problems putting Excel worksheets in Word before, but none so bad. The same thing happens regardless of whether I link to file or embed. Take a look at the screenshot. The tables look horribly pixelated. However, if I double-click on one to edit it (if it's embedded), it looks fine. That's because what's listed as 100% in object size is not actually 100% but something more like 110. I have to play guess-and-check with 90-95% to make it not pixelated. However, it refuses to make width and height the same percentage. Let's say I put in 95% width. If constrain proportions is checked, it'll change height to 95%. If it's not checked, I'll just put in 95%. I click ok. (There's no apply button anymore.) It still looks messed up. I go to object properties again, and what do I see? Height is at 96% and width, at 106%. The difference between the two is always 10%. Arrg! So, has anyone been able to fix that?
     

    Attached Files:

    • ss.gif
      ss.gif
      File size:
      145 KB
      Views:
      308
    Malia, Oct 5, 2007
    #1
  2. ToxicBanana

    ToxicBanana Notebook Consultant NBR Reviewer

    Reputations:
    19
    Messages:
    170
    Likes Received:
    0
    Trophy Points:
    30
    In Office 2003, working with embedded Excel sheets was always a pain in the ass. However, I find in Office 2007, everything is much smoother.

    I'm not sure what is causing the pixelation if the size is set to 100% in the object properties. Try clicking the reset button on the size tab of the object properties.
    Otherwise, copy the data from the Excel sheet and then in Word do a paste special as HTML format. This will basically place your data into a table in word - no pixelation
     
    ToxicBanana, Oct 5, 2007
    #2