Link Excel to Word: Keep Tables and Charts Updated

Charts & pivot tables · Updated November 19, 2026

To link Excel data to Word, copy the cells or chart in Excel, then in Word for Microsoft 365 on Windows choose Home > Paste > Paste Special, select Paste link, choose a suitable format such as Microsoft Excel Worksheet Object, and select OK. The Word content can then reflect changes in the source workbook, although it may need to be updated and the Excel file must remain accessible.

What linking Excel to Word means

A linked item in Word displays content that comes from a separate Excel workbook. Word stores a connection to the source rather than treating the pasted result as an entirely independent copy. When the workbook changes, Word can retrieve the newer content through that connection. Depending on the format you choose, the result may look like a Word table or like an Excel object that can be opened for editing.

Linking is useful when figures or tables in a report need to match a workbook that continues to change. For example, a monthly sales report might show a range from a workbook maintained by a finance team. Updating the workbook and refreshing the link can bring the latest values into the report without manually copying the range again.

A link is not the same as live coauthoring. Changes do not necessarily appear instantly as someone edits Excel, and Word still depends on being able to locate and access the source file. It is best to think of a linked item as a document connection that can be refreshed, not a guaranteed real-time feed.

Link Excel cells or a table to Word

Use the desktop versions of Excel and Word for the most reliable linking options. Save the workbook before copying, and decide which cells Word should display. Avoid selecting entire worksheets unless the report genuinely needs them; a defined range is easier to read and manage.

  1. In Excel, select the cells you want to appear in Word and press Ctrl+C.
  2. In Word, place the insertion point where the linked content should go.
  3. Choose Home > Paste > Paste Special. You can also press Ctrl+Alt+V in Word for Windows to open the Paste Special dialog.
  4. Select Paste link, then select a format from the available list. Microsoft Excel Worksheet Object is a common choice when you want the range linked as an Excel object. If available, Formatted Text (RTF) can create a linked table that fits more naturally into Word’s page layout.
  5. Select OK, then check that the result is readable and that the link points to the intended workbook.

The formats shown in Paste Special depend on what you copied and which Office applications and versions are installed. If the exact option is missing, copy the range again and reopen the dialog. You can also try Word’s paste options after pasting, but verify that the choice explicitly links the data; a normal paste can look similar while remaining static.

For a linked Excel object, double-clicking the item in Word may open its Excel editing interface. A linked table pasted as formatted text behaves more like a Word table for layout, but it is still connected to the source. The editing experience differs by format, so choose based on whether appearance in Word or access to Excel-style editing matters more.

Link an Excel chart to Word

Charts are often easier to maintain as linked objects than as screenshots. In Excel, select the chart itself by clicking its outer border, then copy it. In Word, use Home > Paste > Paste Special, select Paste link, and choose Microsoft Excel Chart Object if it appears. Select OK and resize the chart using its corner handles to preserve its proportions.

A linked chart can reflect changes to its source data and, depending on the chart and link format, changes to the chart itself. A screenshot or picture, by contrast, cannot refresh its plotted values. Check titles, axis labels, and legends after updating: revised data can make a chart more crowded or change the scale even when the link is working correctly.

If you prefer a chart that behaves like a regular image and does not change when the workbook changes, use a picture paste option instead. That is a deliberate static copy, not a linked chart. For a report that will be distributed as a final record, a fixed image may be more predictable; for a working report, a link is usually more convenient.

Choose between linking, embedding, and a static copy

These three approaches solve different problems, and the pasted result can look alike at first. Consider who will use the document, whether the source data will change, and whether recipients will have access to the workbook.

  • Link: Word refers to a separate workbook. It can be refreshed when the source changes, but the link can fail if the workbook is moved, renamed, unavailable, or inaccessible to the reader.
  • Embed: The workbook data is stored inside the Word document as an object. It is more self-contained than a link, but it can increase document size and does not automatically stay synchronized with the original workbook.
  • Static paste: Word keeps a snapshot of the copied cells or chart. It is simple to share and will not change unexpectedly, but updates must be copied in again manually.

Choose a link when a maintained source workbook is available to the people and systems that need to update the document. Choose an embedded object when recipients need the workbook content but should not depend on a separate file. Choose a static table or image when the document is final, when external links are undesirable, or when reliability matters more than automatic refreshes.

Update linked content and control prompts

Linked content may update when Word opens the document, when you accept an update prompt, or when you request an update manually. The exact behavior can depend on Word’s settings, the link type, and whether the source is reachable. Do not assume that opening a document always retrieves the newest workbook values.

To request an update, right-click the linked item in Word and look for an option such as Update Link. Some versions also expose link-management commands under File > Info > Edit Links to Files when the document contains links. The command may not appear in every Word configuration or for every kind of pasted content. If available, the link-management dialog can show the source and provide options to update or change it.

Updating can change the values or appearance in the report, so review the result before sending or printing the document. If a recipient needs a fixed version, save a separate final copy and convert or replace the linked content with static content only after checking the result. Keep an editable working copy if you may need the live links again.

File locations, sharing, and link reliability

The Word document needs to find the workbook to update a link. If either file is moved, renamed, or stored somewhere the current user cannot access, Word may report that it cannot update the linked information or may show an older result. A link that works on the author’s computer is not automatically usable by a colleague.

For a team document, store the workbook in a stable shared location and give intended readers the required access to both files. Share the workbook as well as the Word document when recipients need to refresh linked content. Test the files from the location and account the recipients will use, particularly if files are downloaded from email or moved out of a shared folder.

Cloud storage does not remove every dependency. Access permissions, synchronization status, organizational policies, and how the files are opened can affect whether Office can reach a source. If people will circulate the Word document independently, a static copy or an embedded object may be safer than relying on a link to a workbook they may not be able to open.

Common problems and practical fixes

  • Paste Special has no Paste link option: Confirm that you copied the Excel cells or chart, not a screenshot or unrelated object, and try again in the desktop applications. Available formats vary. Excel for the web and Word for the web do not provide the same full desktop linking workflow.
  • The document does not show new values: Use the linked item’s update command if available, confirm the source workbook was saved, and check that Word is pointing to the current file rather than a different copy.
  • Word cannot find the workbook: Restore the file to an accessible location or use the available link-management command to select the correct source. If the link cannot be repaired, paste the content again from the correct workbook.
  • The table is too wide or changes the page layout: Use a linked formatted table if that format is offered, reduce the number of columns, or adjust page orientation and margins. A linked Excel object may be easier to resize as one item but can be less convenient to edit as Word text.
  • The link prompt seems risky: Only update links from workbooks and locations you trust. An update can retrieve external content, so do not approve unexpected links in a document from an unknown source.

One common misconception is that seeing the latest-looking values proves a link exists. A pasted table can be a static snapshot, and a linked item can display old values until refreshed. Check the Paste Special choice when creating it and use the link-management options, where available, to confirm the source.

Using Word or Excel on Mac and the web

The steps above are for Microsoft 365 on Windows. Word for Mac and Excel for Mac have Paste Special and paste options, but dialog labels, keyboard shortcuts, and the available linked formats can differ by Office version. On Mac, copy with Command+C and inspect Word’s Edit or Home paste controls for Paste Special and Paste Link options; do not assume that every Windows format is available. If the link choice is absent, use the desktop Windows workflow or choose a static paste instead.

Excel for the web and Word for the web are useful for editing and viewing many documents, but they do not offer the same complete OLE-style linking and link-management controls as the Windows desktop apps. For creating or repairing a linked Excel object, open the files in desktop Excel and Word. A linked item may still have limitations when viewed or edited in a browser, so check the final document in the environment where it will be used.

Frequently Asked Questions

Can I link only selected Excel cells to Word?
Yes. Select the precise range in Excel before copying, then use Paste Special in Word and select Paste link. Word links the copied selection rather than requiring you to include the entire worksheet.

Will a linked Word table update automatically?
It can update when Word refreshes the link, but changes are not guaranteed to appear immediately. The source workbook must be available, and you may need to accept an update prompt or use an update command.

Can I edit linked Excel data from Word?
It depends on the paste format. An Excel Worksheet Object can often be opened for editing by double-clicking it, while a linked formatted table is more suited to Word’s layout. Changes should be made carefully because the source workbook and displayed result may be affected differently by the chosen format.

Why does Word say it cannot update the link?
The workbook may have been moved, renamed, deleted, or made inaccessible, or Word may be pointing to another copy. Restore access to the correct source or repair the source path through Word’s link-management options if they are available.

How do I stop a linked table from changing?
Make a static copy by pasting the content as a Word table or image, or use the available link-management command to break the link. Keep a separate working copy first: once content is made static, it no longer refreshes from Excel.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.