When you copy an Excel chart into PowerPoint and paste it as a linked object, the chart updates automatically when the Excel source file changes. But if you move the Excel file to a different folder or rename it, PowerPoint loses the connection. The chart will not refresh, and you will see a broken link error or stale data. This article explains why the link breaks and provides step-by-step methods to reconnect and refresh the chart after the file moves.
Key Takeaways: Relinking a Moved Excel Chart in PowerPoint
- File > Info > Edit Links to Files: Opens the Links dialog where you can change the source path of the broken chart link.
- Change Source button in Links dialog: Lets you browse to the new location of the moved Excel file and reconnect the chart.
- Ctrl+A, F9 after relinking: Selects all linked objects and forces a manual refresh of the chart data.
Why a PowerPoint Chart Link Breaks When the Excel File Moves
When you paste an Excel chart as a linked object in PowerPoint, the program stores an absolute file path to the source Excel workbook. For example, the path might look like C:\Users\Name\Documents\SalesData.xlsx. If you move the Excel file to a new folder, rename it, or copy the presentation to another computer, the stored path no longer points to a valid file. PowerPoint cannot find the source and shows a broken link.
The link stores the full path plus the worksheet name and cell range that the chart references. Even if the file is on a network share and the drive letter changes, the link fails. PowerPoint does not automatically search for the file. You must manually update the link using the Edit Links to Files dialog.
Steps to Refresh a Linked Excel Chart After Moving the Source File
Follow these steps to reconnect and refresh a linked chart in PowerPoint after the Excel file has been moved.
Method 1: Use the Edit Links to Files Dialog
- Open the PowerPoint presentation that contains the linked chart
Make sure the presentation is saved before you change links. A saved presentation ensures the new link path is stored correctly. - Go to File > Info
On the Info page, look for the Related Documents section. Click the Edit Links to Files button. If you do not see this button, the presentation has no linked objects or the links are embedded. - Select the broken link in the Links dialog
The Links dialog lists all linked objects. A broken link shows the old file path and may display an error icon. Click the link to select it. - Click the Change Source button
This opens a standard file browser dialog. Navigate to the new location of the Excel file. Select the file and click Open. - Click Update Now in the Links dialog
After changing the source, PowerPoint attempts to refresh the chart data. If the update succeeds, the chart displays the current data from the moved Excel file. - Close the Links dialog
The link is now restored. Save the presentation to keep the new path.
Method 2: Force a Manual Refresh of All Linked Charts
- Open the presentation and press Ctrl+A
This selects all objects on the current slide. For multiple slides, repeat on each slide or select all objects in the thumbnail pane. - Press F9
F9 updates all selected linked objects. If the link is broken, nothing happens. Use this method only after you have relinked the source file. - Verify the chart data
Right-click the chart and select Edit Data. If the Excel worksheet opens with the correct data, the link is working.
If PowerPoint Still Has Issues After Relinking
The Change Source button is grayed out
This happens when the chart was pasted as an embedded object rather than a linked object. Embedded charts do not have a source file. To fix this, delete the chart and copy it again from Excel using Paste Special > Paste Link.
The link updates but shows old data
The Excel file may have been saved with the same name but the chart data range changed. Open the Excel file and verify that the chart references the correct range. Then in PowerPoint, open the Links dialog, select the link, and click Update Now.
The link works on one computer but not another
When you move the presentation to a different computer, the absolute path to the Excel file is invalid. Place the Excel file in the same relative location (for example, both files in the same folder) and use the Change Source method to relink. For portability, keep the presentation and the Excel file in the same folder before linking.
Linked Chart vs Embedded Chart: Key Differences for Moving Files
| Item | Linked Chart | Embedded Chart |
|---|---|---|
| File size | Small — only stores the link path | Large — stores the entire chart data inside PowerPoint |
| Updates when Excel changes | Yes, after refresh | No — data is static |
| Works after moving Excel file | No — link breaks, must relink | Yes — data is inside the presentation |
| Best for | Live data that changes often | One-time reports or presentations sent to others |
When you need to move the source Excel file frequently, consider using embedded charts instead. To embed a chart, copy it from Excel and paste normally without using Paste Special. The chart becomes part of the PowerPoint file and requires no external link.
To refresh a linked chart after moving the Excel file, use the Edit Links to Files dialog to change the source path. After relinking, press F9 to update the chart. Keep the Excel file in a stable location to avoid future link breaks. For presentations shared with colleagues, embed the chart to eliminate dependency on external files.