How to Fix PowerPoint Linked Worksheet Not Updating

Linking an Excel spreadsheet table or dynamic chart directly into Microsoft PowerPoint is an efficient way to ensure your presentation decks reflect current data. However, opening your slide deck only to discover that linked figures remain frozen on old numbers, display broken object placeholders, or refuse to refresh when source files change disrupts corporate reporting.

Object Linking and Embedding (OLE) relies on strict file system path tracking and security clearance. When links fail to refresh, the cause is typically broken relative file paths after moving or emailing files, Trust Centre security restrictions blocking external links, or link settings being switched to Manual. Follow these steps to restore real-time data synchronization.

Verify and Re-establish Broken File Path Links

If the source Excel workbook was renamed, moved to another folder, or if the presentation was shared via email, PowerPoint loses track of the original absolute file directory.

  1. Open your presentation in PowerPoint.
  2. Click the File tab in the ribbon to enter the backstage view.
  3. Select Info on the left-hand navigation panel.
  4. Look at the lower-right corner of the window for the link labelled Edit Links to Files. (Note: If this option is not visible, the presentation contains pasted static objects rather than active OLE links).
  5. In the Links dialogue, review the list of source files. Stale or missing files are highlighted.
  6. Select the broken link and click Change Source.
  7. Navigate to the current location of your Excel spreadsheet, select the file, and click Open.
  8. Click Update Now to immediately pull the newest figures into your presentation slides.

Switch Link Update Method from Manual to Automatic

PowerPoint provides options to control whether linked objects refresh automatically upon opening or wait for manual commands.

  • In the Edit Links to Files dialogue box (File > Info > Edit Links to Files), select the linked Excel object.
  • Inspect the Update radio buttons at the bottom of the dialogue.
  • If Manual is selected, switch the selection to Automatic.
  • Click Close, save the presentation (Ctrl + S), and test editing a cell in Excel to confirm that PowerPoint reflects the alteration instantaneously.

Configure Trust Centre External Content Security

Modern Microsoft 365 security updates apply strict sandboxing to linked workbook macros and external data connections to protect against malicious payloads.

  1. In PowerPoint, click File > Options.
  2. Select Trust Centre in the left sidebar, then click the Trust Centre Settings button.
  3. Navigate to External Content.
  4. Under Security settings for Workbook Links, choose Prompt user about linked data or Enable all Linked Data (not recommended for untrusted files).
  5. Next, navigate to Trusted Locations, click Add new location, and add the folder path where your Excel and PowerPoint files are stored.
  6. Click OK on all open windows and restart PowerPoint.

Account for OneDrive and SharePoint Web URL Path Formats

When source Excel files are stored inside cloud sync folders (such as OneDrive or SharePoint), Office frequently rewrites local drive paths into web HTTPS URLs (e.g. https://company.sharepoint.com/...), which breaks classic desktop OLE communication.

  • Open the OneDrive desktop sync client settings from the Windows taskbar.
  • In OneDrive settings, switch to the Office (or Sync and backup) tab.
  • Ensure that “Use Office applications to sync Office files that I open” is properly configured.
  • If links fail across multiple workstations, ensure colleagues map identical synchronized root paths or paste charts using modern Office Add-ins instead of legacy OLE embeddings.

Manually Force Object Updates via Context Menu

If you need to deliver an urgent presentation and cannot troubleshoot deep network paths, you can force PowerPoint to redraw the linked table immediately.

  1. On your slide, right-click the linked Excel table or chart object.
  2. Select Linked Worksheet Object (or Linked Chart) from the context menu.
  3. Click Update Link.
  4. PowerPoint will query the local memory cache or disk file and refresh all values on screen instantly.

Get the best tech tips delivered straight to your inbox.

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