How to Fix Excel Cannot Edit Word Chart Data on Mac
Question details
The user is unable to edit chart data in a Word document because Excel cannot open or locate the linked source file.

- Product
- Microsoft Word and Excel
- Device & OS
- Mac
- Scenario
- Trying to edit a chart in a Word document that is linked to an external Excel spreadsheet, particularly when using OneDrive cloud storage.
- Observed behavior
- An error occurs preventing the chart data from being edited, often stating that the linked document cannot be found or accessed.
Ensure your Mac is connected to a stable internet connection, and verify that both the Word document and the source Excel file are fully downloaded to your local drive.
Resolve OneDrive Synchronization Issues
Fixing stalled OneDrive synchronization allows Excel to correctly access and open linked cloud files.
When files are stored in OneDrive, a synchronization delay or error can prevent Mac applications from communicating correctly. Ensuring that OneDrive is fully updated will restore access to linked chart data.
Click the OneDrive cloud icon located in the Mac menu bar at the top of your screen.
Look for any sync errors or stuck files. If the sync is frozen, click the gear icon, select 'Pause syncing', wait a few seconds, and select 'Resume syncing'.
Once the OneDrive status displays 'Up to date', restart your Mac. Open the Word document again, right-click the chart, and select 'Edit Data'.

Restore the Original File Path or Name
Revert any recent changes to the source file's name or folder location to restore the broken link.
Save the Source Document Before Linking
Ensure the Excel file has a saved location on your Mac before attempting to link it to Word.
Use WPS Office for Seamless Chart and Data Editing
Avoid complex linking errors and cloud synchronization issues by switching to WPS Office. It provides a lightweight, unified platform for word processing and spreadsheets, significantly reducing data access errors while keeping your workflow smooth.
- 1. Download and install: Visit the official WPS Office website to download and install the free Mac version.
- 2. Open your files: Launch WPS Office and open your existing Word and Excel documents directly; your formatting and charts will be perfectly preserved.
- 3. Edit with ease: Edit your charts and data smoothly within a single, integrated application without worrying about broken external links.

Frequently Asked Questions
Why does my Word chart say the linked file is unavailable?
This usually occurs if the source Excel file was moved, renamed, deleted, or if the folder containing it was altered after the link was created. It can also happen if OneDrive fails to sync the file locally.
How can I break the link between my Word chart and Excel?
To break the link on a Mac, open your Word document, go to 'Edit' > 'Links', select the linked chart from the list, and click 'Break Link'. The chart will then turn into a static image or an embedded object without external dependencies.
How do I update chart data in Word if the Excel file was moved?
If the source file has a new location, open your Word document, go to 'Edit' > 'Links', select the broken link, and choose 'Change Source'. Then, navigate to the new location of your Excel file to re-establish the connection.




