Office for Mac Issues

How to Fix Excel Cannot Edit Word Chart Data on Mac

Emma BrownEmma Brown Nov 4, 2026 868 views

Question details

The user is unable to edit chart data in a Word document because Excel cannot open or locate the linked source file.

How to Fix Excel Cannot Edit Word Chart Data on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Check OneDrive status

Click the OneDrive cloud icon located in the Mac menu bar at the top of your screen.

2
Resolve sync errors

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'.

3
Restart and test

Once the OneDrive status displays 'Up to date', restart your Mac. Open the Word document again, right-click the chart, and select 'Edit Data'.

Resolve OneDrive Synchronization Issues
Tip: Always keep the OneDrive app updated to the latest version on your Mac to prevent background syncing interruptions.
Free Microsoft Office alternative

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. 1. Download and install: Visit the official WPS Office website to download and install the free Mac version.
  2. 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. 3. Edit with ease: Edit your charts and data smoothly within a single, integrated application without worrying about broken external links.
Completely free to use with a lightweight installation package.Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Unified tabbed interface prevents missing linked file errors between documents.Built-in cloud synchronization for reliable cross-device file management.
microsoft office alternative - wps office

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.