Fix PowerPoint for Mac Access to Embedded or Linked Excel Chart Data
Question details
The user needs to access and edit Excel data associated with charts in PowerPoint for Mac.

- Product
- Microsoft PowerPoint for Mac and Microsoft Excel
- Device & OS
- macOS
- Scenario
- The user tries to edit chart data in a presentation after an Office update.
- Observed behavior
- PowerPoint reports that linked files are unavailable, although the charts were created with embedded Excel data.
Confirm whether the affected chart uses an embedded workbook or a link to a separate Excel file. If the presentation is on SharePoint or a shared drive, check that you are signed in and can open the location in Finder or a browser.
Restore Access to Linked Excel Files
Use this approach if the chart refers to a separate workbook on SharePoint or a shared drive.
In Finder or a browser, open the shared drive or SharePoint folder that contains the Excel workbook. Reconnect the drive or sign in if prompted.
Open the source workbook in Excel. If it is unavailable, check its location and permissions with the file owner.
Reopen the presentation in PowerPoint, select the chart, and use Chart Design > Edit Data or right-click the chart and choose Edit Data.

Inspect the Presentation for an Embedded Workbook
Check the presentation package when PowerPoint cannot open data that you expect to be embedded.
Update Office and Test PowerPoint in Mac Safe Mode
Use this approach if the problem affects multiple presentations or started after an Office update.
Work With PowerPoint Presentations in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with presentations and spreadsheets. It supports common Microsoft Office formats, making it easier to move existing files into WPS. It does not repair PowerPoint's linked-file access issue.

Frequently Asked Questions
Where is embedded Excel chart data stored in a PowerPoint file?
It may be stored in the ppt/embeddings folder inside the presentation package. Duplicate the presentation in Finder, change the copy's extension to .zip, and open the archive to inspect that folder.
Why does PowerPoint say a linked file is unavailable?
The source workbook may have moved, the shared drive may be disconnected, or your SharePoint permissions or sign-in may have changed. Open the source location in Finder or a browser and try opening the workbook in Excel.
Will editing an extracted workbook update my presentation?
No. An extracted workbook is a separate file. Opening it in Excel can help you inspect the data, but changes do not automatically update the original presentation.
What can I check if every presentation has the same problem?
In PowerPoint, choose Help > Check for Updates, then test another presentation. If the issue persists, restart the Mac in Safe Mode using Apple's instructions for your Mac model and try editing chart data again.




