File Format & Compatibility

How to Fix Cannot Insert Object Error When Adding PDF to Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user is encountering a 'Cannot insert object' error when attempting to embed a PDF file into a Microsoft Excel spreadsheet.

Product: Microsoft Excel
Device & OS: Windows 11
Scenario: Inserting or embedding a PDF document into an Excel workbook.
Observed behavior: Excel displays a 'Cannot insert object' error message instead of successfully embedding the PDF file.

Before you start

Ensure that the PDF file you are trying to insert is completely closed in all other applications, as an open PDF reader can lock the file and prevent Excel from importing it.

Solution 1Recommended

Verify PDF Integrity and Close Open Files

Ensure the PDF is functioning properly and is not locked by another application running on your computer.

Close the PDF

Check your taskbar and close any PDF reader (like Adobe Acrobat or WPS Office) that currently has the target PDF file open.

Test outside Excel

Double-click the PDF file on your desktop or file explorer to confirm it opens normally and is not corrupted.

Re-insert into Excel

Open Excel, go to the 'Insert' tab, click 'Text' > 'Object', and try inserting the PDF again.

Solution 2

Test with a Smaller Alternative PDF

Determine if the issue is caused by the original PDF being too large or too complex for Excel to embed.

Solution 3

Repair Microsoft 365 and Check Updates

Fix corrupted Office installations or compatibility issues caused by recent Windows updates.

Insert PDFs Seamlessly with WPS Office

How to Insert a PDF into a Spreadsheet Using WPS Office

WPS Office provides a seamless, all-in-one platform where you can easily insert PDF files into your spreadsheets without encountering the typical OLE object errors found in other software.

1. Open your spreadsheet in WPS Office: Launch WPS Office and open your .xlsx file in the WPS Spreadsheet application.
2. Navigate to the Insert tab: Click on the 'Insert' tab located in the top ribbon menu.
3. Insert the PDF object: Click on 'Object', select 'Create from file', browse for your PDF document on your local drive, and click 'OK'.

Highly compatible with Microsoft Excel (.xlsx) formatsBuilt-in PDF reader prevents external application conflictsLightweight design ensures smooth file embeddingFree to use with an intuitive, familiar interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say 'Cannot insert object' when adding a PDF?

This usually happens if the PDF is currently open in another program, is corrupted, or exceeds the file size and complexity limits for Excel's Object Linking and Embedding (OLE) feature.

How do I compress a PDF before inserting it into Excel?

You can use an online PDF compressor or a desktop tool like WPS Office to reduce the file size. Once compressed, save the file locally and try inserting the smaller PDF file via the Insert > Object menu.

Can a Windows update cause Excel object insertion errors?

Yes, occasionally Windows updates or Office updates can corrupt system files or OLE registry keys. Running an Online Repair for Microsoft 365 from your Windows settings often resolves these compatibility issues.

What is the alternative to embedding a PDF directly in Excel?

Instead of embedding the entire object, you can upload the PDF to a cloud storage service like OneDrive or Google Drive, and insert a hyperlink to the file directly into an Excel cell.