How to Fix Incorrect OLE Links and Scaling from Excel to Word
Question details
The user is experiencing formatting issues where linked Excel objects pasted into Word display with incorrect scaling and distorted letter spacing.
- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- Pasting and linking data from an Excel spreadsheet into a Word document using OLE (Object Linking and Embedding).
- Observed behavior
- The linked Excel objects appear at the wrong scale or with distorted spacing. Relinking temporarily corrects the formatting, but the issue returns and affects specific Word documents.
Save copies of both your Word document and Excel spreadsheet to a separate folder before attempting to update your software or break existing OLE links.
Update Microsoft 365 and Office Apps
Installing the latest Office updates is the most effective way to resolve known bugs related to OLE links and linked-object rendering issues.
Microsoft frequently addresses OLE and linked-object display issues through routine software updates. If your Microsoft 365 version is out of date, bringing it to the latest build often restores proper letter spacing and scaling for Excel objects.
Launch Microsoft Word or Microsoft Excel on your computer and open a blank document.
Click on 'File' in the top-left corner of the ribbon, then select 'Account' (or 'Office Account') from the bottom left menu.
Click on the 'Update Options' dropdown menu under the Product Information section, and select 'Update Now'. Allow the system to download and apply any pending updates.
Once the update is complete, restart your computer and open your Word document to see if the OLE links scale correctly.
Replace the Unstable OLE Links
Manually breaking and recreating the OLE links can resolve document-specific corruption causing distorted letter spacing.
Adjust Windows Display Scaling
Aligning display scaling across multiple monitors prevents Excel objects from resizing or distorting when moved between screens.
Avoid Complex OLE Link Errors with WPS Office
If Microsoft Office OLE links continue to cause formatting and scaling frustrations, consider switching to WPS Office. It provides a highly compatible, lightweight environment for your documents and spreadsheets, keeping your workflows simple and stable.
- 1. Download the Installer: Visit the official WPS website and click 'Download' to get the free installation package.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the suite on your device.
- 3. Open Your Files Natively: Launch WPS Office and directly open your existing .docx and .xlsx files to edit them without relying on unstable OLE links.
Frequently Asked Questions
Why does linked Excel data look distorted in Word?
Distortion typically happens due to outdated Office builds, corrupted document caches, or conflicts in display scaling settings across multiple monitors. OLE (Object Linking and Embedding) relies heavily on matching display resolution parameters.
What is the difference between Paste Link and embedding an object?
Using 'Paste Link' creates a dynamic connection where updates in the Excel file automatically reflect in the Word document. Embedding an object places a static, independent copy of the Excel data into Word that does not update when the original file changes.
How do I safely break an OLE link to an Excel file in Word?
In Word, go to File > Info > Edit Links to Files (this option only appears if the document contains links). Select the problematic Excel link from the list and click 'Break Link'. The linked data will turn into a static picture or table.
