How to Fix Paste Special Link Errors for Excel Charts in Word for Mac
Question details
Users encounter an error about obtaining link data when attempting to paste an Excel chart into Word for Mac using the Paste Special Linked Chart Object feature.
- Product
- Microsoft Word for Mac, Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to dynamically link an Excel chart to a Word document so that updates in the spreadsheet automatically reflect in the document.
- Observed behavior
- Word fails to complete the paste action and displays an error message stating it cannot obtain link data from Excel.
Ensure both your Excel workbook and Word document are saved locally to your Mac's hard drive rather than a cloud folder like OneDrive, as syncing interruptions can sometimes block the linking process.
Revert to a Previous Stable Office Version
Downgrade your Office installation to an older, stable build if the linking error was introduced in a recent update.
Certain builds of Office for Mac (such as version 16.56) contain known bugs that disrupt OLE linking between Excel and Word. Temporarily reverting to a prior stable version, like 16.55, usually restores functionality until Microsoft releases a permanent fix.
Open your Mac's Applications folder and move the current versions of Microsoft Word and Microsoft Excel to the Trash.
Navigate to the official Microsoft Office for Mac release history page online and download the installer package for an older, stable version (for example, version 16.55).
Run the downloaded installer. Once installed, open Word, go to Help > Check for Updates, and disable automatic updates to prevent the buggy version from reinstalling.
Install the Latest Office and macOS Updates
Apply the most recent updates to your operating system and Office suite to check if the bug has already been patched.
Test with New Locally Saved Files
Rule out file corruption or OneDrive syncing conflicts by testing the Paste Special feature with fresh, local files.
Try WPS Office for Seamless Document and Spreadsheet Linking
If ongoing Microsoft Office updates are causing productivity-halting bugs on your Mac, consider switching to WPS Office. It provides a lightweight, highly compatible suite where integrating spreadsheet data into text documents works smoothly and reliably.
Frequently Asked Questions
Why does Word say it cannot obtain link data from Excel?
This error typically occurs due to software bugs in specific Office for Mac updates. It can also be triggered by file path restrictions when files are actively syncing in cloud environments like OneDrive.
Is there a workaround without rolling back my Office version?
Yes. If dynamic linking is broken, you can perform a standard paste instead. This will embed the chart directly into the Word document. While it will not automatically update when the original Excel file changes, it bypasses the link data error.
How do I stop Office from automatically updating?
Open any Office application, navigate to Help > Check for Updates in the top menu, and uncheck the "Automatically keep Microsoft Apps up to date" option. This allows you to stay on a stable build until a confirmed fix is released.
