How to link Excel to Word

Native steps checked against Microsoft Support on 16 November 2026 · updated 16 November 2026

To link Excel to Word, copy the range in Excel, paste it into Word with Ctrl+V, then open Paste Options and choose Link and Keep Source Formatting. The table stays tied to the worksheet and updates when the source data changes.

The native Excel method

  1. In Excel, select the data you want in Word and press Ctrl+C.
  2. In Word, click where the table should go and press Ctrl+V.
  3. Open Paste Options next to the pasted data.
  4. Choose Link and Keep Source Formatting to keep the table linked to the worksheet.
  5. Update the workbook and the linked table refreshes with the new values.

Data and charts take different options

Microsoft splits the two cases. For a chart the linked options are Use Destination Theme and Link Data, or Keep Source Formatting and Link Data. For a range of data the options are named differently: Link and Keep Source Formatting, or Link and Use Destination Styles (Microsoft Support).

Both data options keep the table tied to the original worksheet and update it when the source changes; the difference is whether Word’s styles are applied.

A link survives edits to the data but not a move of the target. Rename the workbook, move it to another folder or delete the sheet, and the link fails. Microsoft’s documentation notes that unlinking is deliberate — you re-paste as unlinked data or as a picture (Microsoft Support) — but says nothing about detecting a broken link before the document is sent.

That is the gap that catches reviewers: a memo looks right, and the table behind it points at a file nobody has any more.

The CalcoraSuite way (planned)

The planned link carries a report of references that no longer resolve, so a memo can be checked before it leaves the team. See the Excel to PowerPoint link page — the Word side is part of the same feature and carries the same status.

The CalcoraSuite way

Planned, not released. The excel to powerpoint link page carries the current status of each step (planned).

  1. Link the table in the memo to the range that feeds it.
  2. Refresh the document when the model changes.
  3. Check the link report before circulating: the memo lists any reference that no longer resolves.

Sources

Every native step above was checked against these Microsoft pages on 16 November 2026.

Get the add-in before release

Early access testers get each add-in first, with a short list of what to try.