How to Fix Paste Special Linked Charts from Excel to Word on Mac
Question details
Users are encountering an error when trying to paste an Excel chart into Word as a linked object using the Paste Special feature.
- Product
- Microsoft Excel and Microsoft Word
- Device & OS
- Mac
- Scenario
- Copying a chart from an Excel workbook and attempting to paste it into a Word document as a linked Microsoft Excel Chart Object.
- Observed behavior
- Word for Mac displays an error reporting that it cannot obtain link data, preventing the chart from pasting correctly.
Ensure both your Excel workbook and Word document are saved locally on your Mac, as unsaved files or pending cloud synchronization can sometimes interfere with cross-application data linking.
Use Keep Source Formatting or Graphic Object Option
Avoid the legacy Excel Chart Object option by pasting the chart normally or choosing the Microsoft Office Graphic Object format.
The legacy Microsoft Excel Chart Object option often causes data link errors on macOS. Switching to standard paste formatting options or using the modern Graphic Object bypasses this limitation while retaining chart quality.
Open your Excel workbook, select the chart you want to transfer, and press Cmd+C to copy it.
Switch to your Word document and press Cmd+V to paste the chart.
Click the small Paste Options button that appears next to the pasted chart and select 'Keep Source Formatting'.
If you prefer using Paste Special, navigate to the Home tab, click the arrow next to Paste, select Paste Special, and choose 'Microsoft Office Graphic Object' instead of the legacy chart option.
Match Office Themes Across Both Files
Aligning the document themes in both Excel and Word prevents formatting conflicts that can break chart connections.
Avoid Cross-App Paste Errors with WPS Office
If Microsoft Office on Mac continues to struggle with cross-application linking and pasting, consider switching to WPS Office. It provides a unified, all-in-one workspace where Word documents, Excel spreadsheets, and PowerPoint presentations are managed in a single app, eliminating legacy paste errors entirely.
- 1. Download and Install WPS Office: Get the free WPS Office application for your Mac and install it.
- 2. Open your files in one window: Open both your Excel spreadsheet and Word document within WPS Office; they will appear as convenient tabs in the same window.
- 3. Copy and paste seamlessly: Copy the chart from the WPS Spreadsheet tab and paste it directly into the WPS Writer tab without encountering legacy link errors.
Frequently Asked Questions
Why does Word for Mac say it cannot obtain link data?
This error is typically caused by using the legacy 'Microsoft Excel Chart Object' format in the Paste Special menu. Modern versions of macOS and Office handle data linking differently, and this older method is prone to failure. Standard pasting or using 'Microsoft Office Graphic Object' usually resolves the issue.
Will matching theme colors really fix paste errors?
Yes, in many cases. If a chart uses custom colors or fonts that diverge from the established document theme, Word may struggle to interpret the formatting data during a Paste Special operation. Matching the theme via the Design tab in Word and Page Layout tab in Excel ensures compatibility.
How do I access Paste Special on Word for Mac?
After copying your chart from Excel, go to your Word document. Navigate to the Home tab, click the small downward-facing arrow next to the 'Paste' icon, and select 'Paste Special...' from the drop-down menu to reveal formatting options.
