How to Link Excel to Word (and Why the Link Breaks)
Paste Link takes ten seconds. Then next month’s data adds a row, the table in Word still ends where it did, and nothing tells you. Link to a named range and you avoid most of that.
To link Excel to Word, copy the cells in Excel, then in Word use Home → Paste → Paste Special → Paste link. The Word file then stores only the location of the source file and can update when the workbook changes. One thing the usual instructions leave out: copy a named range, not a block of cells. Otherwise the link stays fixed to those exact rows and silently leaves out next month's data.
Link a table, step by step
- Save the workbook in its permanent home. The link stores the file path, so moving the file later breaks it.
- Name the range. Select the table, click the Name Box to the left of the formula bar, type
MonthlySalesand press Enter. - Copy it, then click where it belongs in Word.
- Choose Home → Paste → Paste Special. Select Paste link, choose a format, and click OK.
| Paste link as | What you get | Use it when |
|---|---|---|
| Microsoft Excel Worksheet Object | A picture of the range; double-click opens Excel | Layout must match Excel exactly |
| HTML Format | A Word table you can style | The table should match the document |
| Unformatted Text | Plain text in your sentence | One figure inside a paragraph |
| Picture | An image | A chart that must not reflow |
A chart
Copy the chart in Excel, then in Word use the paste options and pick one of the Link Data choices. Use Destination Theme & Link Data makes it match your document.
One number inside a sentence
This is underused. Copy a single cell and Paste link it as Unformatted Text in the middle of a sentence, and the figure becomes a live field. If a stray line break comes with it, delete the break and keep the field. Format the value in Excel with TEXT() if you need a currency symbol, because the text arrives as Excel displays it or close to it. Check it after the first update.
The fixed-range trap
Press Alt+F9 in Word to see the field behind a link. It looks something like this:
{ LINK Excel.Sheet.12 "C:\\Reports\\Sales.xlsx" "Sheet1!R1C1:R13C4" \a \f 0 \p }See R1C1:R13C4. That is the range, and it does not grow. When you add a fourteenth row in Excel, the table in Word still stops at thirteen, with no error and no sign anything is missing. If the bottom row is a total, the new rows may push it out of view altogether.
A linked name avoids this, as long as the name itself grows. Press Alt+F9 again to return to the normal view. In Excel, make the source a formatted Table with Ctrl+T, then define your name as that table's range so it expands along with the data, for example =Sales[#All]. Test it once by adding a row and updating before you rely on it.
Managing links
Go to File → Info → Edit Links to Files, near the bottom right. Every link is listed with its source and range, and this is where you can:
- Set each link to Automatic or Manual. I would use Manual on anything going to other people, so that updating is a decision.
- Update Now, or press Ctrl+A then F9 in the document.
- Change Source when the workbook moves.
- Break Link to freeze a final version.
Why the link breaks
- The workbook moved or was renamed. Use Change Source. This is the most common cause by far.
- The path differs on another computer. Mapped drives and synced OneDrive folders can give different paths to different people. The same problem affects PowerPoint, as we cover here.
- Someone inserted a row above the range. A plain cell reference can now point at the wrong rows. This one is the most dangerous, because it still shows numbers, just the wrong ones. A named range follows the cells.
- The prompt was declined. The document shows its last saved values.
In every one of these cases, the document can look complete. A stale link shows its previous values rather than an error, so add a data as of line that links to a date cell in the same workbook. When that date is wrong, you know.
Links are a good solution for the person who built them, on the machine where they built them. The trouble starts on the day that person is on holiday and a colleague opens the report, gets a security prompt they do not recognize, and clicks No because that seems safe. The document opens, it looks fine, and last month's table goes out in this month's report. That is why I would treat the file path as part of the process and write down where the workbook lives and who updates it. A process that only one person understands has not really been automated. It has been made invisible.
When to stop linking
Links hold up well for a handful of tables in a document one person maintains. I would stop at about ten linked objects, or when several people edit the report, or when the sentences need to change along with the tables. A link can carry a number but not a judgment, so a sentence saying sales rose keeps saying so after they fall.
The document that asks instead
Quiriz for Word takes the workbook out of the path. Type a question anywhere in the document, such as net sales by month for 2026 year to date, select it, and press Chart, Table, Both, Figure or Notes. The answer replaces the words that asked for it. A figure is one number inside your own sentence, tables are real Word tables, and Notes is written commentary.
Next month, once the new data is in your datasets, Refresh all asks every question again. Turn on tracked changes for refreshes and Word shows each figure that moved as a revision you can accept or reject, which is a much better review than reading the whole report for changes.
Where the link still wins. Quiriz reads datasets, not your workbook's formulas. If a figure comes from a hand-built model, keep it in Excel and link to it. And for one table in one memo, Paste link is the right size of tool.
Reports that update without a file path
Try the questions on sample company data with no signup, then write your first report in Word.
Try Quiriz free →