PowerPoint Chart Link to Excel Breaks After Moving File: Fix

When you move a PowerPoint presentation that contains a chart linked to an Excel workbook, the link often breaks. This happens because PowerPoint stores the chart link as an absolute file path. After the move, the file path no longer points to the correct location on your computer or network. This article explains why the link breaks and provides three reliable methods to reconnect or prevent the issue.

The root cause is how PowerPoint and Excel handle linked objects. PowerPoint saves the full folder path and file name of the source Excel workbook. When you move either the presentation or the workbook without updating the link, PowerPoint cannot find the source data. The chart then displays a broken link icon or fails to update.

You will learn how to repair broken links using the Edit Links to Files dialog. You will also see how to use relative paths and alternative embedding methods to keep your charts connected after moving files.

Why the Chart Link Breaks After Moving the File

PowerPoint uses OLE Object Linking and Embedding to connect a chart to its source Excel data. The link is stored as an absolute path, for example C:\Users\Name\Documents\SalesData.xlsx. When you move the PowerPoint file or the Excel workbook to a different folder, drive, or network location, the absolute path no longer matches the new location. PowerPoint then shows a broken link symbol, and the chart displays placeholder data or an error message.

The link break occurs in these common scenarios:

• Moving the PowerPoint file to a different folder on the same computer.
• Moving the Excel workbook to a different folder.
• Copying both files to a USB drive or cloud folder like OneDrive or SharePoint.
• Emailing the PowerPoint file without also sending the Excel workbook.

The same absolute-path limitation applies to all linked objects in PowerPoint, including charts, tables, and embedded worksheets. Fixing the link requires updating the source path in PowerPoint.

Steps to Repair a Broken Chart Link in PowerPoint

Use the Edit Links to Files dialog to reconnect the chart to the moved Excel workbook. This method works in PowerPoint 2016, 2019, 2021, and PowerPoint for Microsoft 365 on Windows 10 and Windows 11.

1. Open the presentation with the broken chart
   Launch PowerPoint and open the file that contains the linked chart. The chart may show a red X or a message saying the link cannot be updated.
2. Open the Edit Links to Files dialog
   Go to File > Info. In the lower-right section of the Info pane, click Edit Links to Files. If the button is grayed out, your presentation contains no linked objects. Close the dialog and check the chart properties.
3. Select the broken link
   In the Links dialog, you will see a list of all linked objects. Each entry shows the source file name, the object type such as Chart, and the current link status. Select the entry whose path points to the old Excel file location. The status may read Error: Source not found.
4. Change the source to the new file location
   Click Change Source. In the Change Source dialog, navigate to the new location of the Excel workbook. Select the file and click Open. If the workbook contains multiple sheets or named ranges, you can choose the specific data range in the Item Name field.
5. Update the link and verify
   Back in the Links dialog, click Update Now. The status should change to Manual or Automatic depending on your previous setting. Click Close. The chart in your slide should now display the correct data from the moved Excel file.

If the Change Source Button Is Grayed Out

If you cannot click Change Source, the link may be embedded rather than linked. Right-click the chart and select Edit Data. If a mini Excel window opens inside PowerPoint, the chart uses an embedded copy of the data, not a link. You must re-create the link manually. Alternatively, the file may be a protected view. Click Enable Editing on the yellow banner above the slide, then try again.

Repairing Links When the Excel File Is on OneDrive or SharePoint

When the Excel workbook is stored on OneDrive or SharePoint, the link path may include a long web address. After moving the PowerPoint file, the link still breaks. Use the same Edit Links to Files dialog. Click Change Source and browse to the file using the OneDrive folder on your local computer. Do not paste a web URL directly. After relinking, PowerPoint resolves the path through the local sync folder.

If PowerPoint Still Has Issues After the Main Fix

Chart Shows Old Data After Relinking

PowerPoint caches the chart data. After changing the source, the chart may still show old values. Right-click the chart and select Edit Data. The Excel workbook opens. Close Excel without making changes. PowerPoint refreshes the chart from the workbook. If the data still does not update, go to File > Info > Edit Links to Files, select the link, and click Update Now again.

Link Breaks Again After Moving the Folder

If you plan to move the presentation and the workbook together, save both files in the same folder before linking. PowerPoint then stores a relative path instead of an absolute path. To check, open the Links dialog and look at the source path. If it shows only a file name without a full folder path, the link is relative and will survive folder moves. If the path is absolute, remove the chart, re-insert it from Excel while both files are in the same folder, and relink.

Broken Link After Saving to a Network Drive

Network drive paths like \Server\Share\File.xlsx can break if the drive mapping changes. Use the Change Source command and navigate to the file using the UNC path. To avoid future breaks, map the network drive to a consistent letter, such as Z:, and save both files in a folder on that drive. Then relink using the drive letter path.

PowerPoint Link Maintenance vs Embedding vs Manual Update

Item	Linked Chart	Embedded Chart	Manual Paste as Picture
Source data location	External Excel workbook	Inside PowerPoint file	None static image
File size impact	Minimal small link pointer	Large full data copy	Small image only
Data updates automatically	Yes when Excel changes	No must edit in PowerPoint	No
Survives file move	No breaks unless same folder	Yes	Yes
Best use case	Live reports with changing data	Archived or static data	Final presentations no edits

Using a linked chart keeps your PowerPoint data current with the Excel workbook. Use embedding when you need to share the file without the Excel source. Use a static picture when the data will never change.

After relinking your chart, consider setting the link update mode to Automatic in the Links dialog. This setting ensures the chart refreshes each time you open the presentation. To change the mode, open File > Info > Edit Links to Files, select the link, and choose Automatic under Update Method. For presentations that you send to others, switch to Manual to prevent update prompts on their computers.