File Format & Compatibility

How to Fix Word Error: Cannot Obtain Data for an Excel Link

Kushani Nimanthika Oct 20, 2026 868 views

Question details

The user needs to resolve an issue where Microsoft Word fails to retrieve data from a linked Excel spreadsheet when using the Paste Special feature.

How to Fix Word Error: Cannot Obtain Data for an Excel Link

Product: Microsoft Word, Microsoft Excel
Device & OS: not provided
Scenario: Attempting to link an Excel spreadsheet into a Word document as a bitmap using the Paste Special function.
Observed behavior: Word displays an error stating 'Cannot obtain data for an Excel link' and fails to paste or display the linked spreadsheet object.

Before you start

Save your current documents and check your Microsoft Office account settings to note the exact version of Office you are currently using, as version mismatches often cause OLE linking issues.

Solution 1Recommended

Perform Diagnostic Testing to Isolate the Cause

By systematically testing different files and devices, you can determine if the issue stems from corrupted files, a specific Office installation, or system-wide settings.

The 'Cannot obtain data' error is generally caused by one of three things: corruption in the specific Word or Excel file, an issue with the local Microsoft Office installation, or an environment/system configuration problem. Isolating the variable is the fastest way to find a fix.

Create New Test Files

Open both Word and Excel. Create completely new, blank documents in each program. Enter some sample data in the new Excel sheet, copy it, and try the exact same 'Paste Special > Paste Link' operation in the new Word document to see if the error persists.

Verify Your Office Version

In either Word or Excel, navigate to File > Account. Look under Product Information to confirm your exact Office version and build number. Ensure there are no pending updates that might resolve known linking bugs.

Test on Another Device

Transfer both your original Word document and the Excel spreadsheet to a different computer. Open them and attempt to update or recreate the link to see if the error is isolated to your primary computer.

Analyzing Your Results: If the new test files work fine, your original files may be corrupted and need data recovery. If the error happens with all files but works properly on another computer, your Office installation likely requires a repair.

Free Microsoft Office alternative

Switch to WPS Office for Seamless Document Linking

If Microsoft Word consistently fails to link Excel data and repairing the installation does not work, consider switching to WPS Office. It is a highly compatible, free alternative that handles spreadsheet data integration effortlessly without the complex OLE link errors.

1. Download and Install: Download WPS Office for free from the official website and complete the quick installation process.
2. Open Your Existing Files: Open your problematic Word and Excel files directly in WPS Office without needing to convert the file formats.
3. Link Your Data Flawlessly: Copy the required spreadsheet data in WPS Spreadsheet, switch to WPS Writer, and use Paste Special to link your data smoothly.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Seamlessly insert and link spreadsheet data within your text documents.Free and lightweight, avoiding heavy installation or repair processes.Familiar user interface requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word say it cannot obtain data for an Excel link?

This error usually occurs due to corrupted source files, mismatched Office versions (such as running a 32-bit Excel and 64-bit Word), or underlying issues with the Windows OLE (Object Linking and Embedding) registry keys.

Can a damaged Excel file cause Paste Special errors in Word?

Yes. If the Excel spreadsheet contains corrupted data, unsupported complex formatting, or broken workbook references, Word may fail to retrieve the requested data required to complete the Paste Special operation.

How do I repair my Office installation to fix linking errors?

You can repair Office by opening the Windows Control Panel, navigating to Programs and Features, selecting your Microsoft Office suite, clicking Change, and choosing the Quick Repair or Online Repair option.

Document & File Issues