Error Solved Excel 2021 file is not in recognizable format | Stellar

Error Solved Excel 2021 file is not in recognizable format | Stellar

Nova Lv13

[Error Solved] Excel file is not in recognizable format

Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.

Free Download for Windows

Excel file is not in a recognizable format

Figure: Error message

From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.

While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.

What is this error all about?

The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.

Reasons behind the error

  1. One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
  2. Another reason can be that the latest service pack might not be in use on your system.
  3. There could be MS Excel version change.
  4. Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.

If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.

How do you go about fixing this?

Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:

  1. Right-click on .XLS (you can use any .XLS files in your system).
  2. A new dialogue will appear. Here, click on “Choose another app” to select it.

Choose Another App

Figure: choose another app

  1. You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
  2. You do not have to choose any of the prepopulated apps from the list.

Look for another app

Figure: Look for another app

  1. Navigate using the Look for another app on this PC  to the path “C:\Program Files\Microsoft Office\OfficeVersion”
  2. You will see a file name MOC.exe
  3. Choose that and complete your export.
  4. Try opening the workbook in Excel and the error should now be resolved.

Solution 2: Opening the file from within the Excel:

  1. Open a new Excel workbook.
  2. Press “Alt + F” or alternatively, go to the menu.
  3. Once you are in the menu, go to Options.
  4. You will be able to see a number of tabs on the left side of the options.
  5. Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.

Manual option

Figure: Manual option

  1. Click OK and save the changes to the workbook.
  2. Now, browse for the file which was corrupted.
  3. Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.

Open and Repair

Figure: Open and Repair

  1. Once the file has been imported, click on “Repair” to recover the data from the selected workbook.

Repair Option -Excel File

Figure: Repair option

Solution 3: Use automated Excel repair software

If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.

  1. Download, install and launch Stellar Repair for Excel.
  2. Allow the software to scan the corrupted Excel file.
  3. All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
  4. Select and recover individual or entire data from the file and save as a new Excel.

This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.

Wrapping it up

Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.

Summary: This blog discusses why hyperlinks won’t work in Excel and solutions to fix it. If nothing works, try using Stellar Repair for Excel software to recover your workbook with hyperlinks and all the data intact.

Free Download for Windows

Hyperlinks in your Excel file could be references to a file’s location on the computer or a location within the same worksheet. Or, hyperlinks might be pointing to a URL. Sometimes, the hyperlinks won’t work and any of the following errors may pop up on your screen on clicking a hyperlink:

‘Cannot open the specified file.’

Cannot open the specified file

‘This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.’

This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator

Here are some of the possible causes behind the ‘hyperlinks not working’ issue and solutions to fix it:

Cause 1 – Change in the name of the hyperlinked file

If the file name that appears in the hyperlink text is different than the actual file name, it will prevent the hyperlink from working.

Ensure that the links in the Excel file are updated and points to the renamed file. For this, right-click the hyperlink and select ‘Edit the hyperlink’. Next, in the hyperlink address, replace the current filename with the renamed one in the hyperlink address.

Cause 2 – File name has a pound (#) sign

When you create a hyperlink for a file in Excel, you cannot use a pound character (#) in the file name that appears in the hyperlink. That is because the pound sign is not accepted in hyperlinks and may lead to the ‘Cannot open the specified file’ error.

Note: While you can use a pound character in a file name, it cannot be used in hyperlinks in an MS Office document.  

Solution – Rename the file name and remove the pound sign

Open the file that contains the ‘#’ sign and rename it by following these steps.

  • Right-click the cell containing the hyperlink that is not working, and click Edit Hyperlink.
  • From the Address box, copy the address of the file you are linking to.
  • Go to the location where the file is stored, right-click on the file, and click Rename.
  • Remove the ‘#’ character from the name of the file.
  • Go back to the Excel file, right-click on the problematic hyperlink, and choose Edit Hyperlink. Next, browse and select the renamed file.
  • The renamed file without the pound sign will be added in the Address box.
  • Click OK.

Now try opening the hyperlink.

Cause 3 – Sudden system shutdown causes abrupt closing of Excel

There may be a discrepancy in the data in hyperlinks when a system shut down suddenly, without properly closing the Excel file. And so, when trying to open a link, it won’t open.

There is an inbuilt option in Excel to update hyperlinks every time the workbook is saved. Follow these steps to enable that option:

Note: The steps may vary based on the Excel version you are using.

For Excel 2013, 2016, or 2019:

  • Open Excel Workbook -> Go to File->Options->Advanced
  • Scroll down to find the General tab and click on Web Options
  • Web Options Window pops-up
  • In the Web Options Window, go to Files Tab and select the ‘Update Links on save‘ checkbox
  • Click on OK button and your option is saved

The steps are also explained in the image below:

![Select Update links on Save in Web Options window](https://cdn-cmlep.nitrocdn.com/DLSjJVyzoVcUgUSBlgyEUoGMDKLbWXQr/assets/images/optimized/rev-2658c43/www.stellarinfo.com/blog/wp-content/uploads/2017/09/Uncheck-the-option-to-save-Hyperlinks.jpg)

For Excel 2007:

  • Click the Office button
  • Select Excel Options, then follow Step 1) to Step 5), as mentioned above and get the Excel Hyperlinks to work again.

If you fail to make Excel hyperlinks work using the above-discussed solutions, use an Excel repair tool to fix the hyperlinks issue. Download the Stellar Repair for Excel to repair an XLS/XLSX file and restore the hyperlinks.

Free Download For Windows

See the working of the tool here:

The tool recovers all components of the Excel file including tables, charts, chart sheets, cell comments, images, formulas, and more. You can repair multiple worksheets and fix all dysfunctional Excel hyperlinks across multiple worksheets in a single workbook. Click on the workbook, select all worksheets and start repairing

Conclusion

Carefully read the possible causes behind the ‘Excel Hyperlinks not working’ issue to understand what resulted in the issue in the first place. If nothing helps, use Stellar Repair for Excel to restore the hyperlinks and save the result in a new Excel file, without interfering with worksheet properties and cell formatting.

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?

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.

Learn More arrow

Excel File Not Opening Due to Corruption?

Is-MDF-File-Header-Corrupted

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.

Learn More arrow

Excel Found Unreadable Content?

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.

Learn More arrow

KEY FEATURES FOR REPAIR FOR EXCEL

Software Important Capabilities

Repair Large-sized Excel Files

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

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

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

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

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

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

left quote

right quote

AWARDS & REVIEWS

Most tested. Most awarded

q1 q1

DATA SHEET

Technical Specifications

product Icon

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

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.

Learn More

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.

Learn More

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.

Learn More

Stellar Repair for Excel

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.

[Error Solved] Excel file is not in recognizable format

Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.

Free Download for Windows

Excel file is not in a recognizable format

Figure: Error message

From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.

While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.

What is this error all about?

The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.

Reasons behind the error

  1. One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
  2. Another reason can be that the latest service pack might not be in use on your system.
  3. There could be MS Excel version change.
  4. Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.

If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.

How do you go about fixing this?

Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:

  1. Right-click on .XLS (you can use any .XLS files in your system).
  2. A new dialogue will appear. Here, click on “Choose another app” to select it.

Choose Another App

Figure: choose another app

  1. You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
  2. You do not have to choose any of the prepopulated apps from the list.

Look for another app

Figure: Look for another app

  1. Navigate using the Look for another app on this PC  to the path “C:\Program Files\Microsoft Office\OfficeVersion”
  2. You will see a file name MOC.exe
  3. Choose that and complete your export.
  4. Try opening the workbook in Excel and the error should now be resolved.

Solution 2: Opening the file from within the Excel:

  1. Open a new Excel workbook.
  2. Press “Alt + F” or alternatively, go to the menu.
  3. Once you are in the menu, go to Options.
  4. You will be able to see a number of tabs on the left side of the options.
  5. Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.

Manual option

Figure: Manual option

  1. Click OK and save the changes to the workbook.
  2. Now, browse for the file which was corrupted.
  3. Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.

Open and Repair

Figure: Open and Repair

  1. Once the file has been imported, click on “Repair” to recover the data from the selected workbook.

Repair Option -Excel File

Figure: Repair option

Solution 3: Use automated Excel repair software

If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.

  1. Download, install and launch Stellar Repair for Excel.
  2. Allow the software to scan the corrupted Excel file.
  3. All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
  4. Select and recover individual or entire data from the file and save as a new Excel.

This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.

Wrapping it up

Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.

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

Free Download for Windows

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

Excel found a problem with one or more formula references

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)

www.sentrypc.com

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

Error Checking

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

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…

Edit links

  • 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.’

Stellar Repair for Excel

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.

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.

Free Download for Windows

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.

Image of #Value! error in Date Function

Solution

To fix the issue,

  • Double-click the formula to verify the type of arguments.

Image of Solution to fix #Value! error in Excel

  • Correct the argument in the cell (B2).

Image of Correcting Argument In Cell to fix #Value! error in Excel

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.

Image of #Value! error in Excel in Subtraction Formula

Solution

Check the formula and the type of values in the cell. If these are correct and the error persists, then follow these steps:

Image of Correcting Basic Subtraction Formula to fix #Value! error in Excel

  • Go to the Start button on Windows, type Control Panel, and double-click on it.
  • Click Clock and Region > Region.

Image of Clock And Region Window in Control Panel to #Value! error in Excel

  • On the Format tab, click Additional Settings.

Image of Region Window For Additional Settings

  • In the Customized Format window, search for List Separator.

Image of Customize Format Window

  • Check if the List Separator is set to minus (-). Change it to comma (,).

Image of Apply List Seperator In Customize Format Window

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

Image of #Value! error in Excel because of Wrong Text Value

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.

Image of Highlighting Arguments Of-Sumfunction to fix #Value! error in Excel

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

Image of #Value! error in Excel because of Blank Space

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.

Image of Blank cell Not Showing Space and hence the #Value! error in Excel

The blank cell won’t show space.

Then, press the Backspace key to delete the space. It will fix the error.

Image of space removed to fix the #Value! error in Excel

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.

Image of Find And Select Option

  • In the Find what field, type a single space and delete everything in the “Replace with” field.

Image of Find And Replace Window

  • Click Replace All > OK.

Image of Result After Replacement With Find-And Select Window

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.

BLUETTI NEW LAUNCH AC180T

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.

[Solved] : How to Fix MS Excel Crash Issue

Microsoft Excel may stop responding , hang, freeze, or stop working due to several reasons, such as in compatible add-ins. In such a case, you may receive one of the following error messages.

  • Excel has stopped working

Excel has stopped working

  • Excel is not responding

Excel is not responding

  • A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.

A problem caused the MS Excel to stop working correctly

Why Does Excel Keep Crashing?

If Excel keeps crashing on your PC while opening a workbook, saving Excel file, scrolling or editing cells, etc., it indicates a problem with your Excel program or the Excel file.

Microsoft Excel may crash due to any one or more reasons given below,

  •  Incompatible Add-Ins
  • Outdated MS Excel program
  • Conflict with other programs or antivirus tool
  •  Excel file created by third party software
  • Problem with network connection
  •  Combination of Cell formatting and stylings
  • Problem with MS Office installation
  • Partially damaged or corrupt Excel file

Problems Caused by Excel Crash Issue

Microsoft Excel crash may cause damage to Excel file and also lead to Excel (XLS/XLSX) file corruption.

Such corrupt Excel files can’t be opened or accessed via MS Excel app. If you try to access a corrupt Excel file, MS Excel may fail to open the file or stop responding and crash. Additionally, you may receive the following or similar error message,

Excel files can't be opened or accessed

In such a case, you should immediately try to recover the Excel file. You may do so by restoring the Excel file from backup or by using an Excel File Repair software. Otherwise, continue following this guide.

How to Solve Excel Crash Issue?

Before heading to solutions, follow these troubleshooting steps to resolve the Excel Crash issue.

Step 1: Copy File to Local Drive

If you are trying to access and edit or view an Excel file from a network drive, try moving the file to local drive. This will help you find if there is something wrong with the file or the network.

Step 2: Ensure Sufficient Memory

Excel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application.

Ensure Sufficient Memory

If you often work with large Excel files and complex data values& formulas, then install 64-bit versions of MS Office. It will give you an advantage of larger processing capacities and prevent Excel from crash or freeze.

Step 3: Check If Excel is Open and In Use by Another Process

Open Task Manager and close all processes or apps (tasks) that may be using or have access to your Excel file that you are working on. You can find this detail in status bar of Excel program at the bottom of program window.

Task Manager

After closing the tasks, try to access the Excel file and check if this fixes the performance and crash problem in Excel.

Step 4: Test and Repair Excel File

Create a copy of the Excel file and install Stellar Repair for Excel software. It’s free to download. Scan and repair your Excel file using the software. After repair, save the Excel file at your desired location and then open the Excel file in the MS Excel program.

Stellar Repair for Excel software

This should ideally fix all the issues with Excel.

However, if the Excel program still crashes, the problem lies within the system or program. Follow the solutions discussed in this guide to try to fix the Excel crash issue.

NOTE: To save repaired Excel file using the mentioned software, you must purchase the activation key and activate it.

Solutions to Fix MS Excel Crash Issue

Following are some solutions to resolve problems with MS Excel such as,

  • Excel not responding
  • Excel won’t open
  • Excel keeps crashing

Follow these solutions in the given order. In case a method doesn’t work, move to the next one.

Solution 1: Restart Excel in Safe Mode

By starting MS Excel in safe mode, you can run the program without loading the Excel add-ins and with limited features. But COM add-ins are excluded.

To launch Excel in safe mode, close MS Excel and follow these steps,

  • Create a shortcut of MS Excel (.exe) on Desktop
  • Press and hold the Ctrl key while launching the program
  • Click ‘Yes’ when a prompt appears to confirm

Alternatively, press Windows+R, type excel /safe and press ‘Enter’. Use this to open Excel in safe mode on Windows 10, 8.1, 8, or 7 system.

type excel /safe

Now try to open and access the Excel file and check if the issue is resolved. If it’s not, head on to the next solution.

Solution 2: Check and Remove Faulty Add-ins

In case Excel doesn’t crash in Safe Mode, it’s possible that some faulty add-ins are the culprit behind frequent Excel crash and freeze. These Excel add-ins may interfere or conflict with the Excel program.

Check and Remove Faulty Add-ins

Find and remove the faulty add-in. It can resolve the issue. To do so, follow these steps,

  • Restart Excel in normal mode and go to File> Options> Add-ins
  • Choose COM Add-ins from the drop-down and click Go

COM Add-ins

  • Uncheck all the checkboxes and click OK

Uncheck all the check boxes

  • Restart Excel and check if the issue is resolved
  •  If Excel doesn’t crash or freeze anymore, open COM Add-ins and enable one add-in at a time followed by Excel restart. Then observe Excel for freeze or crash problem

This will help you find out the faulty add-in, which is causing the problem. Remove the add-in which is causing the problem to resolve the issue. If that doesn’t fix, move to the next solution.

Solution 3: Check and Install the Latest Updates

If you haven’t set Windows to Download and Install Updates automatically, do it now.

Apart from updating the operating system, latest Windows updates sometimes fixes bugs for other applications installed on the system such as MS Office. Often installing an important update that you might have missed may correct the Excel crash problem.

You can also update MS Office manually. Follow these steps,

Go to File > Account

 Under Product Information, select Update Options and click Update Now

Product Information

If you have installed MS Excel from Microsoft Store, open the store and update your Office applications.

NOTE: This also works if you can’t open Excel file or Excel crashes after Windows upgrade from Windows 7 or Windows 8/8.1 to Windows 10.

After installing the latest MS Office updates, check if Excel works fine. If not, head to the next solution.

BLUETTI NEW LAUNCH AC180T

Solution 4: Clear Conditional Formatting Rules

If a sheet is causing Excel to freeze or crash, there might be a problem with that particular sheet. In such a case, you may try clearing the Conditional Formatting rules. The steps are as follows,

  • Under Home, click ‘Conditional Formatting > Clear Rules> Clear Rules from Entire Sheet’

Conditional Formatting

  • You may repeat this step for all other sheets in the Excel workbook
  • Then click File> Save as and save the Sheet as a new file at a different location

This avoids overwriting or making changes to the original Excel file. Once done, try working on the sheet.

If this doesn’t work out, move to the next solution.

Solution 5: Remove Multiple Cell Formatting and Styles

If a workbook is being shared and edited by others on different platforms then it’s possible that many cells are formatted differently. This can cause issues with Excel such as crash and freeze. It can also lead to Excel file corruption. The problem mostly occurs when a workbook contains multiple worksheets using different formatting.

You can follow this guide to remove different cell formats and styles, and then open the Excel file.

Solution 6: Disable Microsoft Excel Animation

Animations require additional processing power and resources. By disabling animations in Excel, you may resolve Excel freeze and crash issue. This also improves MS Excel performance.

To disable the animations in MS Excel, follow these steps:

  • Go to File > Options
  • Click ‘Advanced’ and check ‘Disable hardware graphics acceleration’animation

Disable hardware graphics acceleration

  • Click ‘OK’ to close the window and then restart MS Excel

This has helped many users in fixing the Excel crash issue. If it doesn’t work for you, head to the next solution.

Solution 7: Check If Excel File is Generated by a Third-Party Application

There are applications which you may have used to generate Excel files to fetch data. For instance, downloading data from Google Analytics in Excel format.

Sometimes, these Excel files are not generated correctly by such third-party apps. Thus, some features in Excel may not work as intended when you access the files in MS Excel.

In such a case, you should get in touch with the app developer for help with the file or use Stellar Repair for Excel to repair such Excel files.

Solution 8: Check If Antivirus or Other Apps are Conflicting with MS Excel

Ensure your antivirus is up-to-date and not conflicting with MS Excel. An outdated antivirus tool may conflict with Excel which can cause the application to hang, freeze, or crash.

  • Update your antivirus
  • Try disabling the add-in or integration between Excel and antivirus. See if it works

Alternatively, you may disable the anti-virus tool temporarily to check if it is the culprit behind Excel performance issue and crash. If that resolves the problem, get in touch with your antivirus vendor and report the problem.

They might provide you with a better solution or workaround to fix this problem without disabling the antivirus protection.

IMPORTANT NOTE: Disabling or altering antivirus protection makes your PC vulnerable to malicious attacks and virus or malware intrusion.

Solution 9: Clean Boot Windows to Inspect the Cause Behind Excel Crash

When Windows boot, it starts several processes, services, and application during start up automatically, which runs in the background.

These startup apps and services can interfere with other applications such as MS Excel. To find out if that’s the cause behind Excel crash, you can perform a Clean Boot.

This helps you identify processes, services, or applications that are conflicting with Excel. Steps to perform Clean Boot are as follows,

  • Press Windows key + R, type MSConfig, and press ‘Enter’
  • In System Configuration window, click on the General tab and choose Selective startup

System Configuration

Uncheck ‘Load startup items’ and click ‘OK’

After this, close all running applications and restart your PC

Check if the crash problem with Excel is resolved. Uninstall the conflicting apps or update them. If your issue is not resolved, follow the next solution.

Solution 10: Repair or Reinstall MS Office

Repairing Office programs may also resolve Excel crash issues if caused by damaged MS Excel program or MS Office files. The steps are as follow,

  • Close all MS Office apps and open the Control Panel
  • Click Uninstall a program under Programs

Uninstall a program

  • Click on Microsoft Office and then click on the Change option
  • Choose ‘Quick repair’ and then select ‘Repair’
  • Click ‘Continue’ to repair MS Office installation

You may also try ‘Online Repair’ if this fails to fix the issue. After repair, if the Excel issue persists, reinstall MS Office.

Need More Help?

If none of the above-mentioned solutions worked for you, it indicates that the problem is not with the Excel program but with the Excel file. If you haven’t tried the Stellar Repair for Excel software, do it now.

Select the Excel file which is causing the problem and repair it with the software. It’s a powerful Excel repair software that can fix all the problems with Excel files (XLS/XLSX). It repairs corrupt and severely damaged Excel files.

The software is compatible with all Excel files created using MS Excel 2019, 2016, 2013, 2010, 2007, 2003 or 2000.

After repairing and saving the Excel file, you can open it in your MS Excel program and work on it without any performance issue. To know more about this software, visit this page.


  • Title: Error Solved Excel 2021 file is not in recognizable format | Stellar
  • Author: Nova
  • Created at : 2024-07-17 17:10:28
  • Updated at : 2024-07-18 17:10:28
  • Link: https://phone-solutions.techidaily.com/error-solved-excel-2021-file-is-not-in-recognizable-format-stellar-by-stellar-guide/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Error Solved Excel 2021 file is not in recognizable format | Stellar