Excel File Corruption Warnings and Solutions

Summary: Many users reported error messages they receive when they try to save or open an Excel file. In this blog, you will learn about the warning messages that indicate your Excel file is corrupt and possible solutions to repair it. It also outlines the Stellar Repair for Excel to repair corrupt Excel files.

Excel users often report about receiving warning messages suggesting corruption in the workbook. This usually happens while opening an Excel file, ‘.xls’ or ‘.xlsx’ file created by earlier versions, or attempting to create a copy of the workbook.

Excel file corruption may occur due to several reasons including (but not limited to) virus infection, sudden system shutdown during write operation, and leaving excel file open on the shared network.

Occurrences of Excel File Corruption Warnings

Occurrence 1 – “Excel found unreadable content in . Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes”.

On clicking ‘Yes’, you will receive the following error:

 “The file is corrupt and cannot be opened”.

Occurrence 2 – “Excel cannot open the file , because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file”.

Besides the warning messages outlined above, there are a few other tell-tale signs of Excel file corruption such as:

• Excel crashes or freezes, preventing you from accessing the workbook and information stored in it.
• Unexpected errors occur during the save operation listed as below:
  • “An unexpected error has occurred. AutoRecover has been disabled for this session of Excel”.
  • “Errors were detected while saving ”.

Solutions to Fix Excel File Corruption Issue

Follow the below-listed solutions to deal with corruption issues in Excel:

NOTE: If you encountered problem opening Excel files after upgrading to latest Windows Operating System (OS) and Office program, try updating your Office as well as Windows OS to latest patches provided on the Microsoft site. Microsoft frequently releases Office and Windows OS patches to help users’ correct known errors. Check if you can open the corrupt workbook after installing the update.

Solution 1 – Use Open and Repair Utility

Excel comes with a built-in recovery mechanism. It automatically starts ‘File Recovery Mode’ when a user opens a corrupt workbook, and attempts to open and repair the workbook. Sometimes, the recovery mode might not start automatically. In that case, you will need to repair the Excel file manually by using ‘Open and Repair ’ utility.

Steps to use Microsoft’s built-in repair utility are as follows:

Step 1: Select File > Open.

Step 2: Click the folder containing the corrupt workbook, and then click Browse.

Step 3: In the Open window, select the corrupt workbook.

Step 4: Next, click the arrow in the Open button, and then click Open and Repair.

Step 5: In the window that appears, click Repair.

If  ‘Open and Repair’ doesn’t work in excel , select Extract Data to extract formulas and values from the corrupt workbook.

NOTE: If you need a quick solution to salvage your data, use an Excel file repair tool.

Or else, attempt the following solutions to deal with corruption in Excel file .

Solution 2 – Uninstall and Re-install Office Installation

NOTE: Make sure to create a backup of your Excel file before uninstalling and re-installing your Office application.

Download the Office uninstall support tool to remove the application.

You can read: Simple Ways to Open Corrupt Excel file Without any Backup

To reinstall Microsoft Office, follow these steps:

NOTE: Before proceeding with Office re-installation process, make sure that you have license keys ready.

Step 1: Open the Microsoft Office site.

Step 2: Select Sign in.

NOTE: You may skip this step if you’re already signed in.

Step 3: After signing in, from the Office sign-in page, click Install/Install Office

Your Office application will get re-installed. Now open the backed-up Excel file and see if the problem is fixed.

Solution 3 – Move Excel File to a Different Location

Often moving a corrupt Excel file to a different location can help solve the corruption problem. Here’s how:

Step 1: Open the corrupt Excel file by navigating to the following path:

C:\Users\User_Name\AppData\Roaming\Microsoft\Excel

NOTE: Make sure to replace User_Name with your user name. If you are unable to find the Excel file, you will have to search for the file manually in Program Files (x86).

Step 2:  Open the Excel folder, and move the corrupt file to some other location.

Step 3: Delete the files from the Excel folder.

Now try opening the Excel file you have moved and see if the issue is resolved.

Solution 4 – Use Excel File Repair Software

If none of the above solutions works for you, use Stellar Repair for Excel. It is a specialized Excel file repair software that helps repair corrupt Excel file and recover workbook data in its original state.

Essentially, the software helps rebuild the corrupt file to restore every single object in the file. It can recover objects including user-defined charts, conditional formatting rules, formatting of the charts, properties of worksheet, engineering formulas, etc.

Steps to use Stellar Repair for Excel are as follows:

Step 1: Download, install and launch Stellar Repair for Excel software.

Step 2: In Select File window, click Browse to select the file you want to repair.

NOTE: If you are unaware of the Excel file location, click ‘Search’ in the Select File window to find the file.

Step 3: Once the files are selected, click Repair to initiate the repair process.

Step 4: Preview the repaired file and select all or specific files you want to save.

Step 5: Click Save File on Home menu.

Step 6: In Save File window, choose ‘Default Location’ or ‘Select New Folder’ to select the location where you wish to save the file. Click OK.

The selected files will be saved at the specified location.

Conclusion

You may experience Excel file corruption warning messages while opening or saving an Excel file. The file may become corrupt due to malware infection, sudden system shutdown, and forgetting to close workbook on a shared network. This post outlined occurrences of Excel file corruption warnings, and also described solutions to fix the issue.

You may try using Microsoft’s built-in ‘Open and Repair’ tool to repair corrupt workbook and recover data from it. If this solution doesn’t work, proceed with uninstalling and re-installing the Office application. Another solution is to move corrupt files to another location. But if the problem still persists, use Stellar Repair for Excel software to repair single or multiple Excel (.xls or .xlsx) files and restore data.

[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.

Fix Cannot Paste the Data Error in Microsoft Excel

When copying and pasting the cell contents or attributes from one workbook to another, you can encounter the “Cannot paste the data” error. The error indicates that the values you are trying to paste do not match the cell format (Currency, Date, Text, etc.) used in the column. The error can occur if you are attempting to paste information into a merged cell. You can also get this error if the data you are trying to paste contains more columns than the destination worksheet can accept or if the copy area and paste area aren’t the same size.

Why you cannot Paste the Data in Microsoft Excel?

You can experience the “Excel cannot paste the data” error due to one of the following reasons:

• Locked cells
• Data size limitation
• Formatting issues
• The file size is too large
• Overloaded clipboard
• Data type mismatch
• Invalid range
• Lack of permissions
• Excel file is corrupted
• Compatibility issues
• While pasting the merged cells

Methods to Fix MS Excel Cannot Paste the Data Error

The “Microsoft Excel cannot paste the data” error usually appears when copying and pasting data within the spreadsheet. It primarily affects the copy-and-paste feature within the Excel file. However, the impact of this error may vary with the data you are working with. When this error occurs, first try restarting the Excel application. Ensure that you’ve saved all your important data before restarting the application to prevent data loss. If, after performing this basic step, you still face the issue, then try the following troubleshooting methods.

Method 1: Check and Unlock Cells in Excel

You can get the Excel cannot paste the data error if the cells you are trying to paste in the Excel file are locked. You can check and unlock the specific cells in the Excel file using the below steps:

• Go to the Home tab in your Excel file and click Format Cell Font popup launcher.

• In the Format Cells dialog box, click Protection.

• Under the Protection option, unselect the locked field and then click OK.

Method 2: Check and Fix the Cell Format

Sometimes, you can get the “Cannot paste the data” error in Excel if there is an issue with the formatting of the cells in the column (in which you are trying to paste the data). You can check whether the cell formats of the columns of the source file (from where you are copying data) match the destination file (in which you are pasting the cell data). If not, then change the cell format. Here’s how to do so:

• In the Excel file, click on the affected column heading (whose cells you need to modify).
• Navigate to the Home tab and click the General dropdown menu.

• Click on the desired cell format that matches the values you are trying to paste into the column.

Method 3: Check Copy and Paste Area Size

The “data cannot be pasted” issue can also occur if Excel detects the copy area of the range of cells is not of the same size and shape as that of the paste area. So, make sure the size of the range of cells for the paste area is same as the copied area. To ensure this, you can try the following:

• Use Upper-left Cell

 You can select the upper-left cell instead of the complete range to paste.

• Use Paste Special Option

• You can use the Paste Special option to paste the data. To use this option, go to Home > Paste Special.

• You can choose from the different options, such as paste all, formulas, operations, Transpose, skip blanks, etc. to take control over how the data is pasted.

Method 4: Check and Unmerge Cells

The merged cells in the workbook can create discrepancies when copying and pasting data. These can create mismatch between the source and destination cell areas, resulting in errors. Make sure you are not pasting the data copied from merged cells. You can check and unmerge the cells using the below steps:

• Open the Excel file (in which you are copying data) and go to the Home tab.
• Click Merge & Center > Unmerge Cells.

Method 5: Unselect the Excel DDE (Dynamic Data Exchange) Option

Sometimes, you can get the Excel cannot paste the data error while copying and pasting data from Excel file to external data sources or applications. It usually appears if you have established DDE links between them. To resolve this, you can uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” option. Follow the below steps to do so:

• Open your Excel file.
• Go to File > Options.

In Excel Options, click Advanced and unselect “Ignore other applications that use Dynamic Data Exchange (DDE). Click OK.

Here are some additional solutions you can try to fix the “Cannot paste the data” error in Excel

Check the Excel File Format

Sometimes, the copy and paste error can occur if you try to move data from an older version of Excel file (XLS) into a newer version file (XLSX) or vice versa. You can try to change or convert the file format to resolve the issue.

Clear Clipboard

Too many items on the clipboard can prevent you from copying and pasting the data. You can empty your clipboard  by deleting all clips. To do this, go to Home and click the Clipboard option.

Change the Column’s Cell Format

You can get the “Cannot paste the data” error when the information you need to paste does not match the cell format in the column. In such a case, you can change the column’s cell format. To do this, navigate to the Home option and then click on the General menu arrow. Then, change the cell format suitable to the type of information you are trying to paste in that column.

Add Columns

The copy-and-paste error in Excel can also occur if there are not enough columns to accept the data that you are trying to paste. You can insert more columns and then try copying and pasting data. To insert additional columns, click on the column heading, click Home, and then select Insert.

Remove Incompatible Add-ins

Sometimes, incompatible or faulty add-ins can also create conflicts with Excel’s clipboard operations, leading to the error. To check if add-ins are causing the issue, open the Excel file in safe mode. In safe mode, if you are able to paste the data, then check and uninstall the incompatible Excel Add-ins.

What to do if Nothing Works?

If the above methods do not work, then corruption in the Excel file could be the cause of the “Cannot paste the data” error. In such a case, you can use Excel’s built-in Open and Repair utility to repair the corrupted file. Here’s how to use this utility to repair the Excel file:

• Open your Excel application.
• Navigate to File and then click Open.
• Click the Browse option to select the affected Excel file.
• The Open dialog box opens up. Click on the corrupted file.
• From the Open dropdown, select the Open and Repair option.
• The Excel will prompt you to choose one of the below options:
• Repair
• Extract
• Cancel
• Select the Repair option to extract maximum data from the file. If the Repair option fails, choose the Extract option to recover the data, excluding formulas and values.

 The Open and Repair utility may not be able to repair your Excel file if it is severely corrupted. In such a situation, the best possible way out is to use a professional Excel repair software to repair the file. You can try Stellar Repair for Excel. It can repair highly damaged or corrupted Excel (.xls, .xlsx, .xltm, .xltx, or .xlsm) file and recover all the objects from the file by maintaining the original formatting. The tool supports 2007 and higher editions of MS Excel. You can download the demo version of the software to preview the repaired objects and verify its functionality.

Conclusion

The “Excel cannot paste the data” error in Excel can occur due to different factors. You can check and clear the clipboard, unmerge the cells, unlock the cells, and use various other methods mentioned above to troubleshoot the error. If you fail to copy and paste the data due to file corruption, then opt for an advanced Excel repair software, like Stellar Repair for Excel. It is a reliable tool that can help you repair highly damaged/corrupted Excel files. It enables you to recover all the objects from the corrupted Excel file, with complete integrity.

How to Fix Excel Run Time Error 1004

Summary: Run-time errors are windows-specific issues that occur while the program is running. This blog will teach you how to fix Excel run-time error 1004. In addition, you’ll learn about an Excel repair tool that can help fix the error 1004 if it occurs due to corruption in Excel files.

VBA (Microsoft Visual Basic for Application) is an internal programming language in Microsoft Excel. Sometimes, when users try to run VBA or generate a Macro in Excel, the Run-time error 1004 may occur. This error may occur due to the presence of more legend entries in the chart, file conflict, incorrect Macro name, and corrupt Excel files. In this blog, we have discussed the reasons and shared some solutions to resolve run-time error 1004.

Why This Error Occurs?

The run time error 1004 usually occurs when you run a VBA macro with the Legend Entries method to modify the legend entries in the MS Excel chart. It happens when the chart contains more legend entries than the available space, macro name conflicts, corrupt Excel files, or data-types mismatch in the VBA code.

Ways to Fix Excel Run-Time Error 1004?

Try the below workarounds to fix Excel run-time error 1004:

Create a Macro to Reduce Chart Legend Font Size

Sometimes, Excel throws the run-time error when you try to run VBA macro to change the legend entries in a Microsoft Excel chart. This error usually occurs when Microsoft Excel truncates the legend entries because of the more legend entries and less space availability. To fix this, try to create a macro that shrinks/minimize the font size of the Excel chart legend text before the VBA macro, and then restore the font size of the chart legend. Here is the macro code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

VBCopy
Sub ResizeLegendEntries()

With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Store the current font size
      fntSZ = ActiveChart.Legend.Font.Size

'Temporarily change the font size.
      ActiveChart.Legend.Font.Size = 2

'Place your LegendEntries macro code here to make
         'the changes that you want to the chart legend.

' Restore the font size.
      ActiveChart.Legend.Font.Size = fntSZ
   End With

End Sub
Note: Make sure you have an Excel chart to run the code on the worksheet.

Uninstall Microsoft Work

You may encounter a run-time error 1004 in Excel version 2009 or older versions due to conflicts between Microsoft works and Microsoft Excel. This error usually occurs if your system has both Microsoft Office and Microsoft Works. Uninstalling one of them will fix the issue. Try the below steps to uninstall Microsoft Work:

• First, open the Task Manager using the shortcut CTRL + ALT + DEL altogether
• The Task Manager window is displayed.

• Click the Process tab, right-click on each program you want to close, and then click End Task.
• Stop all the running programs.
• Open the Run window and type appwiz.cpl to open the Programs and Feature window.

• Search for Microsoft Works and click Uninstall.

Try Deleting GWXL97.Xla File

The Add-ins files with .xla extension in MS-EXCEL is used to provide additional functionality to Excel spreadsheets. Sometimes, deleting the GWXL97.XLA file fixes the run-time error. Here are the steps to delete this file:

• Make sure you have an Admins rights, open the Windows Explorer
• Follow the Path C:\Programs Files\MSOffice\Office\XLSTART.
• Find and right-click on the GWXL97.XLA file
• Click Delete.

Change Trust Center Settings

Sometimes, run-time errors might arise because of incorrect security settings. The Trust Center settings help you find the Privacy and security settings for Microsoft Excel. Follow the below steps to change the Trust center settings:

• Open Microsoft Excel.
• Go to File > Options.
• The Excel options window is displayed.
• Choose Trust Center, and click Trust Center Settings.
• Tap on the Macro Settings tab, and select Trust access to the VBA project object model.

• Click OK.

Run Open and Repair Tool

The Runtime error also arises when MS Excel detects a corrupted worksheet. It automatically begins the File recovery mode and starts repairing it. However, if the Recovery mode fails to start, use the Open and Repair tool with the below steps:

• Click File > Open.
• Click the location and folder with a corrupted workbook.
• In the Open dialog box, choose the corrupted workbook.
• Click the arrow next to the Open tab, and go to the Open and Repair tab.
• Click Repair.

You can also opt for Stellar Repair for Excel if the Microsoft Excel’s built-in tool cannot fix the error.

Use Stellar Repair for Excel

Stellar Repair for Excel is a professional software for repairing damage. xls, .xlsx, .xltm, .xltx, and .xlsm files and recovering all its objects. Here are the steps to fix the error using this tool:

• First, download, install, and run Stellar Repair for Excel.
• Click the Browse tab on the interface window to choose the corrupted Excel file you need to repair.
• Click Scan. You will see the scan progress in the scanning window.
• Click OK.
• The tool can let you preview all the recoverable Excel file components including tables, pivot tables, charts, formulas, etc.
• Click Save to save the repaired file.
• A Save File dialog box will appear with the below two options:
• Default location
• New location
• Choose a suitable option.
• Click the Save option to repair the Excel file that you have chosen.
• Once the repair is complete, it will display a message “File repaired successfully.”
• Click OK.

Conclusion

Now you know the Excel run-time error 1004, its cause, and solutions. Follow the workarounds discussed in the blog to rectify the error quickly. However, Stellar Repair for Excel makes your task of removing run-time errors easy. It’s a powerful software to fix all the issues with Excel files. Also, it helps in extracting data from the damaged file and saves it to a new Excel workbook.

How to Repair Multiple Excel Files by Using Stellar

With Stellar Repair for Excel, it is quite easy and simple to repair multiple MS Excel (XLS and XLSX) files that are damaged. This is because the software has a self-explanatory interface and hence is a Do-it-yourself software. Nonetheless, when using this software to repair multiple Excel files, you would have to add all of the files into the software by following a few pre-defined steps. Follow the steps mentioned below:

• Launch Stellar Repair for Excel software.
• Under Home menu, click Select file

• Click Browse and select corrupt Excel files. Select the checkbox to repair multiple files.

• Click Repair
• The software provides the preview facility. You can check the it on left pane.

• Save the repired filr ether Default location or Select New Folder radio button.

Stellar Repair for Excel Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from corrupt file to a new blank Excel file.

Learn More

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 runtime error 424 object required error in Excel

The Runtime error 424: Object required occurs when Excel is not able to recognize an object that you are referring to in a VBA code. The object can be a workbook, worksheet, range, variable, class, macro, etc. Some users have also reported that this error occurred when they tried to copy the values of the cells from one workbook to another.

Let’s understand the error through a small scenario. Suppose, I want to check the last field row in a table in a spreadsheet named “First” using the VBA code. To do this, I have added a command button and double-clicked on it and entered the below code in the backend:

Private Sub CommandButton2_Click()

Dim LRow As Integer

LRow = Worksheets(“First”).Cells(Rows.Count, 2).End(xlUp).Row

MsgBox (“Last Row “ & LRow)

End Sub

In this code, Worksheets(“First”) is a data object. If I mistakenly delete this data object and insert any random name (for example - kanada), then it will not be recognized by Excel. When I run this code, I will get the “Run-time error 424”.

Causes of Runtime Error 424 in Excel

The Runtime error 424: Object required can occur due to the following reasons:

• Incorrect name of the object you are trying to refer to in a code.
• You have provided an invalid qualifier to an object.
• You have not used the Set statement while assigning an object reference.
• The object is corrupted.
• Missing objects in a workbook.
• Objects you are trying to call in a code are mistakenly deleted or unavailable.
• You have used an incorrect syntax for object declaration.
• You are trying to perform an invalid action on an object in a code.
• Workbook is corrupted.

Click here

The VBA error ‘object required’ may occur due to different reasons. Based on the reason, you can follow the solutions mentioned below to fix the error.

1. Check the Name of the Object

The Runtime error 424 can occur when you run the VBA code using an incorrect name of the object. For example, the object name is ‘MyObject’ but you’re using “Backcolor”.

 When you click the Debug button, the line with the error will highlight.

To fix the issue, you need to provide the correct name of the object.

2. Check if the Object is Missing

 The Runtime error 424 can occur if the object you are referring to as a method is not available or you are using the wrong object in a code. In the below example, you can see that the error occurs when an object named “Employee” is not available in the Project list.

 You can check and mention the object which is available. For instance, Sheet2 in the below code.

3. Check All References are Declared in the Code

You can get the Runtime error 424 if all the references are not declared. So, make sure you have declared all the references in the code. To verify this, you can use the debug mode by pressing F5 or clicking on the Debug option.

4. Check the Macro Security Settings

Sometimes, the error can occur if macros are disabled in the Macro Security settings. You can check and change the settings by following these steps:

• On the Developer tab, in the Code section, click Macro Security.
• In the Trust Center window, select Enable all macros.

• Click OK.

5. Repair your Workbook

Sometimes, the ‘Object required’ error can occur if your Excel file is damaged or corrupted. In such a case, you can try repairing the file using Microsoft’s in-built utility - Open and Repair. To use this utility, follow these steps:

• In Excel, go to File > Open > Browse.
• In the Open dialog box, click on the corrupted Excel file.
• Click the arrow next to the Open button and select Open and Repair from the dropdown.
• Select Repair to recover as much data from the file as possible.

If the Open and Repair utility fails or stops working, then you can try a professional Excel repair tool, such as Stellar Repair for Excel . It is an advanced tool that can repair severely corrupted Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm). It helps recover all the file components, including images, charts, tables, pivot tables, cell comments, chart sheets, formulas, etc., without impacting the original structure.

Conclusion

The Runtime error 424 usually occurs when there is an issue with the objects in your VBA code. In this article, we have covered some effective methods to resolve the “object required” error in Excel. If the error occurs due to corruption in Excel file, then you can repair the corrupt file using Stellar Repair for Excel. It is a reliable tool that can repair severely corrupted Excel file without changing its actual formatting. You can download the free trial version of the software to evaluate its functionality.