PowerPoint Not Updating Linked Excel Charts? 7 Causes and Fixes

A linked chart that stops updating rarely shows an error. It just keeps showing old numbers. Here is how to find out why, cause by cause.

When PowerPoint stops updating a linked Excel chart, the cause is almost always one of seven things: the link is set to manual, the workbook moved, the link points to a path only you can reach, a security prompt blocked the update, the chart was never linked, the data grew past the chart's range, or the part you changed is one the link does not carry. Start at File → Info → Edit Links to Files: it shows every link, where it points and how it updates, and it rules out most of the list in under a minute.

This article is troubleshooting only. If you are still deciding how to get the chart onto the slide in the first place, the paste options are covered in how to insert an Excel chart into PowerPoint.

First: which kind of object is it?

"Linked chart" covers two different things in PowerPoint, and they update differently.

• A linked chart (pasted with one of the Link Data paste options). It is a PowerPoint chart whose data lives in the workbook. Select it and use Chart Design → Refresh Data.
• A linked object (pasted with Paste Special → Paste link, or added with Insert → Object with Link ticked). It shows a view of the Excel content. Right-click it and choose Update Link.

Both appear in Edit Links to Files. Anything that does not appear there is not linked, which is cause 5 below.

1. The link is set to manual update

Symptom: the chart updates when you click Update Now, but never on its own.

Why: each link has its own update method. Microsoft's documentation for the setting describes the two: automatic links are "updated each time the presentation is opened or the source file changes," and manual links only "when the user specifically asks."

Fix: in Edit Links to Files, select the link, tick Automatic update, close the dialog and save the presentation. The setting is per link, so a deck with thirty charts means thirty clicks. For that case, a short macro sets them all (work on a copy first):

Sub SetAllLinksAutomatic()
      Dim sld As Slide, shp As Shape
      For Each sld In ActivePresentation.Slides
          For Each shp In sld.Shapes
              If shp.Type = msoLinkedOLEObject Or shp.HasChart Then
                  On Error Resume Next
                  shp.LinkFormat.AutoUpdate = ppUpdateOptionAutomatic
                  On Error GoTo 0
              End If
          Next
      Next
  End Sub

Be aware that several Microsoft Q&A threads report the Automatic box being unticked again after reopening, or links not updating on open even when it stays ticked. If that is you, do not rely on it: update manually before every meeting, which is one line of VBA, ActivePresentation.UpdateLinks, documented by Microsoft as updating every linked object in the presentation.

2. The workbook was moved, renamed or is not on this computer

Symptom: an error when you try to edit the chart data, or the chart simply keeps the last numbers it had. Often it works on your laptop and not on a colleague's.

Why: a link stores a file path. Rename the workbook, move it to another folder, or open the deck on a machine where that path does not exist, and there is nothing at the other end. Microsoft's guidance for linked objects is plain about it: both files need to be accessible to see the linked information.

Fix: in Edit Links to Files, select the link, click Change Source, browse to the workbook in its new location, click Open, then Update Now. If you do not know where the workbook went, Break Link keeps the chart on the slide as embedded data, but Microsoft notes it becomes static from then on.

3. OneDrive or SharePoint: the link points to a path others cannot reach

Symptom: links update for the person who made them and for no one else, or links to files in a synced folder stop updating automatically for everyone.

Why: a workbook in OneDrive or SharePoint has two addresses, a local synced path such as C:\Users\you\OneDrive\... and a web address. A link records whichever one the file had when the link was made. In a Microsoft support answer about workbook links, opening the source in the desktop app produced a local path, and a local path is only valid for the person who created it. Separately, a Microsoft MVP answering a PowerPoint thread noted that OneDrive "seems to cause problems for PowerPoint/Excel + links."

Fix: open Edit Links to Files and read the path. If it starts with a personal folder, use Change Source to point it at a location everyone who opens the deck can reach. To find out whether the cloud folder is the problem at all, the MVP's test is a good one: copy the deck and the workbook to a local folder that is not synced and try again. If the links update there, the problem is the path, not the chart.

4. A security prompt or Protected View blocked the update

Symptom: the deck opened with a prompt about links or a yellow bar, someone clicked past it, and the numbers are old.

Why: PowerPoint asks before updating links when a presentation opens, and choosing not to update leaves the last saved values. Files that arrive from the internet or as email attachments open in Protected View, read-only until you click Enable Editing. Microsoft also notes that when a presentation has external content, a bar tells you it has been disabled until you click Enable Content, and that unlike Excel, PowerPoint has no global Trust Center setting for external content.

Fix: close and reopen the deck, choose to update links at the prompt, or click Enable Editing or Enable Content and then use Update Now in Edit Links to Files. Do this only for files you trust: the prompt exists because links reach outside the file.

5. The chart was embedded, not linked

Symptom: the chart is not listed in Edit Links to Files at all, and nothing you do in PowerPoint brings in the workbook's new numbers.

Why: one of the Embed paste options was used, the chart was created inside PowerPoint, or someone clicked Break Link at some point. An embedded chart carries its own copy of the data and has no connection back to the workbook.

Fix: there is nothing to repair. Delete the chart, copy it from Excel again and paste with one of the Link Data options. You can still edit an embedded chart's numbers with right-click → Edit Data, by hand.

6. The data grew past the chart's range

Symptom: the chart updates, the existing bars change, but the new month is missing.

Why: the chart in Excel points at a fixed block of cells, for example A1:B13. The link faithfully refreshes those cells. Row 14 was never part of the chart, in Excel or in PowerPoint.

Fix: open the workbook, select the chart, use Select Data and extend the range, save, then refresh in PowerPoint. To stop it happening every month, base the chart on an Excel table (Insert → Table), which grows as rows are added, or on a dynamic range; Microsoft documents the defined-name method step by step.

7. The part you changed is not carried by the link

Symptom: the values update, but a new chart title, axis title or trendline added in Excel never appears on the slide.

Why: on a linked chart, the refresh carries the data. In a Microsoft Q&A thread, a Microsoft support agent reproduced that titles and axis titles "are not updated even after the refresh update or manually reopen the presentation" and described it as a current limitation.

Fix: make text and formatting changes on the PowerPoint side, where they will stick. If the chart's structure has changed (new series, different chart type), re-paste it.

Two more problems that look like these

The chart resizes or gets cut off after updating

This is reported for charts pasted with Paste Special → Paste link → Microsoft Excel Chart Object. In that Microsoft Q&A thread, a Microsoft support reply suggested pasting with Keep Source Formatting & Link Data instead, which "keeps the chart intact without resize" when the source data updates.

Many links make the deck slow to open or update

Every link has to reach its workbook, and a deck with dozens of links asks about all of them at open. Set the links to manual, and update them once, deliberately, when the data is final, using Update Now or ActivePresentation.UpdateLinks. If links still misbehave on a brand-new workbook and presentation, the step Microsoft's agents suggest in the Q&A threads is an Online Repair of Office from Settings → Apps.

If you actually want to embed the workbook

Sometimes the right fix is to stop linking. To embed a whole Excel file, use Insert → Object → Create from file, browse to the workbook, leave Link unticked and click OK. Microsoft notes in its guide to Excel data in PowerPoint that the object shows the active, top worksheet, so save the workbook with the sheet you want showing, and that embedding a large workbook inflates the presentation. The deck then travels anywhere and never updates.

When linking is the wrong tool

Every cause above comes from the same design: the slide depends on a file path, and the path has to survive moves, renames, cloud sync, security prompts and other people's laptops. For a chart you update once, that is fine. For a deck you rebuild every month, it is a lot of moving parts for one chart, and the takeaway text beside the chart has no link at all.

Quiriz for PowerPoint takes the workbook path out of it. Instead of linking to a file, each chart, table and figure keeps its question on the shape, such as net sales by month, and asks it of your data in Quiriz: spreadsheets you upload, a Google Drive or OneDrive folder on a schedule, or HubSpot connected directly. There is no path on your machine for a colleague's copy to lose.

The charts arrive as native, editable PowerPoint charts. Right-click one and Edit Data opens the numbers behind it, and you can restyle it like any chart you built yourself, or say "dark blue" or "a line instead of bars" with Change. When new data is in, Refresh all asks every question again and updates every chart, table, figure and takeaway together, keeping your formatting. The takeaways are written from each chart's own figures, so the text moves with the numbers instead of staying behind on last month's.

It works in PowerPoint 2021 and later on Windows and Mac, and in PowerPoint on the web. For the monthly version of this problem in more depth, see how to make a chart in PowerPoint and automating an Excel report update.

Where this does not apply

If the chart comes from a hand-built Excel model, a forecast with assumptions in cells, a scenario workbook, a calculation that is not a question anyone could ask of a dataset, then the workbook is the source of truth and linking is the right tool. Fix the link with the steps above and keep it.

Frequently asked questions