PowerPoint Chart Refresh Stuck on ‘Updating Links’: Fix

When you open a PowerPoint presentation containing charts linked to an external Excel workbook, you may see a status bar message that reads “Updating Links” which never finishes. This leaves the chart data outdated and the presentation unresponsive until you force close it. The problem typically occurs because the link to the Excel source file has become broken, the source file is in a location that PowerPoint cannot access, or the chart data connection is corrupted. This article explains why the link update stalls and provides step-by-step fixes to restore normal chart refresh behavior.

Why the Chart Link Update Stalls Indefinitely

A chart linked to an Excel workbook contains a reference to the file path of the source workbook. When PowerPoint opens the presentation, it attempts to connect to that file and retrieve the latest data. The update process hangs when one of the following conditions is true:

• The source Excel file has been moved, renamed, or deleted since the link was created.
• The source file is stored on a network drive, OneDrive, or SharePoint location that requires authentication or has a slow connection.
• The link points to a file that is open in Excel with unsaved changes, causing a lock conflict.
• The chart data connection in PowerPoint is corrupted, often due to a partial save or a crash during a previous link update.

In all these cases, PowerPoint keeps retrying the connection without a timeout, which results in the “Updating Links” message persisting indefinitely. The presentation remains unresponsive until you manually interrupt the process or break the link.

Step-by-Step Fixes for a Stuck Chart Link Update

Try the fixes in the order listed. Each method addresses a different root cause. Start with the simplest solution and move to more advanced steps only if the problem persists.

Fix 1: Break the Link to Make the Chart Static

This is the fastest solution when you need the presentation to become responsive immediately. Breaking the link converts the chart data to static values that no longer update.

1. Open the presentation and wait 30 seconds
   If the “Updating Links” message appears, do not force close the file. Wait 30 seconds to see if the update completes on its own. If it does not, proceed.
2. Go to File > Info > Edit Links to Files
   Click File in the ribbon, then select Info from the backstage view. In the Info panel, click Edit Links to Files. This button appears only when the presentation contains external links.
3. Select the stuck link and click Break Link
   In the Links dialog, you will see one or more entries for the Excel source file. Select the entry that corresponds to the stuck chart. Click Break Link. A confirmation dialog appears. Click Yes to confirm.
4. Save the presentation
   Press Ctrl+S to save the file. The chart now contains static data and will no longer attempt to update. The “Updating Links” message will not appear the next time you open the file.

Fix 2: Change the Link Source to a Working File Path

If you want to preserve the ability to update the chart in the future, update the link to point to the correct location of the Excel source file.

1. Open the Excel source file first
   Locate the Excel workbook that contains the original chart data. Open it in Excel and ensure it is saved and closed properly. If the file has been moved, note its new path.
2. In PowerPoint, go to File > Info > Edit Links to Files
   Open the PowerPoint presentation and follow the same path as in Fix 1 to reach the Links dialog.
3. Click Change Source
   Select the link entry and click Change Source. Navigate to the correct Excel file and select it. Click Open.
4. Click Update Now and close the dialog
   Back in the Links dialog, click Update Now. The chart should refresh with the latest data. Click Close and save the presentation.

Fix 3: Disable Automatic Link Updates on Open

This fix prevents PowerPoint from automatically attempting to update all links when the file opens. Instead, you control when links update.

1. Go to File > Options > Advanced
   Click File, then Options. In the PowerPoint Options dialog, select Advanced from the left panel.
2. Scroll to the General section
   Scroll down until you see the General section near the bottom of the Advanced options list.
3. Check the box for Ask to update automatic links
   Check the box labeled Ask to update automatic links. Click OK to save the setting.
4. Restart PowerPoint and reopen the presentation
   Close and reopen the file. PowerPoint now shows a dialog asking whether you want to update links. Click No to open the presentation without updating. You can manually update links later using File > Info > Edit Links to Files > Update Now.

Fix 4: Repair the Source Excel File

If the source file itself is corrupted, the link update will stall. Repair the Excel file first.

1. Open Excel and go to File > Open
   Launch Excel. Click File, then Open. Navigate to the source workbook but do not double-click it.
2. Select the file and click the arrow next to Open
   Click once on the file to select it. Click the small arrow next to the Open button and choose Open and Repair from the dropdown menu.
3. Choose Repair in the dialog
   Excel displays a dialog with two options: Repair and Extract Data. Choose Repair. Wait for the repair process to finish.
4. Save the repaired file and try the link again
   Save the repaired workbook. Go back to PowerPoint and attempt to update the link using File > Info > Edit Links to Files > Update Now.

If the Chart Still Does Not Update After the Main Fixes

PowerPoint Shows “Cannot Update Links” Instead of “Updating Links”

If you see a dialog stating “Cannot update links” rather than a stuck status bar message, the link is broken but PowerPoint is not hanging. Follow Fix 2 to change the source to the correct file. If the source file no longer exists, use Fix 1 to break the link.

The Chart Data Is Correct but the Chart Object Shows an Error Icon

A red X or a placeholder icon on the chart indicates that the chart object itself is corrupted. Delete the chart from the slide. Insert a new chart using Insert > Chart and paste the data manually from the Excel source file. Do not create a new link; paste the values as static data.

Linked Charts in a Presentation Opened From Email or a Network Share

When you open a presentation directly from an email attachment or a network folder, PowerPoint may block external links for security reasons. Save the file to your local hard drive first. Then open the local copy and update the links. This resolves most link update issues related to protected view.

Item	Break Link (Fix 1)	Change Source (Fix 2)	Disable Auto Update (Fix 3)
Effect on chart	Converts to static data	Preserves live link to new source	Preserves live link but defers update
Time to apply	Under 1 minute	2 to 5 minutes	2 minutes
Requires source file	No	Yes	Yes
Future link updates	Not possible	Possible after changing source	Possible with manual trigger

Use Break Link when you need the presentation to work immediately and no longer require live data. Use Change Source when the source file still exists in a different location. Use Disable Auto Update when you want to control when links refresh without breaking them permanently.