Chart & Visualization Issues

How to Change Multiple PowerPoint Chart Links at Once

Muhammad Talha Sep 28, 2026 869 views

Question details

The user needs a method to simultaneously update multiple PowerPoint chart links that point to an Excel workbook.

How to Change Multiple PowerPoint Chart Links at Once

Product: PowerPoint
Device & OS: not provided
Scenario: Monthly PowerPoint reports use charts linked to Excel pivot tables refreshed via Power Query. All chart links need to be redirected from a template workbook to a newly generated Excel workbook stored in OneDrive.
Observed behavior: By default, users often have to update chart link sources individually, which is highly inefficient for presentations with many linked charts.

Before you start

Ensure both your PowerPoint presentation and the destination Excel workbook are locally synced via your OneDrive client to prevent cloud URL resolution errors when updating the file paths.

Solution 1Recommended

Use a VBA Macro to Update All Chart Links

Because PowerPoint does not natively offer a robust bulk-update button for complex chart link paths, running a VBA (Visual Basic for Applications) script is the most reliable way to update multiple sources instantly.

A custom VBA script can loop through every slide and shape in your presentation. When it identifies a linked OLE object (like your Excel charts), it modifies the 'SourceFullName' property to point directly to your new OneDrive Excel workbook path.

Open the VBA Editor

Press Alt + F11 on your keyboard while your PowerPoint presentation is open to launch the Microsoft Visual Basic for Applications window.

Insert a New Module

In the top menu, click 'Insert' and select 'Module'. This will open a blank text window where you can write or paste your code.

Add the Update Script

Paste a standard chart link update script (which iterates through ActivePresentation.Slides and Shapes). Ensure you replace the old file path string with your new Excel workbook's local OneDrive path in the code.

Run the Macro

Press F5 or click the 'Run' button in the toolbar. The script will execute, automatically redirecting all matched chart links to the new destination file.

Use a VBA Macro to Update All Chart Links

Need Help with VBA Code?: If you do not know how to write the specific VBA script, you can find standard link-updating templates on Stack Overflow by searching the 'vba' and 'powerpoint' tags, or consult Microsoft's official VBA documentation.

Solution 2

Update Links Using the Edit Links to Files Feature

If you want to avoid using code and VBA, you can attempt to select and update multiple links using PowerPoint's built-in file information menu.

Free Microsoft Office alternative

Try WPS Office for Seamless Presentation and Data Management

Struggling with complicated VBA macros just to update chart links in PowerPoint? WPS Office provides a lightweight, highly compatible alternative suite that makes managing presentations and linked spreadsheet data straightforward and efficient without the hefty subscription fees.

Fully compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formats.Easily manage chart data and linked presentation objects with an intuitive interface.Lightweight application size ensuring blazing-fast performance even on older devices.Completely free to use with all essential presentation and spreadsheet tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Edit Links to Files' option completely missing in my PowerPoint?

The 'Edit Links to Files' option only appears in the File > Info pane if the presentation actively contains linked objects. If you copy-pasted an Excel chart as an embedded workbook or a static picture, there is no external link to edit, so the option remains hidden.

Can I update PowerPoint chart links to an Excel file stored solely online in OneDrive?

While it is possible, using direct HTTPS web URLs for OLE chart links can sometimes cause refresh errors or authentication loops in PowerPoint. It is highly recommended to sync your OneDrive locally to your PC and use the local file path (e.g., C:\Users\Name\OneDrive\File.xlsx) when updating the links.

Will updating a chart link automatically refresh the numbers on the slide?

Not always. Changing the source link successfully points the chart to the new file, but you may still need to click 'Update Values' or manually refresh the data within the presentation to see the latest figures pulled from the new workbook.

Excel & Data Problems