Fix Excel's Cannot Use Object Linking and Embedding Error When Pasting
Question details
The user needs to resolve an Excel object linking and embedding error that appears when pasting data into a workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting data into an Excel workbook.
- Observed behavior
- Excel displays a Cannot use object linking and embedding error.
Note where the copied data comes from and whether it includes an embedded or linked object. The troubleshooting steps below apply to Excel on Windows.
Check Excel Add-ins in Safe Mode
Use Safe Mode to check whether an add-in is contributing to the paste error.
Close Excel, press Windows+R, enter excel /safe, and select OK.
Open the affected workbook in Excel and try the same copy-and-paste action.
If pasting works in Safe Mode, reopen Excel normally and go to File > Options > Add-ins. Select COM Add-ins in the Manage list and click Go.
Clear the add-in checkboxes, click OK, and restart Excel. Test pasting, then re-enable add-ins one at a time to identify any that trigger the error.

Repair Microsoft Office on Windows
Repair the Office installation if the error continues after checking add-ins.
Work With Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its support for Excel formats makes it easy to move everyday workbook tasks to WPS; it does not repair Microsoft Excel's OLE error.

Frequently Asked Questions
What does the Excel OLE error mean?
OLE stands for Object Linking and Embedding. The message indicates Excel could not use an OLE operation; it does not identify the cause by itself.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Open the workbook and retry the paste.
Where can I disable Excel add-ins?
In Excel, go to File > Options > Add-ins. Choose COM Add-ins from the Manage list, click Go, and clear the checkboxes for the add-ins you want to test.
Will WPS Office fix the OLE error in Microsoft Excel?
No. WPS Office is an alternative for working with compatible XLSX and XLS files; it does not repair Excel. Test any linked or embedded objects you need, since compatibility can vary.




