When you open a Word document that contains linked Excel tables, Copilot may behave differently than expected. The linked data might not appear immediately, or Copilot may refuse to generate content based on that data. This behavior is caused by a security feature that prevents automatic external data refresh in Word. This article explains why this happens, how to trigger the update manually, and what limitations you should be aware of.
Key Takeaways: Managing Copilot and Linked Excel Tables in Word
- Word > File > Info > Edit Links to Files: Use this menu to manually refresh linked Excel data before using Copilot.
- Word > File > Options > Trust Center > Trust Center Settings > External Content: Configure automatic link update settings here, but note that changes affect all documents.
- Copilot pane > References > Add data source: Copilot only reads data after the link is refreshed; stale links produce no output.
Why Copilot Stops Working With Linked Excel Tables
When you insert an Excel table into Word using the Paste Link option, Word stores a reference to the original Excel file. By default, Word does not update these links automatically when you open the document. This is a security measure to prevent malicious data from being pulled into your document without your knowledge. Copilot reads the visible content of the Word document. If the linked table is not refreshed, Copilot sees the last saved version of the data or, in some cases, a broken link placeholder. Copilot cannot generate responses based on data that is not present or is stale.
The core issue is that Copilot treats the Word document as a snapshot. It does not initiate external data connections on its own. You must refresh the linked Excel table before Copilot can use that data for tasks like summarization, question answering, or content generation. This behavior is consistent across all Microsoft 365 subscription tiers that include Copilot for Word.
How Linked Tables Are Stored
When you paste a linked Excel table using Home > Paste > Paste Special > Paste Link, Word creates an OLE link or a Dynamic Data Exchange link. The link includes the file path to the Excel workbook and the specific cell range. Word stores this link in the document metadata. Copilot does not have direct access to this metadata. It only reads the rendered content of the document. If the link is not updated, the rendered content is either old or missing.
Steps to Refresh Linked Excel Tables for Copilot
Follow these steps to ensure Copilot can read the latest Excel data from linked tables in Word.
- Open the Word document that contains linked Excel tables
Do not start using Copilot immediately. The document may show a security warning bar below the ribbon. If you see the bar, click Enable Editing to allow manual link management. - Go to File > Info
On the Info page, locate the section labeled Related Documents or Links. Click the Edit Links to Files button. If this button is not visible, click the arrow next to the button to expand the list. - Select the linked Excel table in the Links dialog
The Links dialog shows all external data sources linked to the document. Each entry shows the source file name, the item name such as Worksheet or Range, and the current update status. Click the link you want to refresh. - Click Update Now
Word attempts to open the source Excel file and pull the latest data. If the Excel file is on a network share or OneDrive, you may be prompted to enter credentials. After the update, the Status column shows OK. - Close the Links dialog and save the Word document
Press Ctrl+S or click File > Save. Saving the document commits the refreshed data into the Word file. Copilot can now read the current table content. - Open the Copilot pane in Word
Click the Copilot icon on the Home tab of the ribbon. The Copilot pane opens on the right side of the window. The document now contains the refreshed table data. - Ask Copilot a question about the table data
Type a prompt such as Summarize the data in the table. Copilot reads the document content and generates a response based on the refreshed table. If Copilot still returns no relevant output, repeat the refresh steps and ensure the table is visible in the document body.
Automating Link Updates on Open
You can configure Word to update linked tables automatically when you open a document. This setting applies to all documents you open, not just the current one.
- Go to File > Options > Trust Center
Click Trust Center Settings in the right pane. - Select External Content in the left navigation
Two settings appear: Enable automatic update for links and Enable automatic update for DDE links. - Check the box for Enable automatic update for links
This tells Word to refresh all linked content when the document opens. Click OK to close the Trust Center, then click OK to close Word Options. - Restart Word and reopen the document
Word now updates the linked Excel table automatically. Copilot can use the fresh data immediately after the document loads.
Be aware that enabling automatic updates may cause a delay when opening documents with many external links. It also increases the risk of loading unwanted data from untrusted sources. Use this setting only for documents from trusted locations.
Common Issues With Copilot and Linked Excel Tables
Copilot Returns Generic Output Instead of Table Data
If Copilot produces a response that does not mention the table or gives vague summaries, the link is likely stale. Open the Links dialog and verify the Status column. If it shows Error: Source not found, the Excel file may have been moved, renamed, or deleted. Click Change Source in the Links dialog to browse to the new location of the Excel file. After changing the source, click Update Now and save the document.
Copilot Does Not Open or Shows an Error
Copilot requires a stable internet connection and an active Microsoft 365 subscription with Copilot enabled. If Copilot does not open, check your subscription status in the Microsoft 365 admin center. Also verify that your document is saved to OneDrive or SharePoint Online. Copilot does not work with locally saved files unless they are synced to OneDrive.
Linked Table Appears as a Picture in Word
If you pasted the Excel table as a picture instead of using Paste Link, Copilot cannot read the data. Pictures are not treated as structured data. Delete the picture and reinsert the table using Home > Paste > Paste Special > Paste Link. Then refresh the link as described above.
Copilot With Linked Tables vs Copilot With Embedded Tables
| Item | Linked Excel Table | Embedded Excel Table |
|---|---|---|
| Data storage | Reference to external Excel file | Copy of Excel data stored inside Word |
| Update method | Manual via Links dialog or automatic via Trust Center | Double-click the table to edit in Excel |
| Copilot read behavior | Reads only after link refresh | Reads immediately on document open |
| File size impact | Minimal; Word file stays small | Larger Word file due to embedded data |
| Data freshness | Depends on refresh frequency | Static until manually updated |
| Security risk | Potential untrusted source if automatic update is on | No external source risk |
Embedded tables are simpler for Copilot usage because they do not require manual refresh. However, embedded tables increase the Word document size and do not reflect changes made in the original Excel file. Choose linked tables when you need the Word document to stay synchronized with a live Excel workbook. Choose embedded tables when you want Copilot to read the data immediately without extra steps.
Conclusion
Copilot in Word can work with linked Excel tables only after you refresh those links manually or configure automatic updates. Use the Links dialog under File > Info to update each link before asking Copilot to summarize or analyze the table data. For frequent use, enable automatic link updates in Trust Center settings. If Copilot still ignores the table, verify the link source and ensure the document is saved to a cloud location. This approach gives you control over data freshness while maintaining security.