Fix Word Links to Excel Disappearing After Saving
Question details
The user needs a persistent live link between an Excel table and a Word document so that the connection remains active after saving and reopening.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Pasting a copied Excel table into a Word document with the intention of maintaining a live, updatable link.
- Observed behavior
- The pasted Excel table updates initially, but the link breaks or disappears completely once the Word document is saved, closed, and reopened.
Ensure both your Word document and Excel workbook are saved in a stable, accessible location on your local drive before creating the OLE links.
Use Paste Special and Save in DOCX Format
Properly inserting the Excel data using the Paste Special feature and choosing the correct file format ensures the workbook link is preserved permanently.
The standard paste function often strips out link metadata upon saving. Using Paste Special allows you to embed a persistent Worksheet Object.
Additionally, saving the file in older compatibility formats (.doc) can cause OLE links to drop. Always use the modern .docx format.
Open your Excel workbook, select the specific table or cell range you want to link, and press Ctrl+C to copy it.
Go to your Word document, click the 'Home' tab, click the drop-down arrow below the 'Paste' button, and select 'Paste Special'.
In the Paste Special dialog box, select the 'Paste Link' radio button on the left side.
From the 'As:' list, choose 'Microsoft Excel Worksheet Object' and click OK to insert the linked table.
Go to File > Save As, and ensure the 'Save as type' dropdown is set strictly to 'Word Document (*.docx)'.

Verify Link Integrity and File Paths
If the link still disappears, the file path to the source Excel workbook might be broken, or the source file may have been moved.
Seamlessly Link Spreadsheets to Documents with WPS Office
WPS Office offers flawless integration between WPS Writer and WPS Spreadsheet. You can easily paste linked tables that stay connected, ensuring your reports are always up-to-date without formatting or link-dropping glitches.
- 1. Copy your spreadsheet data: Highlight and copy your desired data range directly from WPS Spreadsheet.
- 2. Use Paste Special in WPS Writer: Open WPS Writer, navigate to the Home tab, click the Paste dropdown, and select Paste Special.
- 3. Link the object: Select the 'Paste Link' option, choose 'WPS Spreadsheet Object', and click OK.
- 4. Save your document: Save your document in the standard .docx format to lock in the live connection permanently.

Frequently Asked Questions
Why does my linked Excel table resize automatically when pasted into Word?
When pasted as a Worksheet Object, Word embeds an exact representation of the Excel cells. Differences in scaling and default zoom levels between the two programs can cause slight enlargement or resizing.
Can I keep an Excel link active if I save the Word document in the older .doc format?
It is highly recommended to save your Word document in the newer .docx format. Older .doc formats may not fully support modern OLE (Object Linking and Embedding) features, which frequently causes live links to drop upon saving.
What happens to the Word link if I move the Excel file to another folder?
The link in your Word document will break because it relies on the absolute file path of the source Excel file. You will need to navigate to File > Info > Edit Links to Files to manually point Word to the new file location.
Do links update automatically when I reopen the Word document?
Yes, Word will typically prompt you with a security message asking if you want to update links when you open the document. You can also manually force an update by right-clicking the linked object and selecting 'Update Link'.




