File Format & Compatibility

How to Update Excel Links When Duplicating a PowerPoint Presentation

Tauseeq Magsi Oct 10, 2026 869 views

Question details

The user needs to update the source paths of linked Excel workbooks within a duplicated PowerPoint presentation to point to a new Excel file without manually rebuilding each chart and table.

How to Update Excel Links When Duplicating a PowerPoint Presentation

Product: PowerPoint, Excel
Device & OS: not provided
Scenario: Creating multiple versions of a presentation by duplicating both the PowerPoint and Excel files, which requires redirecting the OLE links to the newly renamed spreadsheet.
Observed behavior: The duplicated PowerPoint presentation retains references to the original Excel workbook even after both files are renamed, requiring manual intervention to update the OLE links.

Before you start

Ensure both your duplicated PowerPoint presentation and the new Excel workbook are saved in the same local directory before updating the links. Always create a backup copy of your presentation in case you need to revert the changes.

Solution 1Recommended

Use the Edit Links to Files Command

This is the most straightforward method using PowerPoint's native link management feature to redirect OLE object links to a new Excel source.

PowerPoint provides a built-in tool that allows you to view and modify all external file references in your presentation. This tool is especially useful for updating data sources without having to recreate charts or tables.

Open the Document Info

Open the duplicated PowerPoint presentation. Click on the 'File' tab in the top-left corner, and then select 'Info'.

Access Link Settings

Look at the bottom right corner of the Info pane and click on 'Edit Links to Files'. Note that this option will only be visible if your presentation currently contains active linked objects.

Change the Source File

In the Links dialog box, select the link(s) pointing to the old Excel file. Click the 'Change Source' button, browse your computer to find the newly duplicated Excel workbook, and select it.

Update and Verify

Click 'Update Now' to refresh the data from the new spreadsheet, then close the dialog box. Check your slides to verify that the charts and embedded objects reflect the new data.

Pro Tip: If you hold down the Shift or Ctrl key while selecting links in the dialog box, you can change the source for multiple links simultaneously.

Solution 2

Use a VBA Routine to Automate Link Replacement

Ideal for large presentations with numerous links, a VBA macro can automatically search and replace old Excel paths with the new ones.

WPS Presentation Alternative

Easily Manage Linked Data with WPS Presentation

WPS Office provides seamless integration between spreadsheets and presentations. You can easily link Excel data, update sources, and manage file references efficiently using its intuitive interface.

1. Open Your Presentation: Launch WPS Presentation and open your duplicated .pptx file.
2. Access Link Settings: Click the 'Menu' button in the top left corner, navigate to 'Document Information', and select 'Edit Links'.
3. Update the Source: Select the data link you wish to update, click 'Change Source', browse for your new spreadsheet file, and confirm.

100% compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formatsIntuitive built-in interface for managing OLE links and external data sourcesLightweight design ensures smooth performance even with heavy dataFree to use across multiple operating systems, including Windows and macOS

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't renaming the Excel file automatically update the PowerPoint links?

PowerPoint stores the absolute file path and exact name of the linked Excel workbook. Renaming the Excel file breaks this path, causing PowerPoint to keep looking for the original file name.

Where is the 'Edit Links to Files' option located?

In most versions of Office, go to File > Info and scroll down to the bottom right of the Info pane. The 'Edit Links to Files' option only appears if the presentation contains active linked objects.

Will updating the link source change my chart formatting?

No, changing the source file only updates the data values and reference paths. The visual formatting applied to the chart or table in your presentation will remain exactly as you designed it.

How can I prevent broken links when sharing presentations?

To prevent broken links when sharing, place both the PowerPoint and Excel files in the same folder before linking them. Zip the entire folder when sending it to others so the relative path connections are maintained.

Document & File Issues