How to Fix Linked Excel Objects Resizing When Pasted into Word
Question details
Users need to stop linked Excel worksheet objects from changing their height and width percentages when embedded in Word.
- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- Pasting a linked Excel table into a Word document and subsequently reopening the file.
- Observed behavior
- The linked Excel worksheet object becomes distorted and automatically alters its original dimensions upon reopening the Word document.
Ensure that both your Word document and Excel spreadsheet are saved in the same local directory to maintain stable link paths before troubleshooting the sizing issue.
Isolate the Issue and Update Office
Test with a different sample table to check if the issue is file-specific and ensure your Office suite is up to date.
Sometimes OLE (Object Linking and Embedding) glitches are tied to a corrupted specific Excel range or a known bug in an older software build. Isolating the issue helps determine the next best step.
Create a simple, brand-new table in your Excel workbook. Copy it, open your Word document, and use 'Paste Special' > 'Paste Link' to insert it.
Save the Word document, close the application entirely, and reopen it to see if the newly pasted sample table also distorts or changes size.
If the new table also distorts, it may be a software version issue. Open Word, go to File > Account > Update Options, and click 'Update Now'.
Lock the Aspect Ratio of the Linked Object
Adjust the formatting properties of the linked object within Word to prevent it from scaling automatically.
Embed and Link Spreadsheets Flawlessly with WPS Office
WPS Office offers a unified suite where linking a spreadsheet into a document is stable and retains its exact original formatting. You can easily paste linked Excel objects into WPS Writer without worrying about sudden distortion upon reopening.
- 1. Open your files in WPS Office: Launch WPS Office and open both your spreadsheet and your document in the convenient unified tabbed interface.
- 2. Copy the spreadsheet data: Select the cells you want to link in the WPS Spreadsheet and press Ctrl+C to copy them.
- 3. Paste as a link in WPS Writer: Switch to the document tab, click the drop-down arrow under the 'Paste' button, choose 'Paste Special', select 'Paste Link', and pick 'WPS Spreadsheet Object'.
Frequently Asked Questions
Why does my linked Excel object distort when reopening Word?
This often occurs due to display scaling differences across monitors, changes in the default printer driver, or specific software bugs within Microsoft Office's handling of OLE (Object Linking and Embedding) components.
How can I paste Excel data into Word without linking?
Instead of using 'Paste Link', copy your data and use standard Paste (Ctrl+V) in Word, then select 'Keep Source Formatting' or 'Picture' from the Paste Options. This embeds the data statically, preventing it from resizing dynamically.
Does the display scaling of my monitor affect linked objects?
Yes, if the Excel file was created on a monitor with a different display scaling percentage (e.g., 125%) than the monitor used to open Word, OLE objects may miscalculate dimensions and appear distorted.
