How to Fix PowerPoint Chart Showing ‘Linked File Not Available’

When you open a PowerPoint presentation that contains a chart, you may see the message Linked File Not Available instead of the actual chart data. This error typically occurs when the chart was created from data in an external Excel file, and PowerPoint cannot find that source file. The file may have been moved, renamed, deleted, or the link path may have broken. This article explains why the error occurs and provides step-by-step methods to restore the chart or break the link so the chart displays correctly.

Why the Linked File Not Available Error Appears

PowerPoint charts can be linked to an external Excel workbook. When you create a chart from Excel data and paste it as a linked object, PowerPoint stores the path to that Excel file. Every time you open the presentation, PowerPoint tries to reload the data from the source file. If the source file is missing, renamed, or moved to a different folder, the link breaks and the chart displays the error message Linked File Not Available.

The error can also appear if the Excel workbook was saved on a network drive that is no longer accessible, or if the file was opened on a different computer where the same path does not exist. In some cases, the link itself becomes corrupted due to a partial save or an interrupted file transfer.

The chart object is still present in the slide, but its data source is unreachable. You have three options to resolve this: update the link to point to the correct file, break the link and keep the current data, or convert the chart to a static image.

Steps to Fix the Linked File Not Available Error

Method 1: Update or Repair the Link Using Edit Links to Files

1. Open the presentation and go to File > Info
   In the Info pane, look for the Edit Links to Files button. If the presentation contains linked files, this button appears at the bottom of the right panel. Click it to open the Links dialog.
2. Locate the broken link in the Links dialog
   The dialog lists all linked objects. A broken link shows the source file path with a warning icon or the text Linked File Not Available. Select the broken link from the list.
3. Click Change Source and browse to the correct Excel file
   Click the Change Source button. Navigate to the location of the Excel file. If the file was moved, find it in its new folder. Select the file and click Open. PowerPoint updates the link and reloads the chart data.
4. If the file is permanently missing, click Break Link
   If you no longer have the original Excel file or cannot locate it, click Break Link. This converts the linked chart into static data embedded directly in PowerPoint. The chart will display the last data values it had before the link broke. A prompt asks you to confirm. Click Yes.
5. Close the Links dialog and verify the chart
   The chart should now display correctly. If you broke the link, the chart becomes a static object and will not update if the Excel data changes later.

Method 2: Unlink All Fields Using Keyboard Shortcuts

1. Press Ctrl + A to select all objects on the current slide
   This selects text boxes, shapes, and charts. To unlink all charts in the entire presentation, switch to the Outline view or use the Selection Pane to select all slides.
2. Press Ctrl + F9 to unlink all fields
   This keyboard combination removes all field codes, including linked chart data references. The chart converts to static data. Note that this method works on a per-slide basis. Repeat for each slide that contains a linked chart.
3. Save the presentation
   After unlinking, save the file. The next time you open it, the chart will display without the error.

Method 3: Convert the Linked Chart to a Static Image

1. Right-click the chart that shows Linked File Not Available
   A context menu appears. If the chart is not responding, select the chart placeholder area.
2. Select Copy from the menu
   This copies the current chart object to the clipboard.
3. Press Delete to remove the broken chart object
   The placeholder is removed from the slide.
4. Right-click the slide and choose Paste Special
   In the Paste Special dialog, select Picture (Enhanced Metafile) or Picture (PNG). Click OK. This pastes a static image of the chart. The image does not link to any external file and will never show the error.

If the Error Persists After the Main Fix

The Links dialog shows no broken links but the error still appears

This can happen if the chart was created using an older OLE object that is not listed in the standard Links dialog. To fix this, use the keyboard shortcut method Ctrl + A then Ctrl + F9 on each slide. If that does not work, delete the chart entirely and reinsert it as a static image using Paste Special.

PowerPoint crashes when I open the Links dialog

A corrupted link can cause PowerPoint to hang. Open the presentation in Safe Mode by holding the Ctrl key while double-clicking the file. In Safe Mode, go to File > Info and click Edit Links to Files. Break the link immediately. Save the file, close Safe Mode, and reopen normally.

The chart displays correctly after breaking the link, but the data is outdated

Breaking the link preserves the data that was last loaded. If you need the most recent data, you must locate the original Excel file and use Change Source instead. If the file is gone, manually update the chart by double-clicking the chart object and editing the data table directly after breaking the link.

Linked Chart vs Embedded Chart: Key Differences

Item	Linked Chart	Embedded Chart
Data source	External Excel file	Stored inside the PowerPoint file
File size	Smaller because data is external	Larger because data is included
Updates	Refreshes when Excel file changes	Does not update automatically
Risk of error	Linked File Not Available if source is moved	No external dependency
Best use case	Data that changes frequently	Static reports or presentations shared with others

Choose the linked chart method only when you control the Excel file location and share it with the presentation. For presentations that you email or distribute widely, use embedded charts or static images to avoid the Linked File Not Available error.