Updating financial projections, sales figures, or quarterly metrics in an Excel workbook only to discover that the embedded chart in your PowerPoint presentation continues to display obsolete figures creates severe reporting discrepancies. When you paste an Excel chart into PowerPoint using the “Link Data” option, PowerPoint creates an Object Linking and Embedding (OLE) pointer referencing the exact physical file path of the source spreadsheet. When the source workbook is moved, renamed, stored inside a OneDrive folder with changing local synchronization states, or blocked by Office Trust Center security sandboxes, automatic background data recalculations cease. Re-establishing broken OLE pointers and managing manual update links guarantees accurate data presentation.
Manually Update Chart Links via File Info in PowerPoint
PowerPoint provides a centralised links management console that displays link health and allows you to force an immediate data refresh.
- Launch your presentation in Microsoft PowerPoint.
- Click on the File tab located in the top-left corner of the ribbon.
- Select Info from the left navigation bar.
- Look at the bottom-right corner of the Info screen under the Related Documents section and click Edit Links to Files. (If this option is missing, no active linked objects exist; the chart was pasted as static vector graphics).
- In the Links dialogue box, select your linked Excel workbook from the list.
- Click the Update Now button to pull the latest cell ranges and data series into your slides.
Repair Broken Absolute File Paths in the Links Manager
Moving your presentation or spreadsheet to a different folder, flash drive, or cloud directory breaks absolute drive paths (such as C:\Users\...).
- In the Links dialogue box (accessed via File > Info > Edit Links to Files), highlight the problematic linked chart entry.
- Click the Change Source… button on the right.
- In the File Explorer window that appears, navigate to the current location of your Excel workbook, select the file, and click Open.
- Verify that the Update radio button at the bottom of the dialogue is set to Automatic rather than Manual.
- Click Close, return to your slide, right-click the chart boundary, and choose Refresh Data.
Configure External Content Security in Office Trust Center
Strict Microsoft 365 security policies frequently disable automatic link updating when files are opened from shared network folders or Internet locations.
- In PowerPoint, click File > Options.
- Select Trust Center in the left pane and click Trust Center Settings…
- Click on External Content in the left navigation pane.
- Under Security settings for Workbook Links, select Prompt user about linked data or Enable automatic update for all Workbook Links (not recommended).
- Click OK twice to save the settings. Save your presentation, close it, and reopen it, clicking Update Links when prompted by the yellow security notification bar.