You paste an Excel chart into a Word document and use Copilot to summarize or ask questions about the data. The chart appears, but the numbers in Copilot’s responses do not match the chart. This happens because Copilot reads the static chart image, not the live linked data, unless you configure Word to refresh the link before Copilot runs. Microsoft 365 does not automatically synchronize Excel source data with Copilot’s analysis engine. This article explains exactly when Copilot reads from the linked Excel workbook versus the pasted chart object, how to force a refresh, and what limits apply to chart-linked Copilot queries.
Key Takeaways: Copilot and Linked Excel Charts in Word
- Link refresh before Copilot query: Word must update the chart link from Excel before Copilot reads the data. Without a manual refresh, Copilot sees stale or cached values.
- Copilot reads embedded chart data, not the Excel file directly: Copilot analyzes the chart object’s underlying data table stored in Word, not the source workbook cells.
- Chart type affects Copilot accuracy: PivotCharts and charts with external data connections require additional steps to refresh before Copilot can use current values.
Why Copilot Shows Stale Data for Linked Excel Charts
When you insert an Excel chart into Word using the “Link & Keep Source Formatting” or “Link & Use Destination Theme” paste option, Word stores a copy of the chart and its underlying data table. The link only updates the chart image and the data table when you trigger a refresh in Word. Copilot does not open Excel or query the .xlsx file directly. Instead, it reads the chart’s data table that is embedded inside the Word document. If the source Excel file changes after the chart was pasted, the Word copy becomes stale until you refresh the link.
The refresh mechanism in Word uses the Edit Links to Files dialog. This dialog controls whether links update automatically when the document opens or only when you manually choose Update Now. By default, Word prompts you to update links on document open, but Copilot may run before you accept the prompt. If you click “No” or dismiss the prompt, Copilot uses the old data.
How Copilot Accesses the Chart Data Table
Copilot in Word does not read the rendered chart image. It extracts the underlying data series from the chart object’s internal cache. This cache is populated at the moment the chart is pasted or when the link is refreshed. The cache includes category labels, series names, and numeric values. Copilot uses this table to generate summaries, answer questions about trends, and compare values. The cache does not include formulas, named ranges, or PivotTable filters from the original Excel workbook.
Steps to Refresh Linked Chart Data Before Using Copilot
Follow these steps to ensure Copilot reads the most current data from an Excel-linked chart. Perform the refresh before you open the Copilot pane.
- Open the Word document containing the linked chart
If Word prompts you to update links, click Update Links. This refreshes all linked objects, including charts. If you skip this prompt, close the document, reopen it, and click Update Links. - Open the Edit Links to Files dialog
Go to File > Info > Edit Links to Files on the right side under Related Documents. If you do not see this option, the document contains no linked objects. - Select the chart link and click Update Now
In the dialog, select the row that shows the Excel chart link. Click Update Now. The Status column changes from “Manual” or “Automatic” to indicate the link is current. - Save the Word document
Press Ctrl+S or click File > Save. This writes the refreshed chart data table into the document so Copilot reads the updated cache. - Open the Copilot pane and ask your question
Click the Copilot icon in the ribbon or press Alt+I. Type a question such as “Summarize the chart data” or “What is the highest value in the second series?” Copilot now uses the refreshed data table.
Change Link Update Setting to Automatic
To reduce the chance of stale data, set the chart link to update automatically when the document opens.
- Open Edit Links to Files
Follow step 2 above. - Select the chart link
Click the link row to highlight it. - Change Update Method to Automatic
Under Update method for selected link, select Automatic. Click OK. - Save and reopen the document
The next time you open the file, Word updates the chart data automatically before Copilot runs.
If Copilot Still Returns Outdated Chart Data After Refresh
Even after refreshing the link, Copilot may return numbers that do not match the Excel source. These scenarios explain why and how to fix each one.
Copilot Reads Data from a Chart That Uses External Data Connections
If the Excel chart pulls data from an external database, Power Query, or another workbook, the link refresh in Word only updates the chart image and cache from Excel’s last saved state. Excel must refresh its own external data connections first. Open the source Excel workbook, go to Data > Queries & Connections > Refresh All, save the workbook, then refresh the link in Word.
Copilot Reads Data from a PivotChart
PivotCharts in Word do not expose the underlying PivotTable cache to Copilot. Copilot sees only the aggregated values that were present when the chart was pasted. To update, reopen the source Excel workbook, refresh the PivotTable, save, then refresh the link in Word. Copilot will then read the new aggregated data.
Copilot Returns Generic Output Instead of Chart-Specific Data
If Copilot says “I can’t access the chart data” or gives a general answer about chart types, the chart object may be corrupted or the data table may be missing. Delete the chart in Word, re-copy it from Excel using Link & Keep Source Formatting, save the document, refresh the link, and try Copilot again.
Copilot in Word: Linked Chart vs Embedded Chart vs Copilot Chart Analysis
| Item | Linked Chart | Embedded Chart | Copilot Chart Analysis |
|---|---|---|---|
| Data source | Excel workbook cache in Word | Static copy inside Word | Copilot reads the chart’s data table from Word |
| Requires Excel file | Yes, for refresh | No, Excel file not needed after paste | No, Copilot uses Word’s internal cache |
| Auto-update on open | Configurable: Automatic or Manual | Never updates | N/A, depends on link setting |
| Copilot sees live data | Only if link refreshed before query | Only data at time of paste | Only data in the chart cache at query time |
| Best for | Reports that need periodic data updates | Static reports, archival documents | Any chart where data must match Copilot analysis |
Copilot in Word does not refresh linked charts automatically. You must use the Edit Links to Files dialog to update the chart data table before asking Copilot to analyze the chart. For PivotCharts or charts with external data connections, refresh the source Excel workbook first. Set links to Automatic update to reduce manual steps. Always save the Word document after refreshing to commit the new data into the cache Copilot reads.