Powerpoint Chart Edit Data Linked File Not Available
Powerpoint is a popular tool used to create presentations for various purposes. It is widely used in offices, schools, and other organizations. One of the features of Powerpoint is the ability to create charts and graphs. However, sometimes users encounter an error message when trying to edit the data in a chart. The error message reads "Linked file not available". This article will explain the possible causes of this error and how to fix it.
What Causes the Linked File Not Available Error?
The linked file not available error occurs when the Excel file that is linked to the chart is moved, renamed, or deleted. Powerpoint creates a link to the Excel file when the chart is created, and if the link is broken, the chart will not display properly. This error can also occur if the Excel file is open in another program, or if the file is corrupted.
How to Fix the Linked File Not Available Error
There are several ways to fix the linked file not available error:
1. Re-Link the Excel File
The first step to fixing the error is to re-link the Excel file to the chart. To do this, follow these steps:
- Right-click on the chart and select "Edit Data".
- In the Excel window that opens, click on the "Edit" button in the "Data" group on the "Chart Tools" tab.
- In the "Edit Data Source" window, select the Excel file that is linked to the chart.
- Click "OK".
2. Move the Excel File to the Original Location
If the Excel file was moved to a different location, move it back to the original location. This should restore the link to the chart.
3. Rename the Excel File
If the Excel file was renamed, rename it back to the original name. This should restore the link to the chart.
4. Close the Excel File in Other Programs
If the Excel file is open in another program, close it. This should allow Powerpoint to access the file and restore the link to the chart.
5. Repair or Reinstall Office
If none of the above steps work, it is possible that the Office installation is corrupted. Try repairing or reinstalling Office to fix the issue.
Conclusion
The linked file not available error can be frustrating for Powerpoint users, especially when creating important presentations. However, by following the steps outlined in this article, users can easily fix the error and continue creating professional-looking charts and graphs. Remember to always double-check the links to Excel files before finalizing a presentation to avoid encountering this error.