How to fix runtime error 424 object required error in Excel 2021 | Stellar
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.
Solutions to Fix Runtime Error 424: Object Required in Excel
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.
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:
- In Save As window, click Tools next to Save option.
- Select General Options from the drop-down menu.
- 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:
- Go to File and then click Excel Options.
- Click Save and then select the Save Auto Recover information every checkbox
- 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.
How Do I Repair and Restore Excel File?
When an Excel file turns corrupt, the file might become inaccessible or you might receive errors. You may encounter errors, such as ‘the file is corrupt and cannot be opened,’ ‘Excel found unreadable content in “filename>”,’ ‘Excel cannot open “filename” because the file format or extension is not valid,’ etc.
Common Reasons for Excel File Corruption
There are several reasons that can turn the file corrupt. The most common reason is a damaged hard drive. Other factors that can cause corruption in an Excel file are as follows:
- System crash or abrupt shutdown of the system while the file is still open
- Viruses infecting the file with malicious code
- Bug in the operating system
- Bad sectors on the drive where the file is stored
- Large spreadsheets with formulas and other components
Whatever be the reason, if your business is dependent on an Excel file, corruption in the file could hamper your business continuity. Also, you may lose crucial data. In such a situation, you could try to repair the file.
Before We Begin
It is important to identify the root cause behind Excel file corruption. If the problem has occurred due to a faulty hard disk drive, contact your hardware vendor to get it fixed. Also, move the file to another local drive and check if it opens. If nothing works, proceed with the methods discussed below to repair and restore the file.
Methods to Repair and Restore Excel File
Try the following methods to fix corruption in an Excel file and restore it.
Method 1 – Use the Built-in ‘Open and Repair’ Tool
You can use the Excel built-in Open and Repair utility to repair the corrupt file. Follow these steps:
- Open your Excel application and click on Blank workbook.
- On the blank workbook screen, click on the File tab.
- Click Open > Computer > Browse.
- Select the file you want to repair and then click on Open and Repair from the Open dropdown box.
- Click Repair to fix corruption in the Excel file and recover maximum data.
- If you get the following error message, click Yes to open the file.
- If clicking Yes opens the file with garbage entries (see the image below), perform Step 1 – 5 and click Extract Data. This will only help you recover data without formulas and values.
Note: You may also try to recover the data from a corrupted workbook by using the methods suggested by Microsoft .
A better way to repair and restore an Excel file with complete data is to use a specialized Excel file repair tool .
Method 2 – Use Excel File Repair Tool
Stellar Repair for Excel is a powerful tool designed to help users fix corrupted .xls or .xlsx files without any technical assistance. Also, the tool recovers all the components from a corrupted workbook, including tables, pivot tables, cell values, formulas, charts, images, etc. You can preview the repaired file and its contents by downloading the free demo version from the link below. It is a useful feature that allows the user to validate the data before saving it.
[
](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ “Free Download For Windows”)
Here’s the step-by-step instructions to repair a corrupt Excel file using the software:
- Run the software. The software main interface opens with an instruction to add some add-ins if you’ve engineering formulas in the file you want to repair.
Click OK to proceed.
Select the file you wish to repair by using the Browse option.
Note: If you’re not aware of the file location, choose the ‘Search’ option to locate the file.
- A screen showing progress of the Excel file repair process is displayed.
- Preview of the repaired Excel file and its recoverable data is displayed.
- After verifying the data, click on the Save File button on the File menu to save the repaired file.
- Select the location where you wish to save the repaired file on the Save File window and then click OK.
A confirmation message will pop-up after completion of the repair process. You can now try to open the file in your Excel program.
End Note
Even if you’re taking preventive measures, you might still experience corruption in an Excel file. So, it’s crucial to take regular backups of your workbooks. For this, ensure that the ‘Always create backup’ option is enabled in Excel. You can find it in General Options by clicking on the Tools button in the Save As dialog box. Enabling it will ensure that the Excel backup file is updated with the changes made in a spreadsheet.
Additionally, ensure that the Excel ‘AutoRecover’ feature is set to save a version of your Excel file after every 10 minutes. You can increase or shorten the interval as per your requirement.
How to Repair Corrupt Excel Workbook?
Summary: Corruption in an Excel workbook could lead to data loss. This blog outlines the possible reasons behind corrupted workbook and describes how to repair the workbook manually and using an Excel repair tool.
Is your Excel behaving differently, for instance, stops responding or freezes? Or have you encountered a warning or an error message indicating corruption in the Excel workbook?
Figure 1 - Corruption Warning in Excel: The corrupt workbook cannot be opened or repaired
Figure 2 - Excel File Corruption Message
In any of these situations, you won?t be able to open your Excel workbook.
TIP! If you?re unable to open an Excel workbook, it does not necessarily mean that the workbook is corrupt. Try a few workarounds to resolve the issue, like disabling the ?Protected View Settings?, disabling add-ins, or moving the workbook to another drive.
You will need to repair the corrupted Excel workbook to make it usable. Before discussing the repair methods, let?s first look at the possible reasons behind file corruption.
To jump to methods to repair the workbook, click here .
Possible Reasons behind Corrupted Excel Workbook
- Large size of a workbook: A workbook containing lots of information or objects like images, shaded cells, or other visual representations is prone to corruption.
- Unexpected system shutdown or power loss: If you haven?t saved your Excel file, abrupt system shutdown or power failure can corrupt the data and render the file inaccessible.
- Bad sectors on storage media: Accumulation of bad sectors on storage media on which Excel files are saved is another reason that may lead to Excel file corruption.
Other common reasons causing Excel file corruption are virus attack, network errors, etc.
Methods to Repair Corrupted Excel Workbook
Note: Repairing the corrupt workbook may result in data loss. And so, it?s recommended to back up the workbook before attempting to repair the file.
Method 1 ? Repair the Excel Workbook Manually
Use the Excel ?Open and Repair? feature to repair your corrupt workbook manually. Here?s how:
Step 1: In Excel, click the File tab and then click Open.
Step 2: Select the corrupt Excel file, click the arrow button next to the Open button and then select Open and Repair.
Figure 3 - Excel Open and Repair Feature
Step 3: In Microsoft Excel dialog box that opens, click Repair to begin repairing your corrupt workbook.
Figure 4 - Repair the Microsoft Excel File
Note: If the Excel repair process fails, repeat Steps 1 till 3 and click the ?Extract Data? button. This will help you extract values and formulas from the corrupted workbook.
Performing these steps will repair your Excel file. If the issue persists, skip to the next method.
Method 2 ? Use Excel File Repair Software
If the above method failed to fix corruption in the workbook, use Excel file repair software to repair your workbook quickly. This Excel repair tool is purpose-built to help users repair large-sized Excel files (.xlsx and .xls) in just a few clicks. Also, it helps recover all the data from the corrupted workbook while preserving the cell formatting and worksheet properties.
Steps to Repair Corrupt Excel File Using the Software
Step 1: Download, install, and open Stellar Repair for Excel software.
Free Download for windows ](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ )
Step 2: Click Browse to select your corrupted .xlsx or .xls file. If you are not aware of the file location, click Search to locate and select the file.
Figure 5 - Select Corrupt Excel Workbook
Step 3: Once the file is selected, click Repair.
Step 4: A preview of recoverable workbook data gets displayed.
Figure 6 - Preview of Recoverable Excel Workbook Data
Note: You will need to activate the licensed version of Stellar Repair for Excel software for saving the repaired file. Once activated, proceed with the steps below to save the repaired file.
Step 5: Click Save File on the File menu. This will open a Save File dialog box with options to save the repaired .xlsx/.xls file at default or new location. After choosing the appropriate option, click OK.
Figure 7 - Save Repaired Excel File
The repaired file will get saved at the selected location.
Key Features of Stellar Repair for Excel Software
- Repairs severely corrupt Excel file and recovers pivots, pivot tables, conditional formatting rules, chart, chart sheets, etc.
- Can repair multiple Excel files in a batch simultaneously
- Can handle all types of Excel file corruption errors, like ?Excel found unreadable content in filename.xls?, ?Excel cannot open the file filename.xlsx?, etc.
- Supports repairing corrupt workbooks of Excel 2019, 2016, 2013, 2007, 2003, and lower versions.
End Note
If your Excel workbook has turned corrupt, try using the methods discussed in this blog to repair the workbook. Once it is repaired, you must follow preventive measures to avoid your Excel file from getting corrupt. Some of these measures are as follows:
Reduce the size of your workbook by:
- Removing unused data
- Saving images at lower resolutions
- Avoid saving pivot table cache
Turn on the ?AutoRecover? and ?AutoSave? features in Excel
Excel Repair Tool to Repair Corrupt Excel files (.XLS/.XLSX)
When to Use Stellar Excel File Repair Tool?
Unable to Open an Excel File Due to Invalid Extension?
You may face an error - “Excel cannot open the file .xlsx” in Excel 2021, 2019, 2016, etc., leading to data loss. This error occurs when you try to open corrupt Excel file or an invalid file format. Using the correct extension can resolve the issue, if there is no corruption. However, you need an Excel repair tool if the file is corrupt. Stellar Repair for Excel can repair the corrupt file and recover all objects in intact form.
Excel File Not Opening Due to Corruption?
You cannot open an Excel file if it is corrupted. For example, opening an Excel file created in a lower version like Excel 2007 in Excel 2010 or later version can throw a corruption error message. Or, the file may open in a ‘protected view,’ not allowing any write operations. The Excel repair tool from Stellar provides a comprehensive solution to fix corrupt Excel files across all versions, including Excel 2021, 2019, 2016, 2013, and older.
Excel Found Unreadable Content?
You may encounter an error message – “Excel found unreadable content in filename.xls”, with a message to recover the contents of the workbook. Clicking ‘Yes’ to recover the contents may lead to loss of formatting, replacement of formulas, and inconsistencies. Stellar Phoenix Excel Repair software now Stellar Repair for Excel can scan the workbook and recover its contents.
KEY FEATURES FOR REPAIR FOR EXCEL
Software Important Capabilities
Repair Large-sized Excel Files
Stellar Repair for Excel software previously known as Stellar Phoenix Excel Repair can repair & fix corrupt Excel files of any size. It removes corruption from individual objects, fixes the damage, and restores the Excel file back to its original state. The Excel repair tool can repair multiple Excel files in a batch.
Learn More
Resolves All Excel Corruption Errors
This Excel file repair tool fixes all types of Excel corruption errors, such as unrecognizable format, Excel found unreadable content in name.xls, Excel cannot open the file filename.xlsx, file name is not valid, the Excel file is corrupt and cannot be opened, etc. It provides a comprehensive solution for fixing Excel file issues.
Learn More
Preview the Repaired Excel File
The software shows a preview of the repaired Excel file and its recoverable contents in the main interface. This functionality allows you to verify the data in your repaired Excel file, including all of its objects, before saving the file. The Excel File Recovery software helps in determining the final state of data you will receive after repairing the corrupted Excel file.
Learn More
Recovers All Excel file Objects
The software repairs the corrupt Excel file and recovers all objects, including tables, charts, series trendline, conditional formatting rules, and properties of the worksheet. The software also recovers embedded functions, group & subtotal, engineering formulas, numbers, texts, rules, etc. It recovers Excel file data in its intact form.
Reviews & Feedback
Recommendation by Microsoft MVPs
OTHER IMPORTANT FEATURES
Know your Product Better
Option to Find Excel Files
Stellar Excel repair software helps users unaware of the Excel file location to search for all the Excel files on the computer. It provides ‘Find’ option to quickly locate and list all the Excel files for repair. You can select single or multiple files from the list that you want to repair.
Stellar Toolkit for File Repair
Stellar Toolkit for File Repair provides essential tools to repair corrupt Office files via a single interface. It comprises tools like MS Excel Repair, MS Word Repair, MS PowerPoint Repair, and PDF Repair to fix corrupt documents while maintaining the original file format.
Learn More
HOW TO USE STELLAR REPAIR FOR EXCEL
Screenshots & Video
PRICING
Choose The Best Plan
Excel Repair
Repairs corrupted Excel files with 100% integrity.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple Excel files
- Previews the repaired file
- Supports Excel 2021 & older versions
File Repair Toolkit
Repairs corrupted Excel, Word, PowerPoint, & PDF files.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple files
- Previews the repaired file
- Supports Excel 2021 & older versions
- Repairs .DOC & .DOCX files
- Repairs .PPT, .PPTX, & .PPTM files
- Repairs corrupted PDF file
Best Seller
File Repair Toolkit Technician
Repairs corrupted Excel, Word, PowerPoint, & PDF files up to 3 systems.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple files
- Previews the repaired file
- Supports Excel 2021 & older versions
- Repairs .DOC & .DOCX files
- Repairs .PPT, .PPTX, & .PPTM files
- Repairs corrupted PDF file
CUSTOMER REVIEWS
You’re in Good Hands
AWARDS & REVIEWS
Most tested. Most awarded
DATA SHEET
Technical Specifications
About Product
Stellar Repair for Excel
Version: | 6.0.0.7 |
License: | Single System |
Edition: | Standard, Technician, & Toolkit |
Language Supported: | English |
Release Date: | February, 2024 |
Processor: | Intel compatible (x64-based processor) |
Memory: | 4 GB minimum (8 GB recommended) |
Hard Disk: | 250 MB of Free Space |
Operating System: (64 Bit only) | Windows 11, 10, 8.1, 8, 7 |
USEFUL ARTICLES
Product Related Articles
How do I repair multiple Excel files by using Stellar Repair for Excel software?
After launching the software, click Select File button in the Home tab. Next, click Browse and select the checkbox against all the Excel files you need to repair. Then, click the Repair button to start repairing all the Excel files.
How do I see the Preview of repaired Excel file using the Demo version of the software?
Browse and select the file(s) to repair. The software will start scanning the Excel files once you click the Repair button. Next, it will display the files in the left pane. You can preview their contents in the right pane.
How do I find the recovered Excel file?
The software saves the repaired file with the prefix “Recovered” at the user-specified location. You can find the recovered file using the Search box utility in the taskbar.
Start Using Stellar Repair for Excel Today
- Trusted by Millions of Users
- Awarded by Top Tech Media
- 100% Safe & Secure to Use
Free download to scan and preview all recoverable Excel data.
How to Fix the #Value! Error in Excel?
Summary: #Value! is a common error that occurs when using formulas in Excel. It can be due to an issue with the cells you are referencing or use of formulas in the wrong type or format. This blog will discuss some cases when this error may occur and the solutions to fix the issue. You’ll also find about an Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.
You may experience the #Value! error in Excel when trying to enter invalid data type into the formulas. Sometimes, it appears when a value is not the expected type or when dates are given a text value. This Excel error may occur due to several reasons. However, the exact cause of this error is difficult to find. Below, we will be discussing some cases where you may get this error and the solutions to resolve the issues.
Case 1: Wrong Argument Data Type in Formulas
Sometimes, Excel throws the “#Value!” error if it recognizes incompatible arguments in the formulas.
For example: The Date function in the sheet expects only numerical values as arguments. In the below image you can see that when the formula’s string value is used in the month (January), it resulted in the #VALUE! error.
Solution
To fix the issue,
- Double-click the formula to verify the type of arguments.
- Correct the argument in the cell (B2).
The formula will work as expected.
Case 2: Using the Basic Subtraction Formula
Users often experience the #Value! error, when using the basic subtraction formula in Excel.
Solution
Check the formula and the type of values in the cell. If these are correct and the error persists, then follow these steps:
- Go to the Start button on Windows, type Control Panel, and double-click on it.
- Click Clock and Region > Region.
- On the Format tab, click Additional Settings.
- In the Customized Format window, search for List Separator.
- Check if the List Separator is set to minus (-). Change it to comma (,).
- Click OK.
- Now, open the Excel file and again try to use the formula.
Case 3: Wrong Text Value
The #Value! error can also occur due to the formula’s wrong value.
For example: If you are using the formula to add values in cells and Excel recognizes the unexpected text value, you may get a #Value error.
Solution
To fix the issue, you can correct the value or use the SUM function. It is recommended to use functions instead of operations to reduce the errors. In Excel, the formulas with math operators may not able to calculate the text in the cells. The SUM function automatically ignores the text value(er), calculates everything as numbers, and displays the result without the #Value! error.
Case 4: Blank Space in Cells
You may get the #Value! error if your formula refers to other cells with space or hidden space. Sometimes, spaces that make a cell display blank but actually they are not blank.
Solution
You can either delete the space or replace the blank space. Here’s how:
1. Delete the Blank Space
First, check if a cell is blank or not. To do this,
- Select the cell that looks blank.
- Press F2.
The blank cell won’t show space.
Then, press the Backspace key to delete the space. It will fix the error.
2. Replace Blank Space
You can also use the “Find and Select” option to replace the blank space in Excel. Here are the steps:
- Open the Excel file that shows #Value! error.
- On the Home tab, click Find & Select > Replace.
- In the Find what field, type a single space and delete everything in the “Replace with” field.
- Click Replace All > OK.
Case 4: Problem with Network Connection
Many users have reported experiencing errors when using Excel online due to problems with the network connection.
Solution
Check your Internet connection and see if it is working properly.
Case 5: Wrong Formula Format
If you enter the wrong formula with a missing parenthesis or comma, then Excel can throw the #Value! error. The error can also occur if the application finds a special character within a cell.
Solution
Correct the formula and use the ISTEXT function to find the cells with issues.
Case 6: Corruption in the Excel File
If none of the above works, then it indicates the Excel file is corrupt. The formulas in the Excel file do not work due to corruption.
Solution
You can use the Open and Repair utility in Excel if you are getting the error due to corruption in Excel file. In case the utility fails or the Excel file is severely corrupt, you can use a third-party Excel repair software, such as Stellar Repair for Excel. It is a powerful tool to repair corrupted or damaged Excel files and recover all its data, with 100% integrity. The tool supports Excel 2019, 2016, and older versions.
Closure
There are several reasons that can trigger Excel to throw the #Value! error. It can occur if there is an incorrect argument data type in formulas or blank space, text, or special characters within a cell. This blog discussed the possible scenarios when this error occurs. You can apply the solutions mentioned above to fix the error. If the #Value! error occurs due to corruption in the Excel file, then you can use Stellar Repair for Excel . It is a reliable tool that helps in fixing corruption-related errors in Excel.
Simple ways to Open Corrupt Excel file Without any Backup
Summary: The blog describes simple ways to open corrupt Excel file without any backup. It explains some manual workarounds that you can try to open the file. Also, it mentions about an Excel file repair tool that can quickly fix the corrupt file and recover data from it.
Do you have an Excel file that does not open because of corruption issue? And every time you try to open it, an error message ‘the file is corrupt and cannot be opened’ pops-up?
Excel File Corruption Message
Also, you don’t have a healthy backup of the Excel file to restore the data? If so, you can try repairing the corrupt file by using a few simple yet effective manual workarounds mentioned below.
How to Open a Corrupt Excel File without Backup?
Following are some manual methods that can help you open a corrupt Excel file:
Method 1: Repair Corrupt Excel File
When attempting to open a corrupt file, Excel automatically starts ‘File Recovery’ mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file.
To use this feature, perform the following steps:
Step 1: Open a Blank workbook in Excel, and then click File > Open.
Step 2: In the Open window, browse and select the corrupt file.
Step 3: Click the arrow that is beside the Open tab, and select Open and Repair.
Open and Repair Option
Step 4: Implement one of the following:
- Click the Repair button. (This is to recover as much data as possible.)
- Click the Extract Data button. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)
Excel Built-in Repair Options
If using Open and Repair does not work , move to the next method.
Method 2: Disable the Protected View Feature
Some Excel users have reported that turning off the ‘protected view’ feature in Excel helped them open the corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:
Step 1: Open a blank Excel file, click on File > Options.
Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.
Excel Trust Center Settings
Step 3: Click OK.
Now check if you can open the corrupt file. If not, try implementing the next method.
Method 3: Look For Automatically Recovered Excel File
If you have Excel’s AutoRecover feature enabled, you’ll have access to a copy of the Excel file corrupted or lost due to application crash, power outage, or accidental deletion.
The ‘AutoRecover’ feature saves Excel worksheets at a temporary location after a certain time interval. It saves the worksheets automatically and is turned on by default to reduce the chance of data loss.
Check if you can recover corrupted Excel file by following these steps:
Step 1: In Excel, open a Blank workbook.
Step 2: Go to File and click Options.
Figure 5 – Excel Options
Step 3: In the Excel Options dialog box, click Save, and then copy the ‘AutoRecover file location’.
Excel Options Window
Step 4: Open File Explorer window and paste the copied AutoRecover file location, and press Enter.
Step 5: A list of saved Excel files will be displayed. Choose the file you want to recover.
TIP: Use Excel’s AutoBackup feature to reduce chances of data loss, by saving a previous version of your spreadsheet automatically.
Use an Excel File Repair Software
If the above manual methods fail, repair the corrupt Excel file by using a third-party software, such as Stellar Repair for Excel**.** The software helps repair Excel (XLS and XLSX) files easily and effectively.
Read this: How to repair corrupt Excel file using Stellar Repair for Excel?
Some key features of Excel Repair software are as follows:
- Fixes all errors in the MS Excel file.
- Repairs multiple damaged Excel files in a go.
- Recovers chart, chart sheet, table, cell comment, image, formula, and sort & filter.
- Preserves properties and cell formatting of Excel worksheets.
- Previews recoverable Excel file data before saving.
- Recovers all data components from the corrupt files and saves them in a new blank Excel file.
- Compatible with Excel 2019, 2016, 2013, 2010, 2007, and lower versions.
Conclusion
You can try the workarounds discussed in the blog to open a corrupt Excel file without a backup. Disabling the protected view feature can help you open the file. If the issue persists then try repairing the corrupted Excel file using the Open and Repair utility. Although, it may not be able to fix a severely corrupted workbook. In such a case you can use Stellar Repair for Excel . It is an advanced tool that can help you repair a corrupted Excel file with 100% integrity.
Also read:
- How to recover lost data from Vivo X90S?
- How to retrieve erased call logs from Vivo Y27s?
- How To Get Out of Recovery on iPhone 13 mini? | Dr.fone
- How To Repair iOS System Issues of iPhone 7 Plus? | Dr.fone
- How to Recover Deleted iPhone 11 Pro Camera Roll Photos and Photo Stream Pictures? | Stellar
- How to remove Huawei Nova Y71 PIN
- How to recover deleted photos from Android Gallery after format on Galaxy XCover 7
- How to recover deleted photos from Android Gallery after format on C210
- How to recover old call logs from your Honor X7b?
- How to Rescue Lost Contacts from Lava Blaze 2 Pro?
- How To Restore Missing Music Files from C51
- How To Restore Missing Call Logs from Vivo T2 Pro 5G
- How to retrieve erased messages from Itel A05s
- How to Rescue Lost Messages from Vivo V27e
- How to Repair Broken video files of Motorola Edge 40 Neo on Mac?
- How to remove Google FRP Lock on Vivo S18 Pro
- How to Restore Deleted 11 5G Contacts An Easy Method Explained.
- How to Rescue Lost Music from Vivo Y78t
- How to Recover Deleted Photos from Android Gallery App on XR21
- 5 Easy Ways to Copy Contacts from Oppo Reno 11F 5G to iPhone 14 and 15 | Dr.fone
- How to recover deleted contacts from Itel A60.
- How to Realme 12 Pro 5G Get Deleted Phone Number Back with Ease and Safety
- How to Downgrade iPhone 6 without Losing Anything? | Dr.fone
- How to identify missing hardware drivers with Windows Device Manager on Windows 11/10/7
- How To Repair iPhone 6s iOS System Issues? | Dr.fone
- How to recover old messages from your Honor X50i
- How to Rescue Lost Videos from Vivo Y100i Power 5G
- How to Restore Deleted Vivo S17 Pro Photos An Easy Method Explained.
- How to fix error 1015 while restoring iPhone | Stellar
- 5 Easy Ways to Copy Contacts from Honor X9b to iPhone 14 and 15 | Dr.fone
- 5 Easy Ways to Copy Contacts from Infinix Hot 30i to iPhone 14 and 15 | Dr.fone
- How to Recover Data from Broken iPhone XR Screen | Stellar
- How To Get Out of Recovery on iPhone 15 Pro Max? | Dr.fone
- How to recover old music from your Vivo Y78 5G
- How to Restore Deleted Nokia XR21 Photos An Easy Method Explained.
- 4 Ways to Transfer Music from Realme 11 Pro+ to iPhone | Dr.fone
- How to recover deleted photos from Android Gallery without backup on OnePlus Nord CE 3 Lite 5G
- How to recover old music from your Vivo V29 Pro
- How to recover deleted photos after deleting from Recently Deleted on iPhone 11 Pro | Stellar
- How To Free Up iPhone 6s Space | Dr.fone
- 2 Ways to Transfer Text Messages from Infinix Smart 8 HD to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How To Restore Missing Contacts Files from Vivo V30 Lite 5G.
- How to restore wiped call history on 11 Pro+?
- How To Restore Missing Call Logs from 105 Classic
- How to Rescue Lost Contacts from Itel P40+?
- How To Transfer Data From iPhone 12 mini To Other iPhone 14 Pro devices? | Dr.fone
- How to Sign .odt file document with Electronic Digital Signature - (Tutorial)
- How to Rescue Lost Contacts from Tecno Pova 5?
- How to recover old music from your Samsung Galaxy S23 FE
- Does Airplane Mode Turn off GPS Location On Poco C51? | Dr.fone
- Possible solutions to restore deleted messages from Samsung Galaxy A25 5G
- In 2024, How Can You Transfer Files From Infinix Smart 8 To iPhone 15/14/13? | Dr.fone
- In 2024, How to Unlock Infinix Hot 40i Phone without PIN
- Process of Screen Sharing Motorola G54 5G to PC- Detailed Steps | Dr.fone
- In 2024, Ways to stop parent tracking your Samsung Galaxy S23 Tactical Edition | Dr.fone
- This is how you can recover deleted pictures from Motorola Moto G84 5G.
- Updated The Best of the Best Free VOB Video Editing Software
- Proven Ways to Fix There Was A Problem Parsing the Package on Samsung Galaxy XCover 6 Pro Tactical Edition | Dr.fone
- How to Reset a Samsung Galaxy M34 Phone That Is Locked | Dr.fone
- In 2024, A Guide Poco X6 Wireless and Wired Screen Mirroring | Dr.fone
- 9 Quick Fixes to Unfortunately TouchWiz has stopped Of Oppo Reno 8T | Dr.fone
- In 2024, How to Spy on Text Messages from Computer & OnePlus 11R | Dr.fone
- How to Stop Google Chrome from Tracking Your Location On Xiaomi Redmi 12 5G? | Dr.fone
- Top 11 Free Apps to Check IMEI on iPhone 7
- In 2024, The 6 Best SIM Unlock Services That Actually Work On Your Vivo V27e Device
- Updated In 2024, Elevate Your Job Search The Best Video Resume Makers Free
- Latest way to get Shiny Meltan Box in Pokémon Go Mystery Box On Realme GT 5 Pro | Dr.fone
- How to Unlock iCloud lock on your iPhone SE and iPad?
- In 2024, Does find my friends work on OnePlus Nord N30 5G | Dr.fone
- 9 Solutions to Fix Process System Isnt Responding Error on OnePlus Open | Dr.fone
- In 2024, Ways to trade pokemon go from far away On Nokia XR21? | Dr.fone
- Unova Stone Pokémon Go Evolution List and How Catch Them For Vivo Y36i | Dr.fone
- How to Find iSpoofer Pro Activation Key On Realme C67 5G? | Dr.fone
- Updated In 2024, Windows Movie Maker Replacements 6 Best Editing Tools
- 7 Solutions to Fix Chrome Crashes or Wont Open on Oppo Reno 9A | Dr.fone
- A How-To Guide on Bypassing Apple iPhone 7 iCloud Activation Lock
- Top 4 Ways to Trace Vivo Y56 5G Location | Dr.fone
- How to Unlock iPhone XR With an Apple Watch & What to Do if It Doesnt Work | Dr.fone
- 15 Best Strongest Pokémon To Use in Pokémon GO PvP Leagues For Motorola Moto E13 | Dr.fone
- List of Whatsapp Video Format That You May Need to Know
- Complete Tutorial for Vivo T2 Pro 5G Hard Reset | Dr.fone
- In 2024, 8 Ways to Transfer Photos from Realme Narzo 60x 5G to iPhone Easily | Dr.fone
- In 2024, Top 7 Phone Number Locators To Track Realme 11 Pro Location | Dr.fone
- In 2024, How to Transfer Contacts from Vivo Y02T to Outlook | Dr.fone
- In 2024, Will Pokémon Go Ban the Account if You Use PGSharp On Samsung Galaxy F34 5G | Dr.fone
- What to Do if Google Play Services Keeps Stopping on Vivo X Fold 2 | Dr.fone
- The Magnificent Art of Pokemon Go Streaming On Motorola Defy 2? | Dr.fone
- Title: How to fix runtime error 424 object required error in Excel 2021 | Stellar
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-20 18:32:11
- Link: https://blog-min.techidaily.com/how-to-fix-runtime-error-424-object-required-error-in-excel-2021-stellar-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.