Edit a Linked Excel Chart in Word When the Source Workbook Is Missing
Question details
The user needs to edit Excel charts in a Word document when their linked source workbook is missing or points to an older document version.
- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A Word document contains charts linked to an external Excel workbook that is no longer available or no longer matches the current document.
- Observed behavior
- The charts remain in the document, but their data can no longer be edited through the unavailable or outdated workbook link.
Locate the original workbook or a current replacement, and confirm that it contains the worksheet and chart data you need. The File > Info > Edit Links to Files path below applies to desktop Word on Windows; commands may differ on other platforms.
Reconnect the Word chart to the correct Excel workbook
Use this method when the original workbook or a compatible replacement is available.
Open the document in desktop Word, then select File > Info > Edit Links to Files. This command appears when Word recognizes supported external file links in the document.
Select the link associated with the affected Excel chart, click Change Source, and browse to the correct workbook. Select the workbook and confirm the change.
In the Links dialog, select the corrected link and click Update Now. Check the chart’s values, series, and labels against the intended workbook before saving the Word document.
Right-click the chart in Word and choose Edit Data if available, or open the corrected source workbook directly in Excel. Make your changes, save the workbook, and update the link in Word.
Replace the broken linked chart with an embedded chart
Use this method when the source cannot be recovered or you want the chart’s editable data stored inside the Word document.
Work with Word Documents and Excel Data in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar interface and support for Word and Excel formats, making migration straightforward. Use WPS Writer and Spreadsheets to work with available documents and chart data; WPS does not recover a missing Excel workbook or repair Word’s external chart links.
Frequently Asked Questions
Can I edit the chart in Word without the original Excel workbook?
A linked chart normally depends on its external workbook for data editing. Right-click the chart and check whether Edit Data works, but do not assume the displayed chart contains recoverable data. If the source is unavailable and editing fails, use Insert > Chart to rebuild it from verified values.
Where is Edit Links to Files in Word?
In desktop Word on Windows, open File > Info and look for Edit Links to Files. It appears when the document contains recognized external file links. If it is absent, the object may be embedded, may be a picture, or may not expose a supported link.
Can I point the chart to a newer version of the workbook?
Yes. Select File > Info > Edit Links to Files, choose the chart link, and click Change Source. Select the newer workbook, then click Update Now. Verify that its worksheets, ranges, and chart content match what the link expects.
How do I keep a chart editable without an external workbook?
Create it in Word through Insert > Chart and enter its data in the accompanying data sheet. This embeds the supporting data in the document. You can later right-click the chart and choose Edit Data without locating a separate source workbook.
