To insert an Excel link into Word, either make a clickable link to the workbook or copy a cell range in Excel and use Word’s Paste Special > Paste link to insert linked data. The first option opens the workbook; the second displays spreadsheet content in the document and can update when the source workbook changes. Save both files before linking, and use the desktop versions of Excel and Word for the linked-range method.
What You’ll Need
- A Microsoft 365 account with Excel and Word desktop apps on Windows. Menu labels can differ slightly on Mac; Word for the web does not offer the same full options for creating linked Excel objects.
- An Excel workbook saved in a stable location, such as a work folder or a shared location that your readers can access. Save it before copying a range.
- A Word document saved in the location where you plan to keep it. Keeping the workbook and document together in one folder can make links easier to maintain if you move or share them.
- For a clickable link, the words or image in Word that readers will click. For linked spreadsheet content, the cells you want to display.
Step-by-Step
Option 1: Add a clickable link to the Excel workbook
- Save the workbook first. In Excel, select File > Save As if you need to choose a location or file name. Note where the file is stored. A link to a file on your computer may not work for someone who cannot access that location.
- Choose the link text in Word. Open the document and type a descriptive label such as “Open the quarterly sales workbook.” Select the words you want people to click. You can also select an existing phrase instead of adding new text.
- Open the link dialog. In Word for Windows, press Ctrl+K, or select Insert > Link. In the link dialog, choose Existing File or Web Page if that choice is shown. On Mac, select the text and use Insert > Link; the dialog wording and layout can vary by Word version.
- Choose the workbook. Browse to the saved Excel file and select it. If the dialog includes a Text to display field, check that it contains the label you want readers to see. Select OK or Insert to add the link.
- Check that the link works. Save the Word document. In many Word configurations, Ctrl+click the linked text on Windows to open the file; on Mac, use Command-click. If Word prompts you about opening a file, confirm only if you trust the file and its location. You can also right-click the link and choose Edit Hyperlink to check the destination.
This method links to the workbook as a file. It does not show a live preview of cells in the document, and changing a value in Excel will not change the link text. Use the next method if the reader needs to see spreadsheet data in Word.
Option 2: Insert a linked range of Excel cells
- Prepare the range in Excel. Open the workbook in Excel for Microsoft 365 on Windows. Adjust column widths, number formats, borders, and headings so the range is readable. Select the cells you want to show, including any column headings that belong in the document, then press Ctrl+C.
- Place the cursor in Word. Open the Word document and click where the spreadsheet content should appear. Leave enough room on the page for the range; a wide worksheet object may extend beyond the margins.
- Open Paste Special. In Word, select Home > Paste arrow > Paste Special. The Paste arrow is usually beneath or beside the main Paste button. You can also try the keyboard shortcut Ctrl+Alt+V on Windows to open the Paste Special dialog.
- Select a linked format. In the dialog, choose Paste link, then select Microsoft Excel Worksheet Object from the list if it is available. Choose OK. The range appears in Word as a linked Excel object rather than an independent copy of the cell contents.
- Save both files and check the result. Save the Word document and the Excel workbook. To test the connection, change a clearly visible cell in Excel, save the workbook, return to Word, and check whether the linked object updates. Depending on Word’s update behavior, you may need to right-click the object and select Update Link.
- Adjust its size carefully. Click the object and drag a corner handle to resize it proportionally. Avoid dragging a side handle if you do not want to distort the display. Double-clicking the object may open its source workbook or activate Excel editing, depending on your setup.
The linked object displays data from the selected range, but it is not the same as a regular Word table. You may not be able to edit individual cells as normal Word text. Edit the source cells in Excel, save the workbook, and update the link in Word when needed. The exact visual result depends on the selected range and the paste format available in your Office version.
Mac and web app notes
On Mac, start by copying the Excel range and look for a Paste Special or Paste and Match Formatting option in Word. The dialog and available linked formats can vary by Office build. If you see Paste link and a Microsoft Excel worksheet option, select them to create a linked object. If those options are absent, use the desktop app’s available link format or add a clickable hyperlink to the workbook instead. Word for the web can work with ordinary hyperlinks, but use desktop Word to create or manage a linked Excel object. Recipients may also need desktop Office to interact with that object fully.
Common Mistakes
- Choosing an ordinary paste instead of Paste link. A standard paste creates a snapshot or copied content, not a link that follows the Excel source. In Word’s Paste Special dialog, explicitly choose Paste link.
- Confusing a workbook hyperlink with linked cell data. A clickable file link opens Excel; it does not display a cell range. If the data needs to appear on the page, copy the range and insert it as a linked object.
- Moving or renaming the source workbook. Word may look for the file at its original path. If you relocate or rename the workbook after creating a link, the connection can break. Keep the files together and avoid changing their names or locations.
- Assuming every reader has access to the file. A link to a local path such as a personal Documents folder works only for people with access to that path. For a team, store files in an agreed shared location, such as a SharePoint or OneDrive folder, and confirm readers have permission.
- Expecting automatic updates without saving the source. Word cannot display changes that have not been saved to the Excel workbook. Save Excel first, then update or reopen the Word document if the displayed range remains unchanged.
- Making the linked range too large. A large selection can be difficult to read, slow to refresh, or run past the page margins. Include only the cells readers need, and check the page in Print Layout before sharing.
Tips
- Use clear link text. “Open the project budget” tells readers what a hyperlink does more clearly than “click here.” If the file is important, include its date or version in nearby text.
- Keep related files in one folder. For a document and workbook you distribute together, store them side by side and move the folder as a unit. This reduces the chance that a local file link will point to an outdated location, though it is still wise to test links after moving files.
- Decide whether readers need live data or a fixed record. A linked range can reflect later workbook changes, which is useful for recurring reports. If the Word file must preserve exactly what was approved on a particular date, a static copy may be more appropriate; it will not refresh from Excel.
- Test from a recipient’s perspective. Close the files, reopen the Word document, and follow the link or check the displayed range. For shared files, ask a colleague with the intended permissions to verify access before sending the document widely.
- Make the spreadsheet section readable in Word. Consider landscape orientation or a separate page for a wide range. Use Word’s Layout > Orientation controls if the page needs to be landscape, and check that the object remains within the printable area.
- Keep an editable source copy. A linked object is dependent on its Excel workbook. Store the source in a known location and avoid deleting it after inserting the link, even if the linked range looks complete in Word.
Troubleshooting
The link does nothing or opens the wrong file. Right-click the linked text and choose Edit Hyperlink to inspect the destination. Browse to the correct workbook and confirm the change. If you are using a shared file, check that the address points to the shared copy rather than an old local copy.
Word says it cannot find or update the source. The workbook may have been moved, renamed, or become unavailable. Restore it to its original location if possible, or recreate the link from the current workbook. If you have a linked object, right-click it and look for Update Link. If the source file is on a network or cloud service, confirm that you are signed in and connected, then reopen the document.
The range does not show recent Excel changes. Save the workbook in Excel first. Return to Word, right-click the linked object, and select Update Link if the command is offered. If it still looks stale, close and reopen Word after confirming the source file is accessible. Check that you edited the same workbook the link refers to, not a duplicate with a similar name.
Paste Special has no Paste link option. Confirm that you copied a cell range from the Excel desktop app, rather than a screenshot or content copied from another program. Try again in desktop Word with both files open. Office versions and Mac builds can offer different formats; if the linked-object choice is unavailable, add a hyperlink to the workbook or use a non-linked paste and clearly treat it as a snapshot.
The object is clipped, blurry, or too small. Resize it with a corner handle and check the page in Print Layout. If it is too wide, reduce the number of columns, use a landscape page, or split the range into smaller sections. A worksheet object can appear less sharp when enlarged substantially, so prepare the range at a suitable size in Excel before copying it.
A security prompt appears when opening or updating a link. Word may warn that linked content comes from an external file. Verify the source and its location before allowing it to open or update. Do not enable a link from an unexpected document or a source you do not trust.
Frequently Asked Questions
Will a linked Excel range update automatically in Word?
It can update from the source workbook, but timing depends on the link and Office settings. Save changes in Excel, then check the Word object and use Update Link if necessary. A regular hyperlink to the workbook does not update spreadsheet data inside Word.
Can I link only one cell instead of a whole table?
Yes. Select the single cell in Excel, copy it, and use Word’s Paste Special > Paste link option if the linked Excel format is available. The cell will appear as a linked object, so it may not behave like ordinary text in a Word paragraph.
Can I edit linked Excel cells directly in Word?
Not as if they were normal Word table cells. To change the underlying values, edit the source workbook in Excel and save it. Depending on the object and Office version, double-clicking the object may open or activate Excel for editing.
Can I use a hyperlink if the workbook is stored online?
Yes. Insert a link to the workbook’s shared web address using Insert > Link, and make sure the intended readers have permission to open it. A link to a synced local folder may not work for other people unless they have the same path and access.
What is the difference between Paste link and embedding?
A linked object refers to a separate Excel workbook, so the source file must remain available and changes can be refreshed. An embedded object stores a copy of spreadsheet content in the Word file and does not rely on the original workbook in the same way. Embedding can increase the document size and does not keep the content synchronized with Excel.
Can I create a linked Excel object in Word for the web?
Word for the web supports ordinary hyperlinks, but it does not provide the full desktop Paste Special workflow for creating linked Excel objects. Use Word for Microsoft 365 on Windows or Mac when you need to insert a linked spreadsheet range.
Related
- How to Indent in the Same Excel Cell
- How to Indent in an Excel Cell: Steps, Tips and Fixes
- How to Indent in Excel: Shortcuts, Cells, and Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Multiple Text to Columns in Excel: Methods That WorkIn Excel for Microsoft 365 on Windows, Text to Columns is best treated as a one-source-column tool: select…
- Power Query to Compare Two Excel Sheets Step by StepTo compare two Excel sheets with Power Query in Microsoft 365 for Windows, turn each data range into…
- How to Clear Cache Data in OutlookTo clear cache data in Outlook, first identify which Outlook version you use: in classic Outlook for Windows,…
- Import Multiple CSV Files into Excel: Methods and TipsYes. In Excel for Microsoft 365 on Windows, you can import multiple CSV files and either combine their…
- Remove All Formatting in Word Without Losing TextTo remove formatting from a Word document, save a copy, press Ctrl+A on Windows (Command+A on Mac), then…
- Excel Text Updates Automatically? What Actually ChangesExcel does not automatically change ordinary text you typed into a cell. Text updates automatically when it is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.