'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Link a Word Table Cell to Excel and Keep It Updated
Question details
The user wants to establish a live connection between Word table cells and Excel cells so that data automatically updates across documents and workbooks.
- Product
- Microsoft Word and Excel
- Device & OS
- Mac
- Scenario
- Connecting and mirroring data across different documents and workbooks to avoid manual data entry when source information changes.
- Observed behavior
- Standard hyperlinks do not create live linked values, and users need the correct workflow to embed an automatically updating connection.
Ensure that both your Word document and Excel workbook are saved to your local drive or a supported cloud folder before attempting to link data.
Use Paste Special to Create a Live Link
Use the Paste Special feature rather than standard hyperlinks to embed a dynamic, updating link between your Word and Excel files.
A standard hyperlink only redirects you to another file; it does not display or update actual data. To create a live linked object, you must copy the exact data and use the Paste Special dialog to maintain the connection.
Depending on your version of Mac and Microsoft 365, some link types might be unsupported. Make sure you use modern file formats like .docx and .xlsx.
Open the source file (e.g., your Excel workbook). Highlight the specific cell or range you want to link, right-click, and select Copy.
Open the destination file (e.g., your Word document) and click exactly inside the table cell where you want the live data to appear.
Go to the top menu bar, click on Edit, and select Paste Special. Alternatively, you can click the dropdown arrow under the Paste button on the Home tab.
In the Paste Special dialog box, choose the 'Paste Link' option. Select the desired format (such as Unformatted Text or Microsoft Excel Worksheet Object) and click OK.
Link Data Easily with WPS Office
You can seamlessly link spreadsheet cells and document tables using WPS Office. It provides robust tools for cross-document data linking, fully compatible with Microsoft Office files.
- 1. Copy the data in WPS Spreadsheets: Highlight the cell or range in your spreadsheet, right-click, and choose Copy.
- 2. Open WPS Writer: Switch to your document in WPS Writer and place your cursor where the data should be inserted.
- 3. Use Paste Special: Click the arrow below the Paste icon on the Home tab, select Paste Special, check 'Paste Link', and click OK to finalize.
Frequently Asked Questions
Why is the 'Paste Link' option grayed out on Mac?
This usually happens if the documents have not been saved yet, or if they are saved in older formats like .doc or .xls. Save both files in the current .docx and .xlsx formats to enable linking.
Does a regular hyperlink update the cell value?
No. A hyperlink creates a clickable shortcut that opens the target file. It does not display or mirror the live data from the source cell. You must use 'Paste Link' to mirror data.
Will the link break if I move the files?
Yes. Live links rely on the specific file paths of the source and destination documents. If you rename or move the source file to a new folder, the link will break and must be manually updated in the document's link settings.
Can I link Word data to an Excel cell instead?
Yes. The process works in reverse. Copy the content from your Word table, open your Excel workbook, right-click the destination cell, and choose Paste Special > Paste Link.
