[Fixed] Excel Found a Problem with One or more Formula

Summary: The error ‘Excel found a problem with one or more formula references in this worksheet’ may appear while saving the Excel workbook. It occurs when Excel found a problem with the formula used in the sheet. However, it may also occur when the Excel workbook gets damaged or corrupt. In this guide, we’ve explained the reasons that may lead to this Excel error and methods to resolve the error, by using various Excel options and a third-party Excel file repair software.

If you are experiencing the ‘Excel found a problem with one or more formula references in this worksheet’ error message in the Excel workbook, it indicates that the Excel file is corrupt or partially damaged. However, it may also occur due to incorrect reference to a wrong cell or object linking, which is not working. The complete error message says,

‘Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.’

In any case, resolving the error is critical as it doesn’t let you save the file and may result in loss of information from the Excel workbook.

Reasons for Excel Formula References Error

A few reasons that may lead to such error are as follows,

• Wrong formula or reference cell
• Incorrect object linking or link embedding OLE
• Empty or no values in named or range cells
• Multiple Excel files (not common)

Methods to Resolve ‘Excel Found a Problem with One or More Formula References in this Worksheet’ Error

Following are a few methods that you can follow to fix Excel file that can’t be saved due to problems with one or more formula references in the worksheet.

Method 1: Check Formulas

If the problem has occurred in a large Excel workbook with multiple sheets, it’s quite hard to pinpoint the problem cell. In such cases, you can use the Error Checking option that runs a scan and checks for a problem with formulas used in the worksheet.

To run Error Checking in the Excel sheet, follow these steps,

• Go to Formulas and click on the ‘Error Checking’ button

• This runs a scan on the sheet and displays the issues, if any. If no issue is found, it displays the following message,

The error check is completed for the entire sheet.

In such a case, you can try saving the Excel file again. If the error message persists, proceed to the next method.

Method 2: Check Individual Sheet

The problem may also occur due to an issue with one of the sheets in the workbook. To find the faulty sheet and fix the problem, you can copy each sheet content in a new Excel file and then try to save the Excel file.

This will help you find the faulty sheet from the workbook that you can review. This method makes the entire process of troubleshooting Excel formula reference error quite easy and convenient.

In case the error is not fixed, you can back up the faulty sheet content and remove it from the workbook to save the Excel file.

Method 3: Check Links

When the Excel file contains external links with errors, MS Excel may display such error messages. To check and confirm if external links are causing the error, follow these steps,

• Navigate to Data Tab > Queries & Connections > Edit Links
• Check the links. If you find any faulty link, remove it and then save the sheet

Method 4: Review Charts

You can review the charts to check if they are causing the formula reference error in Excel. It may take a while based on the size of the Excel file. Sometimes, it’s not practically possible to track down which Excel chart object is causing the error. Thus, you need to check specific locations, such as:

1. Check horizontal axis formula inside Select Data Source dialog box
2. Check Secondary Axis
3. Check linked Data Labels, Axis Labels, or Chart Title

Method 5: Check Pivot Tables

To check Pivot Tables, follow these steps,

• Navigate to PivotTable Tools > Analyze > Change Data Source > Change Data Source…

• Check if any of the formula used is problematic. Sometimes small typo, such as misplaced comma, can lead to such problems in Excel. Thus, check each formula thoroughly and correct the formulas wherever needed.

Method 6: Use Excel Repair Software

When none of the methods resolve the error, then you can rely on advanced Excel repair software , such as Stellar Repair for Excel. It’s a powerful tool that is recommended by several MVPs and IT administrators for resolving common Excel errors, such as ‘Excel found a problem with one or more formula references in this worksheet.’

It repairs corrupt or damaged Excel (.xls/.xlsx) files, recovers Pivot tables, charts, etc., and save them in a new Excel worksheet. It helps Excel users, facing formula reference error, restore their Excel file without any risk of data loss, while preserving the sheet properties and formatting with 100% precision.

Conclusion

Although the error ‘Excel found a problem with one or more formula references in this worksheet’ can be resolved by using various options in MS Excel, it may lead to a partial loss of information. Thus, you must perform these operations after taking a backup of the Excel worksheet. Also, if the MS Excel options fail to resolve the problem, you can use an Excel file repair software, such as Stellar Repair for Excel. The software helps fix Excel file corruption and restores the information and data from corrupt or damaged Excel files (.xls/.xlsx) to a new worksheet.

4 Ways to extract data from corrupt Excel file

Summary: Excel files can become corrupt due to numerous reasons. This blog will discuss the reasons behind the corrupted Excel files. Sometimes the file becomes inaccessible. This post includes four ways to extract data from a corrupt Excel file. It also mentioned Stellar Repair for Excel to repair severely corrupted files. The tool helps you recover data from damaged Excel files with complete integrity.

Imagine the frustration of an employee if an Excel workbook he took hours to complete became corrupted for some reason threatening to erase all the data saved in it. Not just that, a corrupted Excel workbook can wreak havoc for the organization too since it poses a risk of permanently deleting critical business information like work records or employee trackers.

Unless a backup of all important Excel files exists, recovering data lost due to damage/corruption to them is next to impossible. However, we’ve conducted some research and found some pretty neat hacks to help you extract data from corrupt excel files without much hassle.

Primary reasons triggering Excel file corruption

As we always point out, to solve a problem for good, getting to its root is imperative. Here are the main reasons that cause Excel file corruption. Knowing these reasons can help you keep Excel corruption at bay for a considerably long time.

• Abrupt system shutdown when you’re editing an Excel sheet
• Bugs / Defects in your Excel application or installation
• Hardware failures like bad sectors on the hard drive where Excel sheets are saved
• Virus Infection / Malware Attack
• Excessive data storage within a single Excel file
• Faulty Excel Macros and CSE Formulas

Depending upon the extent of damage, there can be several ways to perform corrupt Excel file repair.

How to repair corrupt Excel files?

There are a couple of manual methods that can help you repair corrupt Excel files .

1. If the damaged Excel sheet can be opened, immediately save its copy; thereafter:
   • Open it with a later version of Excel and save it as a new workbook.
   • If this doesn’t work, open it in Excel’s latest version and save the workbook in HTML or HTM format.
   • Once this is done, reopen the HTML file and save again in XLS format.
   • Lastly, open the file and try saving it in SLK format (symbolic link)

Note: It is important to note that saving an Excel workbook in HTML format causes loss of features like custom views, scenarios, unused styles or number formats, natural language formulas, data consolidation settings, custom function categories, etc. In SYLK format only the active worksheet is saved so if using this method, you’ll need to repeat these steps for each worksheet.

2. Use Excel’s inbuilt Repair function as follows:
   • Launch Microsoft Excel and go to Office button -> Open
   • In the Open dialog box, select the damaged Excel file
   • On the bottom-right corner of the Open dialog box, you will find a drop-down next to Open Click on it and select Open and Repair
   • This will launch the inbuilt Repair module of Excel and you’ll see a dialog box asking you to select an option from Repair or Extract Data
   • Click on Repair to initiate the repair process.
   • If this doesn’t work, repeat steps 1-4, and when Excel asks you to select an option, select Extract Data from corrupt excel file. Thereafter, follow the instruction Excel shows and you should be able to retrieve your data, but you may end up losing some formulas.
3. If you cannot open the Excel, download Spreadsheet viewer from the Microsoft website and open the file using this program. Thereafter copy all data into a new Excel.

Note: This method will cause much of your formatting, formulas, and more to be lost.

4. You can download Open Office from its official website OpenOffice.org and try opening the Excel in it. The two programs are very similar so all data should automatically align in the correct place and with the correct formatting.

Note: With this method, VBA code cannot be recovered due to incompatibility between OpenOffice.org and Excel.

Full-proof method for corrupt Excel file repair

If you find the above methods confusing, or you wish to perform Excel file repair without having to face any data and formula loss, or you cannot achieve the desired results with any of these methods, stop wasting any more time with methods that will only frustrate you more. Instead, download the sure-shot solution for dealing with severe Excel corruption –Stellar Repair for Excel  and relax!

Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files and restoring everything to a new blank Excel file. This competent software can skillfully repair single as well as multiple XLS/XLSX files while preserving worksheet properties and cell formatting. If you have this product by your side, you don’t need to worry about Excel corruption errors ever again.

To Conclude

Instead of giving up on corrupted Excel sheets, try repairing them with the simple tricks we’ve described. And if they don’t work, keep calm and turn to Stellar Repair for Excel.

How to fix Microsoft Excel not responding error and save your data

Summary: This guide helps you resolve Excel not responding and frequent Excel freeze issues in Excel on Windows 10. It mentions some effective solutions to repair Excel and resolve Excel is not responding problem. These solutions will also help you fix Excel crashing problem while working on the spreadsheet.

Similar to any other program, you may experience problems with Microsoft Excel while opening or working on a document. Sometimes, it may not start at all or freeze and display an error message such as ‘Excel is not responding’. When it happens, you may want to wait for the program to respond.

‘Microsoft Excel is not responding’ problem

Tip: If you are experiencing Excel not responding problem with a particular Excel file, it’s quite possible that the file is corrupt or partially damaged. And thus, leading to an Excel freeze or crash problem. Use Stellar Repair for Excel software to quickly repair and restore Excel (.xls/.xlsx) file in its original, intact form. You can download the free trial version of the software from the below link.

But if Excel doesn’t respond after a while and remains stuck, you need to force close the program from “Task Manager”. Now, this could be disastrous if happens while you are working on an important Excel document that took you hours to prepare. Force closing Excel due to such error can damage the Excel document and it may fail to open next time.

Why Excel is Not Responding?

Excel may stop responding, freeze, or crash suddenly due to several reasons. It can happen while saving a spreadsheet or opening an Excel document. It may also occur while editing or inserting images, graphs, etc. But usually, it occurs when the system crashes or shuts down abruptly while you are working on a document. Here’s an instance,

Suppose, you worked overnight on a critical document which is to be presented at a meeting the next day. This Excel spreadsheet includes critical graphs and charts, and much more. When you are about to save it, there is a power failure, and your system shuts down without warning. When the power is up, you restarted the system to check your Excel. To your dismay, a message pops up – “Excel Crashed” or “Microsoft Excel not responding”.

This could be frustrating. However, there is no need to despair as there are solutions to not just overcome this error but other corresponding issues such as Excel freezing, hanging, crashing, etc. Below is an infographic that quickly briefs all the possible solutions to fix Excel not responding error.

Solutions to Fix ‘Microsoft Excel is not responding’ Error

Follow the solutions discussed below in the given order to fix Excel freezing and hanging issues.

Solution 1: Open Excel in Safe Mode

If Excel is not working as intended and frequently stops responding, you may try to start Excel in Safe Mode. It is a common DIY way to fix ‘Excel is not responding’ problem.

In Safe Mode, Excel starts with only essential services, bypasses certain functionalities and doesn’t load the add-ins, which might be the reason behind the error in MS Excel . To open and troubleshoot Excel in Safe Mode:

• Press Windows + R keys, type excel.exe /safe and press ‘Enter’ or click ‘OK’

MS Excel in Safe Mode

Open the Excel file and check if it still crashes. If not, the problem could be a faulty add-in or formatting and styling error.

Proceed to the next solution to check and fix the problem.

Solution 2: Check for Faulty and Unwanted Add-ins

In Microsoft Excel, there are two types of add-ins:

• COM add-ins
• Other Add-ins Installed as XLAM, XLA, or XLL File

Both types of add-ins can cause the freezing problem in Excel . Follow the steps below to disable unwanted and faulty add-ins:

• In Excel , click File and go to Options to open ‘Excel Options’ window
• Click Add-ins button to view and manage ‘Microsoft Office Add-ins’
• Uncheck required add-ins to disable them
• At this stage, you can also click the ‘Remove’ button to remove any unwanted add-ins

Disable COM Add-Ins

• Now enable an add-in and check the Excel performance. Observe Excel for not responding error or freezing problem

If Excel doesn’t freeze, enable subsequent add-in and then again use Excel to observe it. Repeat the steps until you find the faulty plugin, which is causing the problem.

Then remove it from Excel add-ins to resolve the problem.

Solution 3: Install the latest Windows and Office Updates

This problem may also occur if Windows and MS Office are not updated. Therefore, install the latest updates for both Microsoft Windows and Microsoft Office.

You can set the installation and update option to ‘Automatic mode’ in Windows. This will download and install critical updates for MS Office, which might fix the Excel performance issue. The steps to enable automatic updates are as follows:

1. Go to Settings> Update & Security> Windows Update

Enable Automatic Windows updates

• Click Advanced options and enable all the toggle switches to automatically download and install updates for Windows and other Microsoft products

Update Microsoft Products

After update, restart Excel and check if the problem is resolved.

NOTE: From now on, MS Excel will also get the latest update consistently, without the need for manual intervention.

Solution 4:  Check and Disable Anti-virus

Antivirus is important for device safety. However, if your antivirus conflicts with MS Office apps such as Excel, it could lead to Excel freezing and not responding errors.

To check if the problem is due to anti-virus, disable it and reopen the Excel document. Check if Excel performs well or if it still hangs.

Example of Antivirus conflict with Microsoft Excel

If the problem is resolved, contact your antivirus software provider for help to keep antivirus running without affecting the system and other programs such as MS Excel.

Solution 5: Change the ‘Default Printer’

Although it may seem irrelevant, changing the default printer is another easy and effective solution to overcome the error. Reason being, Excel communicates with the printer to find supported margins when we open an Excel sheet.

If Excel doesn’t find the supported margin, it may stop responding or crash. The steps to change the default printer are as follows:

1. Open Control Panel on your Windows system
2. Click Printer and Devices
3. Right-click Microsoft XPS Document Writer to set it to the default printer

Change in Default Printer Setting

Reopen the Excel document to check whether the error occurs or not.

Solution 6: Repair Microsoft Office

A corrupt or damaged Microsoft Office can also cause the ‘Excel is not responding’ problem. You can resolve this by repairing the Microsoft Office files. The steps are as follows:

1. Close all running MS Office programs
2. Go to Control Panel on your Windows system
3. Click Programs and then Programs and Features
4. Select Microsoft Office and in the Microsoft Office window, click ‘Change’
5. Then select the ‘Repair’ option and click ‘Continue’

Repair MS Office

This may take a while. After the repair is done, check your Excel program and file for the error.

Solution 7: Remove and Reinstall Microsoft Office

Sometimes, repairing MS Office may not work. In such a case, removing and reinstalling Microsoft Office can resolve the ‘Excel is not responding’ problem. To do so, follow these steps:

1. Close all running MS Office programs
2. Go to Control Panel on your Windows system
3. Click Programs and then Programs and Features
4. Right-click on Microsoft Office and choose Uninstall

Uninstall MS Office

Then run the MS Office installation setup to re-install MS Office on your system.

Solution 8: Repair Microsoft Excel (XLS/XLSX) file

In several situations, a corrupt or partially damaged Excel (XLS/XLSX) file is the cause of this error. In such a case, you can download and install Stellar Repair for Excel to repair the corrupt or damaged Excel file. By repairing the Excel file, you can resolve the Excel freezing error quickly without applying much efforts.

The steps to use the software for Excel file repair are as follows:

1. Download, install and launch the Excel file repair software
2. Browse and select the corrupt Excel file

• Click ‘Repair’ to start repairing the damaged Excel file
• After file repair, it provides a preview. Check your file

• Then click the ‘Save File’ option in the main menu
• You can either choose default location or browse a new folder location to save the repaired Excel file

• After repair, open the file in Excel and continue with your work

And keep Stellar Repair for Excel installed on your system. You never know when you might need this handy tool.

You may also refer to Microsoft support for more details on Excel not responding, hangs, freezes or stops working issues.

Conclusion

Now that the methods for fixing the ‘Excel is not responding’ error are before you, try all these and see which one works for you. If the cause of this error is a damaged or corrupt Excel file, only repairing the XLS/XLSX file can resolve the issue.

For this purpose, it’s recommended to use a reliable software such as Stellar Repair for Excel as it offers an easy-to-use interface, thereby making Excel file repair process a seamless experience.

The software recovers table, chart, chart sheet, cell comment, number, text, shared formulas, image, formula, sort and filter, and other objects. It also preserves worksheet properties, layout, and cell formatting. It can repair multiple XLS/XLSX files simultaneously and fix all Excel file corruption errors.

All these features extend the software capabilities beyond just fixing the ‘Excel not responding’ error.

Best Excel Repair Software till Date - Try Now

Summary: In this blog, we overview and conclude Stellar Repair for Excel as Best Excel Repair software till date – based on its distinctive features and capabilities. Also, you’ll get to know what makes it the top Excel repair software from the perspective of recognized review websites, tech community forums, and users. In addition, you’ll find the simple and step-wise process of repairing Excel by using the software.

Corruption in Excel files can hamper workflow, bringing productivity to a halt. And what can be more concerning is that you may lose sensitive data if the corrupt or damaged file is not repaired on time. An Excel file may get corrupted due to various reasons.

Common Reasons Behind Excel File Corruption

• Abrupt system shutdown
• Human errors such as accidental deletion, formatting, or overwriting an Excel workbook
• Damaged Excel installation
• Hardware failure
• Virus infection or malware attack
• Bad sectors on the hard drive on which Excel files reside
• Large-sized Excel file

Regardless of the reason, manually troubleshooting corruption errors in an Excel file can drain time, resources and may even cause data loss. However, using a third-party professional tool such as Stellar Repair for Excel can save you the manual efforts and time in repairing Excel files, keeping the original data intact.

What Makes Stellar Repair for Excel the Best Software?

While there is no dearth of Excel file repair tools, Stellar Repair for Excel software has garnered considerable interest and positive reviews by MVPs . The software has remarkable features that make it the Excel file repair specialist.

Key Features of Stellar Repair for Excel Software

Though the software encompasses several great features and a simple-to-use and intuitive user interface, some of the key features that make it the best Excel repair software are:

• Restores Excel (XLS / XLSX) File in Original, Intact State

The software repairs corrupt Excel files and restores all the data in the original format. Also, it helps restore the original properties of cell formatting of the workbook.

• Capability to Resolve all Excel Related Errors

Most errors that crop up unexpectedly while working with Excel files are the result of damages caused due to human errors, virus infection, power surges, etc. The software can help you easily fix corrupted Excel files to get rid of errors such as “Excel is not responding ”, “Excel found unreadable content in name.xls ”, “Excel cannot open the file filename.xlsx”, etc.

• Real-Time Pre-Recovery Preview

It provides users with the opportunity to preview recoverable Excel file items before saving them. This helps users estimate how much data they will be able to salvage by using the tool, thus helping them make an informed decision about investing in the software.

Besides these features, some other aspects that make the software a recommended choice for Excel repair are as follows:

• 100% Secure****: Downloading and installing this software is 100% safe and secure, since Norton antivirus security comes installed with it.
• Tested by MVPs****: Stellar Repair for Excel software is tried and tested by credible MVPs.
• Allows Testing before Purchase: The software’s demo version lets you understand the tool and its advantages before buying it.
• Stellar is Microsoft Gold Partner****: The software’s vendor, Stellar Data Recovery, is a certified Gold partner for Microsoft.

Stellar Repair for Excel – The Most Recommended Software

Check out the user ratings and reviews to understand why Stellar Repair for Excel ranks as the top Excel file repair software, and why you should choose it over its competitors:

• Capterra – 4/5

A user has shared how effectively the Stellar Repair for Excel software repaired and restored the corrupted Excel file.

• g2.com – 4.5/5

The Excel Repair software got a rating of 4.5/5 on g2.com based on the positive reviews of the users.

• Softpedia – 3.5/5

Softpedia gave the product a rating of 3.5/5 and reported it as 100% clean (meaning without malware).

Support and Compatibility
Stellar Repair for Excel software supports the latest MS Excel versions 2019, 2016, 2013, and lower versions. It can operate smoothly on Windows 11, 10, 8.1, 8, 7, and earlier operating systems.
System Requirements
Stellar Repair for Excel requires a minimum Pentium Class Processor with 2 GB minimum memory and 250 MB of free storage drive space.

How to Use Stellar Repair for Excel Software to Repair Excel Files?

Follow these steps for repairing damaged or corrupt Excel files:

• Run the software and from the main software screen, select the corrupt Excel files you want to repair by clicking Browse or Search.

• Once the file is selected, click Repair to begin repairing the corrupt file.

• When the scanning finishes, all recoverable data is displayed in the left-pane of the preview window. Click on any item to preview its content in the right-pane.

• For saving the file, click the Save File button on the Home menu.
• When prompted, select a target location to save the repaired file and click OK.

The repaired Excel file will now get saved in the selected target location.

Concluding Lines

Stellar Repair for Excel  software empowers users to repair Excel (.XLS/.XLSX) files and restore worksheet data in the event of file corruption and data loss. More importantly, the software performs granular-level recovery to restore the complete file items while preserving worksheet properties and visual representation.

Ways to Fix the “Failed to Parse the Corrupted Excel File” Error

Summary: While parsing an Excel file, you may experience the “Failed to parse the corrupted Excel file” error. It usually occurs if the Excel file is corrupt. This blog covers some easy fixes to fix this Excel error. It also mentions an advanced Excel repair tool that can help fix the issue by repairing the corrupted file.

You may encounter the “Failed to parse the corrupted Excel file” error when parsing (extracting or converting) the data in an Excel file. This error usually occurs if the Excel file is corrupted – either completely or partially (some of its objects, like formulas, macros, and values are corrupt). However, there are various other reasons that may lead to this Excel error. Let’s know the possible causes behind the “Failed to parse the corrupted Excel file” error and how to fix it.

Causes of the “Failed to parse the corrupted Excel file” Error

This error could occur due to any of the following causes:

• Damaged or corrupted macros
• Excel document is closed suddenly
• Issues with Excel application installation
• Virus or malware attack
• Hardware failure
• Bad sectors on the hard drive

Ways to Fix the “Failed to parse the corrupted Excel file” Error

Here are some possible ways to fix this error and recover the Excel file.

Method 1: Try to Save the File in a Different Format

Sometimes, the error can occur if the file format is not compatible with your Excel version. You can try saving the file to a different format. To do this, follow the below steps:

• Open the Excel file.
• Click on the File option and then select Save As.
• Click on Browse option and then click Save as Type.

• Select the desired Excel file format and click Save.

Method 2: Revert to the Previously Saved Version of the Excel File

You can try reverting to the previously saved version of the Excel file. Here’s how:

• Open your Excel application.
• Navigate to File > Info > Manage Workbook.

• Click Recover unsaved workbooks.

• Click on the Restore option you see at the top of the file.

Method 3: Set the Calculation Option to Manual

When the calculation mode is set to automatic, Excel automatically recalculates all the formulas in the file even if you make a minor change. It can take time to load the file and stop you from parsing data in your Excel file. You can change the calculation option to manual so that Excel only recalculates when you explicitly tell the application to do it. Here are the steps:

• Open your Excel application.
• Navigate to File and then click Options.
• In Excel Options, select Formulas.
• Under Workbook Calculation, select Manual and click OK.

Method 4: Use Open and Repair Utility

You can try repairing the corrupted Excel file with Excel’s inbuilt tool – Open and Repair . To use the tool, follow the steps cited below:

• In Excel, go to the File tab and then click Open.
• Click Browse to select the corrupted file.
• The Open dialog box will appear. Click on the corrupted file.
• Click on the arrow next to the Open button and then click 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 your work as possible.
• After repair, a message will appear (as shown in the below figure).

• Click Close.

What If None of the Above Methods Works?

The above methods may fail to work if the Excel file is severely damaged. In such a case, we recommend using an efficient Excel repair tool , such as Stellar Repair for Excel. It can quickly repair corrupted Excel (.XLS/.XLSX) files. It can recover all the objects from the file, including charts, tables, formulas, etc. You can download the free trial version of the tool to preview the recoverable data.

Conclusion

Above, we have discussed some tried and tested methods to fix the “Failed to parse the corrupted Excel file” error. If the Excel file is severely damaged or corrupted, you can try repairing it using a third-party Excel repair software, like Stellar Repair for Excel . It can repair multiple Excel files without affecting the original formatting. The tool is compatible with all Excel versions.

Solutions to Repair Corrupt Excel File

Summary: MS Excel can throw various errors due to corrupted Excel files. This blog discusses the error messages that indicate Excel file corruption and the methods to prevent data loss due to a corrupt file. It also discusses the reasons behind the corruption in Excel file and their solutions. It also mentions a “Stellar repair for Excel” tool that can help to repair the corrupt or damaged Excel file.

Is your Excel file corrupted? And you don’t have backup of your data? There is no need to worry. There are some simple solutions to repair Excel file 2019. But before heading towards the solutions, let’s discuss the possible reasons for Excel file corruption and how you can prevent losing your data.

Error Messages that Indicate Excel File Corruption

When an Excel file gets corrupted, different error messages appear. For example:

• “Excel found unreadable content in . Do you want to recover the content of this workbook, click Yes.”
• “Can’t find project and library.”
• “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted.”
• “Microsoft Excel has stopped working.”

Reasons Behind Excel File Corruption

The reasons for corruption in Excel file could be any of the following:

• Improper system shutdown
• Computer virus/malware attack/Hacker attack
• Outdated anti-virus definition
• Hardware failure
• Unintentional deletion of files
• Large Excel files
• Bad sectors on storage media

How to Avoid Data Loss Due to Excel File Corruption?

Excel users should follow the below precautionary measures to prevent data loss due to Excel file corruption:

1. Create an Automatic Backup Copy

When you create an Excel spreadsheet, it is advised to Save As your document, as follows:

1. In Save As window, click Tools next to Save option.
2. Select General Options from the drop-down menu.
3. Then check the dialogue box Always create back up and click OK.

This will always create a backup of your Excel. If it’s deleted or corrupted at any time, it can be recovered.

2. Create Recovery File at Different Time Periods

Steps are as follows:

1. Go to File and then click Excel Options.
2. Click Save and then select the Save Auto Recover information every checkbox
3. Add the required minutes and location. Ensure that Disable AutoRecover for this workbook only box is unchecked.

Methods to Repair Corrupted Excel 2019 File

Try using these 5 methods to restore your Excel file and recover data:

Method 1: ‘Open and Repair’ Excel Files

Excel automatically opens the corrupted file in Recovery Mode. If not, you can repair Excel file manually through the following steps:

• Click on the File and select Open.

• Go to the location where the corrupt workbook is stored. In the Open window, select the corrupt file.
• Click Open and then select Open and Repair.
• In the window that opens, click Repair.

If the Repair option doesn’t work, you can select Extract Data and try to extract the values and formulae safely from the corrupt file.

Method 2: Recover Data from Open Workbook

If you face issues while working in an Excel file, you can choose to return to the last saved version of the Excel file. For this:

• Click File. Then select Open.
• Double click on the name of the workbook (the one that is open in your Excel).
• Click Yes to reopen it.

• The workbook will now appear.

Please note that it will show the last saved version and changes made after that won’t be recovered.

Method 3: Set Calculation Option as Manual

You can also recover data from Excel workbooks that you’re unable to open. For this, you need to configure the calculation option as manual in Excel. You can do this through the following steps:

• Click on File. Select New and open a Blank workbook.
• From File, select Excel Options.

• From the Formulas category, under the section Calculation options, select Manual. Now click OK.

• Then click File, and select Open to open the corrupted or damaged Excel file.

Method 4: Recover Content by Using External Links

You can also recover specifically the content (leaving formulas/calculated values) from the workbook by using external references (to link Excel workbook). For this:

• Click on File, Select Open.
• Navigate to the folder that contains the corrupted workbook.
• Now, right-click on the file name of the corrupted workbook and click Copy.
• Click File button. Then, select New and create another blank workbook.
• In the first cell (A1), type =!A1 and press Enter.
  • Select the corrupted workbook in the Update Values dialogue (if it appears). Then click OK.
  • Select the relevant sheet in the Select Sheet dialogue (if it appears). Then click OK.

• Again, select the cell A1, go to Home and select Copy.
• Now select (start from the cell A1) an area equal to that of the data in the original workbook.
• Go to Home now and select Paste.
• Again, go to Home, and Copy the data (the same selection of cells).
• Go to Home, and then click on the arrow below Paste. Then click on Values.

By pasting values, you removed the links to the corrupted workbook and only the data is left behind.

Method 5: Excel Repair Software

If the above-mentioned methods do not help in repairing the corrupt Excel file, try an Excel repair software.

One of the most commonly used Excel repair tools is Stellar Repair for Excel. Its trial version is available for free download, which lets you scan and preview the repaired Excel files. Once you’ve ascertained the effectiveness of the software, you can save the file after activating the software.

Here’s the complete repairing process of the corrupt Excel file

Conclusion

This post shared the reasons behind Excel file corruption and precautionary measures to prevent data loss. It also outlined different methods to repair corrupt Excel file 2019. There are several in-built utilities in Microsoft Excel to repair corrupt workbooks and recover data from it. In case these methods didn’t work, you can use Stellar Repair for Excel – an easy-to-use DIY tool that can fix all Excel corruption errors and restore data with all original properties.

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.