When you paste an Excel chart into a PowerPoint presentation as a linked object, the chart displays live data from the original Excel file. If the source Excel file is moved, renamed, or deleted, the link breaks and the chart no longer updates. This article explains why the link breaks and how to reconnect or update the chart after the source file moves. You will learn the exact steps to change the source path and restore live updates.
Key Takeaways: Updating Linked Excel Charts After the Source File Moves
- File > Info > Edit Links to Files: Opens the Links dialog where you can change the source file path for a linked chart.
- Links dialog > Change Source: Lets you browse to the new location of the moved Excel file and reconnect the link.
- Ctrl+A, F9: Selects all linked charts and updates them manually after changing the source path.
Why Linked Excel Charts Break When the Source File Moves
PowerPoint stores the full absolute path to the source Excel file, including the drive letter and folder structure. When the file is moved to a different folder, renamed, or copied to another computer, the stored path no longer matches the actual location. PowerPoint then displays a broken link icon or a placeholder image instead of the chart. The linked chart still exists in the presentation, but the data connection is severed until you update the source path. This behavior is by design: PowerPoint does not automatically search for moved files to prevent accidental data corruption.
What Happens to the Chart Data
When a link breaks, the chart retains the last cached data from before the file moved. If you edit the chart in PowerPoint, you are editing a static picture, not the linked data. The chart will not reflect any changes made to the Excel file after the move until you reconnect the link. This is often confusing because the chart still appears to show data, but it is frozen at the old values.
Steps to Update the Source Path for a Linked Excel Chart
Use the Links dialog to change the source file path. This works whether the file was moved to a different folder, a different drive, or a network location.
- Open the presentation that contains the linked chart
Make sure the presentation is saved. The Links dialog works only when the presentation file has been saved at least once. - Go to File > Info
In the Info pane, look for the Edit Links to Files button. It appears only if the presentation contains linked objects such as Excel charts. If you do not see it, click the arrow next to Related Documents to expand the section. - Click Edit Links to Files
This opens the Links dialog, which lists every linked file in the presentation. Each entry shows the source file name, type, and current status — for example, Automatic or Manual update mode, or Error if the link is broken. - Select the broken link and click Change Source
In the Links dialog, click the entry for the Excel chart. The Source field shows the old path. Click Change Source to open a file browser. - Browse to the new location of the Excel file
Navigate to the folder where the source file now resides. Select the file and click Open. The Source field in the Links dialog updates to the new path. - Click Update Now to refresh the chart
With the correct source selected, click Update Now. PowerPoint reads the data from the new location and refreshes the chart in the slide. If the chart does not update immediately, close the Links dialog and press F9 to force a refresh. - Close the Links dialog and save the presentation
After confirming the chart displays correctly, save the presentation. The updated path is stored with the file.
If the Excel File Was Renamed
The same steps apply if the file was renamed instead of moved. In the Change Source dialog, select the new file name. PowerPoint recognizes the renamed file as long as the internal structure of the workbook is unchanged. If the worksheet name or chart name inside the workbook changed, you may need to re-link the chart from scratch.
What to Do If the Links Dialog Does Not Show the Chart
Linked chart appears as a static image or placeholder
If the chart was pasted as a picture or embedded rather than linked, the Links dialog will not list it. To verify the link type, right-click the chart and select Format Object. In the Format Object pane, look for the Link section. If you see a Source field, the chart is linked. If not, the chart is either an embedded object or a static picture. You must delete it and re-paste the chart using Home > Paste > Paste Special > Paste Link.
Multiple linked charts from the same file
When you have several charts linked to the same Excel file, the Links dialog shows one entry per chart. You must change the source for each entry individually. To save time, note the new path and select each entry in turn, clicking Change Source and browsing to the same file. PowerPoint allows you to select multiple entries at once only if they share the same source file. Hold Ctrl and click each entry, then click Change Source.
Broken link warning on opening the presentation
PowerPoint may show a security warning that the linked file is unavailable. This is normal when the source has moved. Click Update Links in the warning bar, then follow the steps above to change the source path. If you click Don’t Update, the chart keeps the cached data, but the link remains broken.
Linked Excel Chart in PowerPoint vs Embedded Chart
| Item | Linked Chart | Embedded Chart |
|---|---|---|
| Source file requirement | Requires the external Excel file to be present and at the correct path | No external file needed after embedding |
| Data update | Updates automatically or manually when the Excel file changes | Does not update; data is static |
| File size impact | Smaller presentation file because data is stored externally | Larger presentation file because the entire chart data is stored inside PowerPoint |
| Moving the file | Breaks the link; requires manual reconnection | No effect; the chart stays intact |
| Best use case | Live reports or dashboards that must reflect the latest data | One-time presentations where the data will not change |
If the Source File Cannot Be Found
Original file was deleted or overwritten
If the source Excel file no longer exists and you have no backup, the linked chart cannot be updated. You can either embed the chart as a static object or recreate the chart from the cached data. To embed the cached data, right-click the chart, select Linked Worksheet Object > Links, and then click Break Link. The chart becomes an embedded object with the last cached data. Note that after breaking the link, the chart will never update again.
File moved to a network share with different permissions
If the source file is now on a network drive that requires different credentials, the link may still fail even after updating the path. Open the Excel file from the new location first and verify that you have read access. Then follow the Change Source steps. If prompted, enter the network credentials. For best results, use a mapped drive letter instead of a UNC path such as \\Server\Share\File.xlsx.
You can now update linked Excel charts in PowerPoint after the source file moves by using the Links dialog at File > Info > Edit Links to Files. Always verify that the chart refreshes after changing the source path. For presentations that are shared with others, consider embedding the chart instead to avoid broken link issues, or store the Excel file in a stable network location that does not change.