Share via

OLE Links distorted in Word for Windows

Anonymous
2024-05-21T15:47:44+00:00

Hello,

I am working on a project that involves me inserting Worksheets from Excel into Word. The current steps I am using are:

  1. Highlighting worksheet to name
  2. copying worksheet (Control C)
  3. In Word under the Home option: Paste, Paste Special, Paste Link, As: Microsoft Excel Worksheet Object

I then resize image in Word by:

  1. Right click link
  2. Picture
  3. Size
  4. Width Absolute (changing to size that is appropriate

The link then looks great. If I print it looks correct and print to PDF it also looks correct. After saving and closing I feel confident that the image and link is correct. Later, I will reopen the document for more editing and my links are either not linked and distorted. If I double click the link it almost alerts the link to wake up and work. But it's distorted after so I have to delete the OLE Link and re-add to the word document.

Does anyone have a solution so I can add my link from Excel to Word and know this will not change after closing the document.

Thank you for your help.

Microsoft 365 and Office | Word | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-04T17:24:17+00:00

    If I embed the link, will the excel file be easy to update as needed?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-05-21T20:52:06+00:00

    Dear Leann Geyer,

    I'm sorry to hear that you're experiencing issues with OLE links in Word. One possible solution is to try embedding the Excel worksheet instead of linking it:

    1. Open the Excel worksheet that you want to insert into Word.
    2. Select all the cells that you want to include in the embedded object.
    3. Right-click on the selection and choose "Copy" or press "Ctrl+C".
    4. Open the Word document where you want to insert the embedded object.
    5. Click on the location where you want to insert the object.
    6. Right-click and choose "Paste" or press "Ctrl+V".
    7. In the Paste Options that appear, choose "Keep Source Formatting & Embed Workbook" or "Keep Source Formatting & Embed Worksheet".
    8. Resize the embedded object as needed.

    By embedding the Excel worksheet, you won't have to worry about the link breaking or becoming distorted when you reopen the Word document.

    Thank you for your understanding and cooperation! Have a great day.

    Sincerely,

    Sean | Microsoft Community Moderator

    Was this answer helpful?

    0 comments