'%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 Break All Excel Links in a PowerPoint Presentation
Question details
The user needs a method to quickly break all links to external Excel charts within a PowerPoint presentation so the data does not update automatically from the source workbooks.
- Product
- PowerPoint
- Device & OS
- not provided
- Scenario
- Preparing a presentation containing multiple linked Excel charts for distribution and wanting to ensure the charts remain static.
- Observed behavior
- Linked Excel charts may automatically update from their source workbooks if the file path matches or if the recipient has access to the linked OneDrive or SharePoint file.
Before breaking links, it is highly recommended to save a backup copy of your presentation. Once links to external Excel files are broken, the charts are converted to standard shapes or static objects, and you cannot automatically restore the connection to the original data.
Use the Edit Links to Files Dialog
Use the built-in link management tool to view, select, and break multiple external Excel links simultaneously without checking each slide manually.
Excel charts copied into a presentation are often OLE links containing an absolute path to the source workbook. Breaking these links ensures the presentation data remains unchanged.
Click on the 'File' tab in the top-left corner of the presentation ribbon, then navigate to the 'Info' section.
Look for the 'Edit Links to Files' option in the bottom right area of the Info screen. Note that this option will only appear if the presentation actually contains external links.
In the Links dialog box, hold down the 'Shift' or 'Ctrl' key on your keyboard and click to select all the Excel links you want to break.
Click the 'Break Link' button. Once the links are removed, click 'Close' to return to your presentation and save the file.
Manage Linked Excel Data Seamlessly in WPS Office
WPS Presentation provides intuitive link management features, allowing you to easily embed, link, or safely break connections to external spreadsheets. It offers robust compatibility with Microsoft Office formats, ensuring your charts display perfectly whether they remain dynamic or are converted to static graphics.
- 1. Open your presentation: Launch WPS Presentation and open the file containing the linked Excel charts.
- 2. Access Link Management: Click on the 'Menu' button at the top left, go to 'Document Information', and select 'Edit Links' (this option appears when external links are present).
- 3. Select the targets: In the dialog box, highlight the external Excel links you wish to sever.
- 4. Break and Save: Click 'Break Link' to convert the dynamic charts into static visuals, then save your document.
Frequently Asked Questions
Why does the 'Edit Links to Files' option not appear in my presentation?
The 'Edit Links to Files' option only appears when the software detects external OLE links in your slides. If your charts were pasted as plain pictures or fully embedded as self-contained workbooks rather than linked to an external file, this option will remain hidden.
Can I undo a broken link in my presentation?
If you have just broken the link and have not yet closed the document, you can usually press Ctrl+Z to undo the action. However, once you save and close the presentation, broken links cannot be restored automatically; you would need to recreate the link by copying and pasting the chart again.
Will charts still update if recipients don't have the source Excel file?
Generally, no. Excel links use absolute paths to the source workbook. If the recipient does not have the exact same directory structure on their local device, or lacks permission to access the shared OneDrive/SharePoint folder, the links will simply fail to update and the last saved data will be displayed.
