How to Insert, Embed, or Link an Excel Spreadsheet in Word

Getting Excel data to auto-update inside a Word document requires one specific step that’s easy to miss. A regular Ctrl+V paste drops in a static table that never reflects source changes. Word has three built-in approaches: paste-link for a selected range, Insert Object for the whole workbook, and a fresh embedded worksheet for starting from scratch.

Method #1: Paste Special to Link a Selected Range

This is the fastest option when you only need part of a spreadsheet, a specific range of cells, to appear in Word and stay connected to the source file.

1. Open your Excel workbook and select the cells you want.
2. Press Ctrl+C to copy.
3. Open your Word document and click where you want the table.
4. On the Home tab, click the dropdown arrow beneath the Paste icon.
5. Choose Paste Special.
6. In the dialog, select Paste link on the left.
7. In the list on the right, choose Microsoft Excel Worksheet Object.
8. Click OK.

The linked range appears in your document. When you open the Word file after updating the Excel workbook, Word will prompt: “This document contains links to other files. Do you want to update this document with the data from the linked files?” Click Yes to pull in the latest data.

If you have both files open at the same time, right-click the linked table in Word and choose Update Link to refresh without closing anything.

To open the source workbook from inside Word, which is useful when you don’t know where the Excel file is saved, right-click the linked table, choose Linked Worksheet Object, then click Edit Link.

One limit worth knowing: this connection runs one direction only. Any edits you make directly to the table inside Word get overwritten the next time links refresh from Excel. The source workbook is always the authority.

Method #2: Embed or Link the Whole Workbook via Insert Object

Use this when you want the entire workbook, either embedded in the Word file or kept as a live connection to the original .xlsx.

1. In Word, click the Insert tab.
2. Click Object (look in the Text group, the button placement can vary slightly by build).
3. In the Object dialog, click the Create from File tab.
4. Click Browse and select your Excel file.
5. Choose your mode:

– To embed (self-contained copy, no live connection): leave Link to file unchecked. – To link (keeps Word connected to the original file): check Link to file.

6. If you want an icon instead of a spreadsheet preview, check Display as icon.
7. Click OK.

Embedded: The workbook’s current content copies into the Word file. File size grows, but the document is fully self-contained. Double-click the object to open and edit the workbook in Excel.

Linked: Word stays connected to the external .xlsx. If you move or rename the Excel file afterward, the link breaks. Fix it via File → Info → Edit Links to Files → Change Source.

Method #3: Create a New Excel Worksheet Inside Word

When there’s no existing spreadsheet, you need to build one from scratch and keep it inside the Word document, this is the right tool.

1. In Word, click the Insert tab.
2. Click Table.
3. At the bottom of the dropdown, click Excel Spreadsheet.

Word inserts an embedded grid and swaps the ribbon to Excel’s full interface, formulas, formatting, filters, all of it. Click outside the grid when you’re done to return to normal Word editing.

The embedded worksheet lives entirely inside the Word file. It’s a nicely done option for data that only belongs in this document. The full Excel engine running inside Word is cleverly compact, and it actually works better than Word’s native tables any time formulas or filtered data are involved.

Keeping Linked Data Up to Date

Linked objects don’t always refresh automatically. Word may default links to Manual, or it may prompt you on open rather than updating silently.

To control how a link updates:

1. Open the Word document containing the linked data.
2. Go to File → Info.
3. Click Edit Links to Files (Windows desktop Word only, limited or absent in some Mac builds, and not available in Word for the web).
4. Select the link in the list.
5. Set it to Automatic or Manual using the radio buttons.
6. Click Update Now to refresh immediately.
7. Use Change Source if the Excel file has moved or been renamed.

You can also press Ctrl+A to select everything in the document, then hit F9 to force all fields and links to refresh at once. Right-clicking a specific linked table and choosing Update Field does the same for that one object.

If links keep reverting to Manual after you change them, check File → Options → Advanced and look for link update settings under the General section.

Platform Notes

Mac: Word for Mac supports Insert → Object and Paste Special → Paste link in most current builds, and the steps closely follow Windows. The Edit Links to Files option under File → Info is limited or absent in some Mac versions. If it’s not there, manage each link individually by right-clicking the linked object in the document.

Word for the web: The browser version can display embedded and linked Excel objects that were created in desktop Word, but it can’t create or fully edit them. Click Open in Desktop App to work with linked or embedded data.

Troubleshooting

Linked table isn’t updating. The most common cause: the link is set to Manual, or the Excel file is closed. Open both files, right-click the table in Word, and choose Update Link. If it keeps defaulting to Manual, switch it to Automatic in File → Info → Edit Links to Files.

Link broke after moving a file. The connection is path-based. Move the Excel workbook and Word loses it. Reconnect via File → Info → Edit Links to Files → Change Source and point to the new location. Keeping both files in the same folder makes this much less likely.

Seeing an icon instead of a table preview. When inserting via Insert → Object → Create from File, “Display as icon” was checked. Delete the object and reinsert it without that checkbox to show the spreadsheet preview.

Formatting looks wrong after linking. Excel and Word render differently. For a pixel-accurate frozen layout, use Paste Special → Picture instead; you lose the live connection, but the appearance is exact. If the live link matters more, adjust column widths and fonts in Excel first so they translate cleanly into Word.

Can’t edit the embedded worksheet in your browser. Word for the web doesn’t support editing embedded workbook objects. Open the document in the desktop app.

Wrapping Up

Method #1, Paste Special with Paste link, is the one most people actually want. It’s fast, links cleanly to a specific range, and the update prompt on open keeps things smooth. Method #3 is a genuine gem when the data doesn’t need to exist anywhere else. The full Excel ribbon inside Word beats native Word tables every time formulas or filtered data are involved, and it’s worth recommending to anyone still wrestling with those tables.

If links keep breaking or silently stop refreshing, the Edit Links to Files panel is the first place to look. Switching to Automatic and clicking Update Now clears it up most of the time.