Document Editing Problems

Fix Word Links to Excel Disappearing After Saving

Steve KSteve K Oct 26, 2026 869 views

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.

How to Fix Word Links to Excel Disappearing After Saving
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.
Before you start

Ensure both your Word document and Excel workbook are saved in a stable, accessible location on your local drive before creating the OLE links.

Solution 1Recommended

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.

1
Copy the Excel data

Open your Excel workbook, select the specific table or cell range you want to link, and press Ctrl+C to copy it.

2
Open the Paste Special dialog in Word

Go to your Word document, click the 'Home' tab, click the drop-down arrow below the 'Paste' button, and select 'Paste Special'.

3
Select Paste Link

In the Paste Special dialog box, select the 'Paste Link' radio button on the left side.

4
Choose Worksheet Object

From the 'As:' list, choose 'Microsoft Excel Worksheet Object' and click OK to insert the linked table.

5
Save as DOCX

Go to File > Save As, and ensure the 'Save as type' dropdown is set strictly to 'Word Document (*.docx)'.

Use Paste Special and Save in DOCX Format
Display Size Note: The Worksheet Object option preserves the live workbook link but may display at a slightly different size or zoom level in Word. You can manually resize the object by dragging its corners.

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. 1. Copy your spreadsheet data: Highlight and copy your desired data range directly from WPS Spreadsheet.
  2. 2. Use Paste Special in WPS Writer: Open WPS Writer, navigate to the Home tab, click the Paste dropdown, and select Paste Special.
  3. 3. Link the object: Select the 'Paste Link' option, choose 'WPS Spreadsheet Object', and click OK.
  4. 4. Save your document: Save your document in the standard .docx format to lock in the live connection permanently.
Flawless compatibility with Microsoft Word (.docx) and Excel (.xlsx) file formats.Reliable 'Paste Special' functionality to keep live data links intact between files.Lightweight, fast installation with an intuitive, unified tabbed interface for all office apps.
microsoft office alternative - wps office

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'.