'%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 Unlink Excel Charts Pasted into Word
Question details
The user needs to disconnect an Excel chart that has been pasted into a Word document so that it no longer updates automatically when the source Excel file changes.
- Product
- Word
- Device & OS
- not provided
- Scenario
- Editing a Word document containing charts copied from an Excel workbook.
- Observed behavior
- The pasted charts remain linked to the original Excel workbook and update automatically whenever the source data changes.
Ensure you have finalized the data in your chart, as breaking the link will permanently convert the chart into a static object that will no longer sync with the original Excel file.
Break the Link Using the Edit Links Menu
Use the built-in Links manager in Word to sever the connection between your document and the original Excel workbook.
This method safely converts your linked chart into a static element, meaning any future changes made in the Excel file will not affect the Word document.
In your Word document, go to the 'Edit' menu (or File > Info in newer versions) and select 'Links' or 'Edit Links to Files'.
In the Links dialog box, locate and select the linked Excel chart or charts you want to disconnect from the source.
Click the 'Break Link' button. Confirm the action when prompted to stop the chart from updating from the source workbook.
Paste the Chart as a Picture
If you are pasting a new chart, you can paste it directly as an image to prevent linking from the start.
Easily Manage and Unlink Charts with WPS Office
WPS Office provides a highly compatible and lightweight suite where managing cross-document links between Writer (Word) and Spreadsheets (Excel) is seamless. You can easily break links to keep your document's data static and secure.
- 1. Open Document in WPS Writer: Launch WPS Office and open your text document containing the linked chart.
- 2. Access the Edit Menu: Click on the 'Menu' button at the top left, go to 'Edit', and select 'Links'.
- 3. Break the Link: Select the Excel chart link from the list and click 'Break Link' to instantly convert it to a static graphic.
Frequently Asked Questions
Can I reconnect an Excel chart after breaking the link in Word?
No, breaking the link is a permanent action. To re-establish a connection, you will need to delete the current chart in Word, copy the chart from Excel again, and paste it using the 'Keep Source Formatting & Link Data' option.
Why is the 'Edit Links' option grayed out in Word?
The 'Edit Links' option is only active if your document contains linked objects. If it is grayed out, the chart may have been pasted as a static picture or an embedded object rather than a linked OLE object.
How do I update the linked chart without opening the Excel file?
If the link is still active, you can right-click the chart in your Word document and select 'Update Link'. This will fetch the latest data from the source Excel file, provided the file hasn't been moved or renamed.
Does breaking the link change how the chart looks?
No, breaking the link preserves the current visual appearance of the chart in your Word document. However, it will no longer reflect any subsequent data or formatting changes made in the original Excel file.
