Fixed Cannot Insert Object Error in Excel 2016 | Step-by-Step Guide

Fixed “Cannot Insert Object” Error in Excel | Step-by-Step Guide

Summary: The error “cannot insert object” in MS Excel can prevent you from modifying objects in the worksheet. This blog will discuss the primary reasons behind this error and the possible solutions to fix it. You will also learn about a professional Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.

Many users have reported encountering the “cannot insert object” error while adding/embedding objects into the Excel file. It usually occurs when using Object Linking and Embedding (OLE) to add content (PDF, Microsoft documents) from external applications to worksheet. The error can also occur when using ActiveX control in Excel. Below, we’ll explain why you cannot insert object into Excel sheet and how to troubleshoot the issue.

Why the “Cannot Insert Object” Error Occurs?

Macro Settings can prevent the insertion of objects into a workbook.
The Excel file in which you are trying to add an element is corrupted.
The object (you are inserting into the workbook) is damaged.
Object size limitations.
System’s insufficient memory might prevent new objects’ addition.
Incompatible Excel file format.
Add-ins controls are disabled.
Incompatible or faulty Add-ins.
Issue with Security Settings.

Methods to Fix the “Cannot Insert Object” Error in Excel

You may encounter the “Cannot insert object” error when trying to add an element stored on a network. It can occur due to issues with the file link, such as incorrect file location. In such a case, you can check the link by selecting the link to file option from the Insert tab.

Sometimes, the error can occur if the file in which you are trying to insert the object is locked and password-protected. In this case, you can unprotect the Excel file . If the issue still persists, then you can follow the below methods.

Method 1: Check and Change Restricted Security Settings

Excel provides security settings to protect your workbook. Sometimes, these settings can prevent inserting objects in the file. You can change the security settings to allow Excel to insert objects. To do so, follow these steps:

Open your Excel application.
Locate the File and then click Options.
In Excel Options, click Trust Center.

Click Trust Center Settings.
In the Trust Center Settings window, select Protected View from the left pane.

Under Protected View, unselect the below three options:
Enable Protected View for files originating from the internet.
Enable Protected View for files located in potentially unsafe locations.
Enable Protected View for Outlook attachments.

Click OK.
Once you’re done with this, click on Macro Settings in the Trust Center window.
Under Macro Settings, make sure “Disable all macros without notification” is not selected. If it is selected, then unselect it. After that, click OK.

Restart Excel to apply the changes.

Method 2: Uninstall Microsoft Office Updates

You can also encounter the “Cannot insert object” error in Excel after installing MS Office updates. It might be due to the issues with the installed updates. To fix this, you can uninstall the recently installed Office updates. To uninstall the Office updates, follow these steps:

Go to the system’s Control Panel.
Click Programs and then click Program and Features.
Search for “View Installed Updates” and click on the desired Office updates.
Right-click on it and then click Uninstall.
Follow the uninstallation steps on the screen.
Once the process is complete, restart the system.

Method 3: Check Memory Usage

The “Cannot insert object” issue can also occur if your system is low on memory. You can check and close unnecessary processes and applications running in the background to free up memory. To do so, follow these steps:

Press CTRL + ALT + DEL on the keyboard and click Task Manager.
Click on the Processes tab and search for any unnecessary processes.
Right-click on the process and then select End Task.
Restart Excel to see if the issue is fixed.

Method 4: Check Excel File Size

If your Excel file size exceeds the prescribed limit, it can also lead to the “Cannot insert Excel object” error. So, check the Excel file size. You can reduce the file size by removing unnecessary objects, such as formulas or images.

Method 5: Check and Change Excel ActiveX Settings

You can get the “Excel cannot insert object” error if your Excel file contains macros, controls, and other interactive buttons. It usually occurs if the ActiveX Controls option is disabled. You can check and change the ActiveX Settings to fix the issue. Here are the steps:

Open your Excel application.
Navigate to File and then click Options.
In Excel Options, click the Trust Center tab.
In the Trust Center Settings, click ActiveX Settings.
Under ActiveX Settings, make sure the “Enable all controls without restrictions and without prompting” option is selected.

If the option is not selected, then select it and click OK.
Restart the Excel and check if the error is fixed or not.

Method 6: Repair the Excel Workbook

The “Cannot insert object” error can occur if the object you are trying to insert is corrupted or the file in which you are inserting the object is damaged. If the issue has occurred due to a corrupted Excel file, then you can repair the file using the Open and Repair utility in MS Excel. To use this Microsoft-inbuilt utility, follow these steps:

In the Excel application, go to the File tab and then click Open.
Click Browse to choose the affected file.
The Open dialog box is displayed. Click on the corrupted file.
Click on the arrow next to the Open button and then click Open and Repair.
Click on Repair.

After repair, a message will appear (as shown in the below figure).

Click Close.

If the Open and Repair utility fails to fix the issue, then try a professional Excel Repair software, like Stellar Repair for Excel. It is designed to repair severely corrupted Excel files. It can restore all the Excel file objects, such as tables, charts, formulas, etc. It helps fix all types of corruption related errors. The software is compatible with all versions of Excel.

Conclusion

You might encounter the “Cannot insert object” error when embedding or inserting objects in Excel. In this post, we have discussed the possible solutions to fix this error. We have also mentioned an Excel repair software that can help to easily repair the corrupted Excel file and recover all the data. You can download the Stellar Repair for Excel’s free demo version to preview the recoverable objects of the corrupted Excel file.

Recover Excel Files from Virus-Infected Pen Drives for Free

Summary: Imagine you lost your important Excel file on which you had been working since the morning and in the next moment you realized that the file was not saved and you just lost hours of work. Wondering how to deal with this situation? Read this blog to know how Stellar free data recovery software can help you.

From making annual reports to business growth representation figures, excel is a commonly used program for organizing data, creating pivot tables, charts etc. People from all walks of life, know the importance of Excel and the part it plays. Although it is a common file, there is a probability that you may accidentally delete excel files while working or are unable to access it due to unexpected errors. In addition, one of the major issues users face is to recover excel files from a virus infected pen drive.

Pen drives have made it possible to store and carry our important files such as excel, word document, photos, videos, etc. with us day in and day out. They just fit perfectly in our pockets and are compatible with almost every device; hence, they are widely used for transferring data from one system to another. But what if your pen drive is infected by a virus and due to it you end up losing your excel files, how will you recover your excel files for free?

A user reported that his pen drive got virus-infected and to remove the virus from it, he ran an antivirus program which removed the virus but also deleted excel files stored on it.

When your pen drive is infected by a virus, the first thing you ought to do is stop using it, even not for removing virus as an antivirus utility may remove your files as well. Further, if you have a backup, then you can recover your excel files from it, else you can use these free data recovery methods to recover your excel files.

1. Free File Recovery Software Approach

Stellar Windows Data Recovery – Free Edition is an easy to use tool to recover files from a virus-infected pen drive. The software is equipped with powerful utilities to recover lost and deleted files for free. Further, it supports a wide range of file systems and is efficient in recovering files such as Excel, emails, word files, photos, audio and video files.

Using Stellar Windows Data Recovery – Free Edition, you can recover your files from all storage devices for free. Here’s how the software works:

From the website, download Stellar Windows Data Recovery – Free Edition. Connect your pen drive to your system and launch the software
On ‘Select What to Recover’ screen, select file types from the given option that you wish to recover. For instance, if you want to recover photos, then under Multimedia Files, select ‘Photos’ and click on ‘Next’

From ‘Select Location’ screen, select the connected pen drive and click ‘Scan’

The scanning process starts and once the process is complete, software lists all the recoverable files

Select the files from the list and click on ‘Recover’ to save the files

2. Restore Excel File from the Previous Version

If excel files are deleted from your pen drive or from your system; then you can recover them from the previous version. This feature works when Windows Backup option is enabled, else, it will not work.

Follow these steps to recover excel files:

Connect your pen drive to your system, go to This PC and navigate to the folder of excel files
Select the folder, right-click on it and select ‘Restore previous versions’
From the available version of excel files, select the required one and click on ‘Restore’

3. Use Command Line to Recover Excel Files

The Command prompt should be your first choice to recover excel files from the virus-infected pen drive. Here’s how command prompt recovers your files:

Connect your virus-infected pen drive to your system and then in the search box type ‘CMD’ and hit ‘Enter’
In the command window, type in attrib –h-r-s /s/ drive letter:\*.*”, for example, “attrib -h -r -s /s /d G:\*.*” and hit ‘Enter’

Windows starts repairing the virus-infected pen drive and once the process is complete, you can access your pen drive and recover excel files.

Even after following the above-mentioned steps you’re unable to recover your excel files, then try a Home approach i.e. a data recovery tool.

To Sum Up

It is always a good idea to create a backup of important files since no one can anticipate what might go wrong. The scenario presented in the blog paints a clear picture of how you can recover your Microsoft excel files for free from a virus-infected pen drive. For quick and better results, you can always go with Stellar Windows Data Recovery – Free Edition.

How to fix Pivot Table Field Name is not Valid error in Excel?

The Pivot Table field name is not valid error can occur while creating, modifying, or refreshing data fields in the pivot table. It can also appear when using VBA code to modify the pivot table. It usually occurs when there is an issue with the field name in a code or if there is a hidden or empty column in the pivot table. However, there could be many other reasons behind this error.

Why the “Pivot Table Field Name is not Valid” Error Occurs?

You can get the “Pivot Table field name not valid” error in Excel due to several reasons. Some possible causes are:

Excel file is corrupted
Damaged fields in the pivot table
Pivot table is corrupted/damaged
Hidden columns in the pivot table
Macro (referring to the pivot table) is corrupted
Preserve formatting option is enabled
Missing or incorrect fields in the VBA code
Issue with workbook.RefreshAll method syntax (if using)
Pivot Table contains empty columns
Header values or header column is missing in the Pivot Table
Pivot table is created without headers
Columns/rows are deleted from the Pivot Table

Methods to Fix Pivot Table Field Name is not Valid Error in Excel

You can get this error if you have selected the complete data sheet and then trying to create the Pivot Table. Make sure you choose only the data fields that you want to insert in the Pivot Table. If this is not the case, then follow the troubleshooting methods mentioned below.

Method 1: Check the Header Value in the Pivot Table

The “Pivot table field name is not valid” error can occur if you have not set up the pivot table correctly. All the columns having data in them should have header and header values. A pivot table without a header value can create issues. You can check the header and its value from the Formula bar. Change the header if the header value is too lengthy or if it contains special characters.

Method 2: Check and Change the Data Range in the Pivot Table

The “Pivot Table field name is not valid” can occur while modifying a field in Pivot Table. It usually occurs if you’re trying to add or modify the field by selecting an incorrect data range in the Create PivotTable dialog box. The “Create PivotTable“ feature helps define how data would be displayed within the pivot table.

Let’s take a scenario to understand this. Open the Excel file with PivotTable. Click on the fields (you want to add), go to the Insert option, and click PivotTable.

If you select an incorrect range, i.e. A1:E18, instead of correct range - “Expenses**!$A$3:Expenses!$A$4**,” you will immediately get the error message.

So, type the correct range under the Select a table or range option and click OK.

Method 3: Unhide Excel Columns/Rows

The error can also occur if some columns/rows of the Pivot Table’s data source are hidden. When you try to add a hidden column as a field in the PivotTable, the Excel application will fail to read the data of the hidden column. You can check and unhide the Excel columns by following these steps:

Open the Excel file.
Locate the hidden column number.
Move your cursor on the hidden column number and right-click on the space between the columns. Click Unhide.

Method 4: Check and Delete Empty Excel Columns

Sometimes, you can get the “Pivot Table field name is not valid” error if you are trying to use an empty column as a field in your Pivot Table. Check the columns with no values in all cells. If found, then delete the empty columns. This method is ideal for small-size Excel files. However, for large-sized files, it is a time-consuming process.

Method 5: Unmerge the Column Header (If Merged)

The “Pivot Table field name is not valid” error can also occur due to merged column headers. The pivot table references headers to identify the data inside the rows or columns. The merged headers can sometimes create data inconsistencies. You can try unmerging the column headers to fix the issue. Follow these steps:

In the Excel file, go to the Home
Click the Merge & Center option and select Unmerge Cells from the dropdown.

Method 6: Disable the Background Refresh Option

If the “background refresh” option in the Excel file is enabled, it may also create issues with Pivot Table. The Excel updates all the pivot tables in the background even after a small change if the background refresh option is enabled. This may create issues if the Excel file is large with too many tables. You can try turning off the “background refresh” option in the Excel file to troubleshoot the issue. Here is how to do so:

In the Excel file, go to the Data tab and then click Connections.
In the Workbook Connectionsdialog box, click on the ‘Add’ dropdown to add the workbook (in which you need to modify the refresh settings).
Once you have chosen the Excel file, click Properties.
In the Connection Properties window, unselect the **”Enable background refresh”**option, select the “Refresh data when opening the file“, and click **OK.

**

Method 7: Check the VBA Code

The error can also occur when working with PivotTable using VBA code in Excel. Some Excel users reported this error on forums as run-time error 1004: The PivotTable field name is not valid. This error usually occurs when there are issues in the VBA code, affecting the PivotTable data source or field references. You can check field names referring to PivotTable or Workbook.RefreshAll function syntax and other errors in the code.

Method 8: Repair your Excel File

One of the reasons behind the “Pivot Table field name is not valid” error is corruption in the Excel file, containing the Pivot Table. You can repair your Excel file using Microsoft built-in utility - Open and Repair. Here’s how to use this utility:

In Excel, navigate to File > Open.
Click Browse to choose the affected workbook.
The Open dialog box will appear. Click on the corrupted file.
Click the arrow next to the Openbutton and then select Open and Repair.
You will see a dialog box with three buttons - Repair, Extract Data, and Cancel.
Click on the Repair button to recover as much of the data as possible.
After repair, a message is displayed. Click Close.

Method 9: Use a Professional Excel Repair Tool

If the Excel file is heavily damaged or corrupted, then the “Open and Repair” utility may not work or provide the intended results. In such a case, you can opt for a professional Excel repair tool. Stellar Repair for Excel is an advanced Excel file repair tool, which is highly recommended by experts. It can repair severely corrupted Excel files and restore all the data from corrupt file, including pivot tables. This tool comes with a user-friendly interface that even a non-technical user can use. You can try the software’s demo version to check how it works. The software is fully compatible with all Excel versions, including Excel 2019.

Conclusion

The Excel error “Pivot Table field name is not valid” can occur due to hidden or merged column/row headers, empty columns/rows, corrupted pivot table, and various other reasons. You can try the methods mentioned above to fix the error. If this error has occurred due to corruption in the Excel file, then you can use Stellar Repair for Excel - an advanced tool to repair corrupted pivot table, macros, fields, or other elements in an Excel file. It is compatible with all Windows editions, including the latest Windows 11. It can help fix the error if the data source or Pivot table configuration is affected by corruption.

How to Repair Corrupt Pivot Table of MS Excel File?

Summary: If you are not able to perform any action on the Pivot Table of MS Excel file, it indicates Excel Pivot Table corruption. In such a case, you must repair the corrupt Pivot Table of MS Excel file by using an Excel repair software or manual troubleshooting steps discussed in this post.

MS Excel is equipped with several brilliant features and functions which make working with large volumes of data easy. In addition to helping users save data into well-organized cells and tables, the application helps users draw inferences from the data. Pivot Table is one such Excel feature that helps users extract the gist from a large number of rowed data. But often, the Pivot table may get corrupted and lead to unexpected errors or data loss.

Corrupt Pivot Tables can stop users from reopening previously saved Excel workbooks, raising the serious issue of data inaccessibility. Resolving such issues is an uphill task unless one gets to the actual root cause of the problem.

However, with Stellar Repair for Excel software, you can repair the corrupt Pivot table of MS Excel file while keeping the Excel file data, formatting, layout, etc. intact.

Excel Pivot Tables & Associated Problems

Pivot Tables in Microsoft Excel are created by applying an operation such as sorting, averaging, or summing to the data in certain tables. The results of the operation are saved as summarized data in other tables. Typically, working on the grouping of saved data, Pivot Tables are used in data processing and are found in data visualization programs, such as spreadsheets or business intelligence software.

Put simply, Pivot Tables in Excel allow you to extract the significance or the gist from a large, detailed data set by allowing you to slice-and-dice data, sort-and-filter data, or arrange it in any way you want.

Frequently Encountered Problems with Pivot Tables in MS Excel

Take a look at the most frequently encountered Pivot Table issues:

You add new data into a pivot table but it doesn’t show up when you refresh
Pivot Table contains Blanks instead of Zeros for fields that have no source data
Automatic field names assigned by the Pivot Table can be inappropriate
It doesn’t directly show the percentage of total
Grouping one pivot table affects another
Your number of formatting gets lost
Refreshing a pivot table messes up column widths
Field headings make no sense and add clutter

While some of the above problems seem minute and can easily be resolved using a few tweaks, bigger issues like unexpected Pivot Table error messages that an Excel throws can be troublesome.

Pivot Table Errors & Their Reasons

Excel users who have built new Pivot Tables in Excel often report the following errors when trying to reopen a previously saved workbook:

We found a problem with some content in . Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Naturally, users are prompted to click on ‘Yes’. But when they do, they get another error message saying:

Removed Part: /xl/pivotCache/pivotCacheDefinition1.xml part with XML error

(PivotTable cache) Load error. Line 2, column 0

Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)

Such errors are indicative of the fact that the data within the Pivot Table still exists, but the table itself isn’t functioning anymore.

There could be two primary reasons behind such behavior:

You’ve created the Pivot Table in an older version of Excel but are trying to open-refresh-save it through a newer Excel version
The Pivot Table itself is corrupted

How to Repair the Pivot Table Quickly?

To solve the errors associated with Pivot Tables, you need to repair them. But Microsoft doesn’t offer any inbuilt technique or option to repair Pivot Tables. Thus, to fix the issue, you either need some sort of workaround or an Excel file repair software .

Methods to Fix Corrupt Pivot Table in MS Excel

Though there aren’t many options to fix the Pivot Table, you can follow these workarounds to try and repair a corrupt Pivot Table of MS Excel. However, before following these steps, create a backup copy of your Excel file.

Method 1: Open MS Excel in Safe Mode

First, try opening the Excel file in safe mode and then check if you can access the Pivot Table. If you can, save all its contents to a new Pivot Table in the latest version of Excel so that this problem doesn’t arise anymore.

Method 2: Use Pivot Table Options

If, however, above method doesn’t work, follow the below-mentioned steps:

Right-click on the Pivot Table and click on Pivot Table Options
On the Display tab, clear the checkbox labeled “Show Properties in ToolTips”
Save the file (.xls, .xlsx) with the new settings intact

Method 3: Make Changes to Pivot Table

If the above method or steps didn’t work,

Try opening the Pivot Table Options window by right-clicking on the Pivot Table within your Excel file
Select Pivot Table Options from the pop-up menu and make appropriate changes to the options given there
Then check if the issues go away

Method 4: Check and Set Data Source

If the problem in the Pivot table is related to data refresh,

Go to Analyze > Change Data Source
Check if the data source is set properly
Also, try reselecting the data source and check if the refresh option is working properly

If not, resorting to Stellar Repair for Excel software might be your only hope.

Excel Pivot Table Repair by Using Excel Repair Software

When corruption strikes an Excel Pivot Table and no manual trick work, Stellar Repair for Excel is the best solution. This easy-to-use Excel Repair software repairs even the most severely corrupted Excel (XLS/XLSX) files to restore all data, properties, formatting, and preferences. It enables users to extract their saved data into new blank Excel files.

If you have this utility by your side, you don’t need to think twice about any Excel error.

What customer says about the Excel Repair Software?

Spiceworks

CNET

Conclusion

Excel Pivot Table corruption may occur due to any unexpected errors or reasons. This can lead to inaccurate observation in data analysis and also cause data loss if not fixed quickly. However, you can prevent data loss due to problems caused by Pivot Table corruption by keeping a backup of all your critical Excel files and fix the Pivot Table corruption by using proper tools, such as Excel file repair software, that can help you get over any Excel corruption and errors quickly.

How to Fix “Errors were detected while saving Excel” Error?

When trying to save the Excel file, you might face unexpected errors. The “Errors were detected while saving Excel” is one such error. It can also occur when using VBA in Excel. The complete error message appears as:

**“Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.”
**

The error can occur if the features (Pivot tables, charts, macros) used in the Excel file get corrupted . However, there could be several other reasons behind the occurrence of the error. Let’s discuss them.

What Causes the “Errors were detected while saving Excel” Error?

There are various reasons why you encounter this error. Here are some of them:

Incompatible pivot table in the Excel file
Large or uncompressed images in the Excel file
File-sharing properties are not allowing file saving
Excel file is corrupted
Large-sized Excel file
File version incompatibility
VBA code is corrupted

Ways to Fix the “Errors were detected while saving Excel” Error

You’re not able to save the Excel file if there is no storage space on your hard drive. So, first check if your hard drive has sufficient storage space to save the file. If this is not the case, then it might happen that your antivirus program is interrupting the saving process. To check this, temporarily disable your antivirus program and then try to save the file. If still your Excel is throwing the “Errors were detected while saving Excel” error, then follow the below given methods to fix the error:

Method 1: Open the Excel in Safe Mode and Disable the Add-ins

When you open Excel in safe mode, it opens without the third-party add-ins. This helps in finding out if any add-ins are causing the error.

Here’s how to open the Excel in safe mode:

Open the Run window by pressing Windows key + R.
Type excel /safe in the Run window.

?
Next, click on OK.
It will open Excel in safe mode.
Now, try to open and save the affected file.

If you are able to save the file without any issue, then this means that the error has occurred due to third-party add-ins or settings. You can try disabling the add-ins to fix the issue. To do this, follow these steps:

First, open Excel.
Then, go to the File tab and click Options.

In Excel Options, click on the Add-ins

Under the Manage section, select Excel Add-ins and then click on the Go

In the Add-ins dialog box, unselect the add-ins under the Add-ins available option and click OK.

Note: Disabling add-ins does not remove them from the system. To remove them permanently, you need to uninstall them.

Method 2: Check the Excel File Name

Some users have observed this error when saving the Excel file with an invalid name. You can check the file name and ensure that it should not contain more than 218 characters. If the name exceeds the required limit, then try shortening the file name or move the file to a folder with a short path name.

Method 3: Copy the Data from the Affected File to a New File

If you are not able to save the Excel document, then try copying the data from the affected file to a new Excel file. Then, save the new file with a different name. This helps in resolving the issue.

Method 4: Check and Provide File Permissions

You may experience the “Errors were detected while saving Excel” issue when you do not have desired permissions to modify the folder in which your Excel file is located. To modify the folder, you should have read, write, and create permissions. You can check and provide the desired permissions using the below steps:

Navigate to the Windows Program Files and then find the desired folder (where the Excel file is saved).
Right-click on the folder and then choose Properties.
Select the Security tab and then click
Click on Change Permissions in the Advanced Settings
Click Administrators and then click Edit.
Now set the Apply to drop-down button to This Folder, Subfolder, and Files.
Click on the Full Control field and then click Apply > OK.

Method 5: Check Pivot Tables in Excel Sheet

You can review Pivot tables to see if they are causing the “Errors were detected while saving Excel” error. To do so, follow the below steps:

Click Power Pivot > Manage.
Check the tabs in the Power Pivot
Check if all the formulas used in the table are correct. Sometimes, even a small typo can create an issue in Excel.

Method 6: Repair Your Excel File

The “Errors were detected while saving Excel” issue can also occur if the Excel file is corrupted. In such a case, you can take the help of the built-in utility in Excel – Open and Repair to repair your Excel file. Here’s how to use the tool:

In Excel, click the File tab and then click Open.
Click Browse to select the desired file.
The Open dialog box is displayed. Click on the corrupted file.
Click on the arrow next to the Open button and then click Open and Repair.
Click on the Repair

After repair, a message will appear (as shown in the below figure).
Click Close.

However, sometimes, the Open and Repair utility fails to fix the file if it is severely corrupted or large-sized. In such a case, you can take the help of a third-party Excel repair software, such as Stellar Repair for Excel. The tool performs a comprehensive scan of the corrupted Excel file to fix the issues and recover all the items from the file without changing the original formatting. It can recover pivot tables, charts, images, engineering formulas, etc. The tool is compatible with Windows 11/10/8.1/8/7. You can download the free trial version of the tool to evaluate its functionality.

Closure

Many Excel users reported facing the situation when they are saving the Excel file. You can check the file’s compatibility to fix the “Errors were detected while saving Excel” issue. If you are getting this error in a Macro-enabled file then you can try deleting the VBA project from a document to resolve the issue. However, deleting the entire VBA code cannot be a better solution as it can lead a data loss in the Project you are working on. In the above article, you have learned the reasons behind the issue and discovered how to fix the error. Follow the methods and if none of them works then try using Stellar Repair for Excel. It is an advanced tool that can quickly repair corruption in Excel worksheets at any level. It lets you restore the corrupted components from the corrupted file without removing the existing data.

Fixed “Cannot Insert Object” Error in Excel | Step-by-Step Guide

Why the “Cannot Insert Object” Error Occurs?

Macro Settings can prevent the insertion of objects into a workbook.
The Excel file in which you are trying to add an element is corrupted.
The object (you are inserting into the workbook) is damaged.
Object size limitations.
System’s insufficient memory might prevent new objects’ addition.
Incompatible Excel file format.
Add-ins controls are disabled.
Incompatible or faulty Add-ins.
Issue with Security Settings.

Methods to Fix the “Cannot Insert Object” Error in Excel

Method 1: Check and Change Restricted Security Settings

Open your Excel application.
Locate the File and then click Options.
In Excel Options, click Trust Center.

Click Trust Center Settings.
In the Trust Center Settings window, select Protected View from the left pane.

Under Protected View, unselect the below three options:
Enable Protected View for files originating from the internet.
Enable Protected View for files located in potentially unsafe locations.
Enable Protected View for Outlook attachments.

Click OK.
Once you’re done with this, click on Macro Settings in the Trust Center window.
Under Macro Settings, make sure “Disable all macros without notification” is not selected. If it is selected, then unselect it. After that, click OK.

Restart Excel to apply the changes.