How to Save Word File With Embedded Linked Excel Data

When you insert Excel data into a Word document, you can choose to link it rather than embed it. A linked object updates automatically when the source Excel file changes. However, saving this Word file correctly is essential to preserve the link and avoid broken references. This article explains how to embed linked Excel data in Word so the connection stays intact when you move or share the file. You will learn the steps to insert the link, adjust update settings, and save the document so the data remains accessible.

How Linked Excel Objects Work in Word

A linked Excel object in Word stores a reference to the original Excel file rather than copying all the data into the Word document. When you open the Word file, Word reads the data from the Excel file and displays it. If the Excel file changes, the Word document can reflect those changes automatically or on demand.

This is different from embedding, where a static copy of the Excel data is stored inside the Word document. Embedded data does not update when the source changes. Linking is ideal when the Excel data is frequently updated and you want the Word report to stay current.

To use linked objects, you need access to the original Excel file. If you move or rename the Excel file, the link breaks unless you update the link path. Word provides settings to store the link path inside the document, which helps when you move both files together to a new folder or a different computer.

Steps to Insert and Save a Word File With Linked Excel Data

Follow these steps to insert a linked Excel object and save the Word document correctly. The process works the same in Word for Microsoft 365, Word 2021, Word 2019, and Word 2016.

1. Open Word and place the cursor where you want the Excel data
   Click in the document at the location where the Excel table or chart should appear.
2. Insert the linked object
   Go to the Insert tab. In the Text group, click Object. In the Object dialog box, select the Create from File tab. Click Browse and locate the Excel file that contains the data you want to link. Check the box Link to file. Do not check Display as icon unless you want an icon instead of the actual data. Click OK. The Excel data appears in your Word document.
3. Verify the link is active
   Right-click the inserted object. In the shortcut menu, point to Linked Worksheet Object and select Links. The Links dialog box shows the source file path and the update method. The default update method is Automatic, which means Word updates the data every time you open the document. You can change it to Manual if you prefer to update the link only when you choose.
4. Update the linked data before saving
   If you want to ensure the Word document contains the latest data, update the link manually. Go to File > Info. Click Edit Links to Files. In the Links dialog box, select the link and click Update Now. Click Close.
5. Save the Word document with the link data
   Press Ctrl+S or go to File > Save As. Choose a location and file name. Before clicking Save, click Tools (next to the Save button) and select Save Options. In the Word Options dialog, under Save, scroll to Preserve fidelity when sharing this document. Check the box Save link data in the document. This stores the link path inside the Word file. Click OK. Then click Save.
6. Test the link after saving
   Close Word and reopen the saved document. If a security warning appears about automatic update of links, click Enable Content. Right-click the object and select Update Link if the data did not refresh automatically. The data should match the current values in the Excel file.

What Happens When You Move Both Files to a New Location

If you move the Word file and the Excel file to a different folder or a different computer, the link can break if the relative path changes. To keep the link working, move both files together and keep them in the same relative folder structure. For example, if both files are in the same folder, the link remains valid. If you move only the Word file, the link will point to the original Excel file location and will not find it.

To fix a broken link, go to File > Info > Edit Links to Files, select the link, and click Change Source. Browse to the new location of the Excel file and click Open. Then click Update Now to refresh the data.

Common Issues When Saving Word Files With Linked Excel Data

Word Shows a Security Warning About Links When Opening the File

Word displays a yellow security bar with the message that automatic update of links has been disabled. This is a security feature to prevent malicious links from executing. Click Enable Content to allow the link to update. If you trust the source, you can change the trust center settings: go to File > Options > Trust Center > Trust Center Settings > External Content, and select Enable all Automatic Update for Links. Use this option only for documents from trusted sources.

Linked Data Does Not Update After Saving

If the linked data does not reflect changes made to the Excel file, check the update method. Right-click the object, point to Linked Worksheet Object, and select Links. Ensure the update method is set to Automatic. If it is set to Manual, click Update Now to refresh the data. Also verify that the Excel file is still accessible at the original path. If the file was moved, use Change Source to point to the new location.

Word Document Size Is Larger Than Expected

Even with linked objects, Word may store a cached preview of the Excel data to display in the document. This cached data increases file size. To reduce file size, save the document without the cached preview. Go to File > Options > Advanced. Under Cut, copy, and paste, uncheck Show Paste Options buttons and uncheck Use smart cut and paste. Then save the document again. Note that this removes the preview, so the document will show the data only when the link is updated.

Linked vs Embedded Excel Data: Key Differences

Item	Linked Object	Embedded Object
Data storage	Stored in external Excel file	Stored inside the Word document
File size	Smaller	Larger
Updates	Automatic or manual from source file	No updates from source
Dependency	Requires access to source Excel file	No external dependency
Sharing	Must share both files or update links	Single file contains all data

Now you can insert linked Excel data into Word and save the document with the link intact. Before sharing the file, update the link data and save with the link data option enabled. If you move the files, keep them together or use Change Source to repair the link. For a more advanced setup, try using Word fields with the INCLUDEPICTURE field to link to Excel charts instead of using the Object method.