How to Stop Linked Word Tables from Resizing When Excel Data Updates
Question details
The user needs to prevent tables linked from Excel to Word from automatically resizing or altering their layout upon data updates.
- Product
- Word, Excel
- Device & OS
- not provided
- Scenario
- Pasting an Excel table into Word using the Paste Special > Link & Keep Source Formatting feature and subsequently updating the source data.
- Observed behavior
- The linked table changes its cell sizes or overall layout when updated in Word, disrupting the document's formatting.
Verify that your Microsoft Office applications are fully updated, as linking glitches are often resolved in recent patches, and ensure you have saved copies of both files before troubleshooting.
Test the Linked Table in a New Document
Determine if the resizing issue is caused by corruption in your specific Word document by pasting the linked table into a fresh file.
Sometimes, the underlying XML structure of a Word document becomes corrupted, causing erratic behavior with linked OLE objects and tables. Isolating the table in a new document helps identify if the file itself is the problem.
Open Microsoft Word and create a completely new, blank document.
Open your source Excel spreadsheet, highlight the table data, and press Ctrl+C to copy it.
In the new Word document, go to the Home tab, click the arrow under Paste, select Paste Special, choose 'Paste Link', and select 'Keep Source Formatting'.
Change a value in the Excel spreadsheet, save it, and then right-click the table in Word and select 'Update Link'. Observe if the table resizes.
If the table does not resize in the new document, your original document is likely damaged. Copy the text from the old document into the new one, omitting the final paragraph mark to avoid carrying over the corruption.
Disable Automatic Resizing in Table Properties
Lock the table dimensions in Word to prevent the internal layout engine from automatically adjusting column widths to fit updated text.
Seamlessly Link Spreadsheets and Documents in WPS Office
Use WPS Office to securely link your spreadsheet data to your text documents without dealing with erratic formatting shifts or unwanted resizing.
- 1. Open both files in WPS Office: Launch WPS Office and open your text document in WPS Writer and your data file in WPS Spreadsheet.
- 2. Copy the spreadsheet data: Highlight the specific data range you want to link in WPS Spreadsheet and press Ctrl+C.
- 3. Use Paste Special in Writer: Navigate to your document in WPS Writer. Under the Home tab, click the drop-down arrow below Paste and select 'Paste Special'.
- 4. Insert as a linked object: Select the 'Paste Link' radio button, choose 'WPS Spreadsheet Object' from the list, and click OK.
- 5. Update seamlessly: Whenever you update and save the data in WPS Spreadsheet, your linked table in WPS Writer will update instantly while retaining its exact original layout.
Frequently Asked Questions
Why does my linked Excel table resize in Word despite choosing 'Keep Source Formatting'?
This usually happens because Word's 'Automatically resize to fit contents' setting overrides the static dimensions when new data is pulled in. It can also be caused by underlying document corruption in the Word file's XML code.
How do I force Word to stop updating my linked Excel table automatically?
You can change the link settings to manual. Right-click the linked table, select 'Linked Worksheet Object', click on 'Links', select the specific link in the dialog box, and check the 'Manual' update option. You will now need to press F9 or right-click and select 'Update Link' to refresh the data.
How do I break the link between my Excel table and Word document completely?
To remove the connection and turn the table into standard static text, right-click the linked table, select 'Linked Worksheet Object', click 'Links', choose the active link from the list, and click 'Break Link'. The table will no longer update when the Excel file changes.
