When you paste a chart from Excel into PowerPoint using the Link Data option, the chart displays current data from the Excel source file. Many users expect the chart to update automatically every time they open the presentation or every time the Excel data changes. This article explains the actual refresh behavior of linked Excel charts in PowerPoint. You will learn when updates happen, when they do not, and how to force a manual refresh. Understanding this mechanism prevents confusion and ensures your presentation always shows the correct data.
Key Takeaways: How Linked Excel Charts Refresh in PowerPoint
- File > Info > Edit Links to Files: Opens the Links dialog to manually update, change source, or break a chart link.
- Ctrl+A then F9 in the Links dialog: Selects all linked objects and updates them in one action.
- Data > Edit Links in Excel: Not available in PowerPoint — you must use the PowerPoint Links dialog for refresh control.
Why Linked Excel Charts Do Not Auto-Refresh in PowerPoint
When you link a chart from Excel to PowerPoint, the chart object stores a reference to the source workbook file and the specific chart name. PowerPoint does not maintain a live connection to Excel. Instead, it reads the chart data from the source file only when you open the presentation and only if the default update setting is enabled. By default, PowerPoint asks whether to update links when you open a presentation that contains linked objects. If you click Update Links, PowerPoint reads the current data from the Excel file. If you click Don’t Update, the chart keeps the data that was present the last time you updated it. This behavior prevents automatic changes that could surprise you during a presentation. The linked chart never updates while you are working inside PowerPoint unless you manually trigger a refresh. Changes made in Excel while PowerPoint is closed will be applied only on the next open with Update Links. Changes made in Excel while PowerPoint is open will not appear until you manually update the link.
How the Link Stores the Source Path
The link stores the full file path to the Excel workbook, such as C:\Reports\SalesData.xlsx. If you move or rename the workbook, PowerPoint cannot find the source and displays a broken link. The chart then shows the last cached data. You can repair the link using the Change Source button in the Links dialog. The link also stores the chart sheet name or chart object name inside the workbook. If you delete or rename that chart in Excel, the link breaks.
What Happens When You Send the Presentation to Another User
If you send the PPTX file to another person, the linked chart data will not update unless that person also has access to the same Excel file at the same file path. If the path is C:\Reports\SalesData.xlsx on your computer and the recipient does not have that file, the link will be broken. The recipient will see the last cached chart data. To share a presentation with live links, you must also share the Excel file and instruct the recipient to place it in the same folder path or use a shared network location.
Steps to Manually Refresh a Linked Excel Chart in PowerPoint
Use these steps to update a linked Excel chart when the source data has changed.
- Open the Links dialog
Go to File > Info. In the right pane, click Edit Links to Files. The Links dialog opens, listing all linked objects including charts. - Select the chart link to update
Click the link that corresponds to the chart you want to refresh. The list shows the source file name and the link type, such as Microsoft Excel Chart. - Update the selected link
Click the Update Now button. PowerPoint reads the current data from the Excel source file and refreshes the chart in the slide. The chart updates immediately. - Update all links at once
Click the first link, press Shift, and click the last link to select all. Then click Update Now. Alternatively, press Ctrl+A inside the Links dialog to select all links, then click Update Now. - Close the Links dialog
Click Close to return to the presentation. The chart now shows the latest data from Excel.
Alternative Method: Right-Click the Chart
Right-click the linked chart on the slide. From the context menu, select Update Link. This action updates only that specific chart without opening the Links dialog. This method is faster when you need to refresh a single chart.
If the Linked Chart Does Not Update After Refresh
Several conditions can prevent a linked chart from updating even after you click Update Now.
“The linked file is not available” Error
This error appears when PowerPoint cannot find the source Excel file. The file may have been moved, renamed, or deleted. In the Links dialog, click Change Source. Navigate to the correct Excel file and select it. PowerPoint updates the link path and refreshes the chart. If the file was deleted, you must recreate the chart or use a different source.
Chart Shows Old Data After Update
If the chart updates but still shows old values, the Excel source file may have unsaved changes. Open the Excel workbook, ensure the chart data is correct, and save the file. Then return to PowerPoint and update the link again. PowerPoint reads only saved data from the Excel file, not unsaved changes.
Linked Chart Shows a Red X or Placeholder Image
A red X or a blank placeholder indicates a broken link that cannot be resolved. This often occurs when the chart object in Excel was deleted or the link points to a chart that no longer exists. In the Links dialog, click Break Link to convert the chart to a static picture. You will lose the ability to update the data, but the chart image remains. To restore live linking, delete the broken chart and re-insert it from Excel using Paste Special > Paste Link.
Linked Chart Refresh: PowerPoint Desktop vs PowerPoint for the Web
| Feature | PowerPoint Desktop (Windows/Mac) | PowerPoint for the Web |
|---|---|---|
| Manual refresh via Links dialog | Yes | No |
| Right-click Update Link | Yes | No |
| Auto-update on open with prompt | Yes, configurable | No, links are not supported |
| Change Source functionality | Yes | No |
PowerPoint for the Web does not support linked Excel charts. If you open a presentation with linked charts in PowerPoint for the Web, the charts display as static images showing the last cached data. You cannot refresh or change the source. Editing linked charts requires the desktop version of PowerPoint.
The refresh behavior of linked Excel charts in PowerPoint is predictable once you understand the manual update requirement. Use the Links dialog to update all charts at once before a presentation. For single-chart updates, right-click the chart and choose Update Link. Always keep the Excel source file in a stable location and save changes before refreshing. If you share the presentation, include the Excel file or break the links to send a static version. For real-time data that updates automatically, consider embedding the chart instead of linking it.