How to Fix PowerPoint Linked Excel Chart Not Updating

Embedding a dynamic Excel chart into a Microsoft PowerPoint presentation allows your slide decks to automatically reflect the latest quarterly revenue, inventory, or operational metrics. However, presenters frequently discover that updating data in the source spreadsheet has zero effect on the slide chart, or clicking “Update Data” throws an error stating “The linked file is unavailable”. In Microsoft Office, linked charts rely on Object Linking and Embedding (OLE) path pointers. When files are moved, renamed, saved to cloud folders, or blocked by security policies, the OLE link severs.

Manually Update Links via PowerPoint File Options

If PowerPoint does not automatically poll linked spreadsheet containers upon launch, you can trigger a manual link update and inspect link health.

  1. Open your presentation in Microsoft PowerPoint.
  2. Click on the File tab in the top-left corner.
  3. Select Info from the left sidebar.
  4. Look at the bottom-right corner of the Info pane under Related Documents.
  5. Click the link titled Edit Links to Files. (Note: If this option is greyed out, the chart was pasted as a static image or embedded workbook rather than a live link).
  6. In the Links dialogue box, select your linked Excel worksheet from the list.
  7. Click the Update Now button to force PowerPoint to re-read the Excel cell range.
  8. Set the update option at the bottom to Automatic to ensure future edits populate on slide launch.

Relink Broken Excel File Paths via Change Source

Moving your PowerPoint presentation or source workbook from a local drive to OneDrive, SharePoint, or a different shared folder invalidates hardcoded absolute file paths.

  1. In the Links to Files dialogue (via File > Info), check the Item and Location columns.
  2. If the path points to an old folder location or obsolete local drive letter, highlight the broken link.
  3. Click the Change Source button on the right side of the window.
  4. Use the file picker to navigate to the current location of your Excel workbook.
  5. Select the workbook and click Open.
  6. PowerPoint will rebind the OLE handle to the new path and immediately update the chart graphics.
  7. Click Close, then save your presentation.

Paste Charts with Live Linking Properly

A frequent user oversight is copying a chart and pasting it using standard Ctrl + V, which embeds a static snapshot rather than establishing a live OLE link.

  1. Open your source workbook in Microsoft Excel and select the chart.
  2. Press Ctrl + C to copy the chart.
  3. Switch to Microsoft PowerPoint and navigate to your target slide.
  4. On the Home ribbon tab, click the downward arrow beneath the Paste button.
  5. Under the Paste Options group, select either:
    • Use Destination Theme & Link Data (L)
    • Keep Source Formatting & Link Data (K)
  6. Ensure you choose an icon featuring the small chain-link emblem. This ensures PowerPoint maintains active OLE synchronization.

Enable External Content Updates in Trust Center

Security policies in Microsoft 365 can automatically block external data connections to protect against malicious workbook links.

  1. In PowerPoint, click File > Options.
  2. Select Trust Center and click Trust Center Settings.
  3. Click on External Content in the left pane.
  4. Under Security settings for Workbook Links, select Prompt user about linked data or Enable automatic update for all Workbook Links (not recommended for untrusted files).
  5. Click OK twice to confirm.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.