![How to Fix a Corrupted {{excel-ext}} File? The Everything Guide | Stellar](https://www.lifewire.com/thmb/M6MEEf2A7TVTzphPjYFZQ34ewjs=/540x405/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)/man-attaching-action-camera-to-chest-664655587-5c8c2559c9e77c0001ac184b.jpg)
How to Fix a Corrupted {{excel-ext}} File? The Everything Guide | Stellar
![](/images/site-logo.png)
How to Fix a Corrupted .xls File? The Everything Guide
Undoubtedly, Excel is so powerful that it can help you to process, analysis, and store data, in masses.
That’s the reason it has been there for years and helping this world in data.
But…
With all those powers comes some nasty problems which no Excel users like to face. Can you guess what I’m talking about?
Think about a Corrupted Excel File. Nightmare? Isn’t it?
And do you remember that last time when you have opened a workbook and you got a message that this workbook is might corrupt?
The TRUTH is, this is something which you cannot avoid, but, you can prepare yourself in the best way and deal with it like a PRO.
So today, in this post, I’d like to share with you to everything you need to know about a corrupt Excel file (.xls), why it happens, how to fix it like a PRO, and much more.
…let’s get started.
Note: In this post, we’ll be covering the .xls version (which is the extension for the file which is created in Excel 2007 or the earlier versions) and if you want to know about the new version, here’s the quick fix for that.
Why My Excel File Got Corrupted?
There can be one or multiple reasons for an Excel file to get corrupted. Below I have detailed about some of the major of them.
1. Large Excel File
You can store data in a workbook the way you want but sometimes using excessive thing can make an Excel file bigger in size.
And that kind of data files can crash at any point in time. Here are a few things which make the Excel files heavy, like
- Conditional Formatting.
- Colors formatting.
- Using merged cells in place of text alignment.
- Volatile functions: Formulae that iterate every time you open or change a cell value; OFFSET, NOW.
- Using a complete column or row as a reference than the data set range.
- Using complex formulas; VLOOKUP in place of Index/Match, Nested If in place of MAXIFS, MINIFS.
- Calculations or reference across workbooks.
Related: How to Fix Formatting Issues in Excel
2. Abrupt System Shutdown
Shutting down the system without following the procedure can corrupt your data file.
This shut down can be due to a power failure or any other unexpected technical challenges.
So it is always important to follow the procedures and shut down your system properly to avoid data losses.
3. Infected Excel File (Virus Attack)
This is the most common and obvious reason for Excel file corruption.
Although we always keep our system safe using various Antiviruses, still there is always a probability of virus attacks and loss of important files.
It is always advised to use a safe and strong antivirus compatible with your system requirements.
What are the Signs to Know When an Excel File is Corrupted?
In this section, we will discuss what are the signs which you can get when an Excel file is corrupted, let’s dig into it.
1. The File is Corrupt and Cannot Be Opened
This is one of the most common messages you can see when your workbook is corrupted.
But there is also a chance that it is just because of the version compatibility where you have a .xls file but you are using the latest version of Excel check out this detailed post by Priyanka
2. We Found a Problem with some Content in this File…
There’s another error message which you can get while opening a file:
We Found a Problem with some content in Do you want us to recover as much as we can? If you trust the source of this workbook, click yes.
There are a lot of applications out there (I think almost every) which exports the data as a .xls format. Those files have a greater chance of having this kind of error.
3. “Filename.xls” cannot be accessed
There can also be a situation where you get the error:
“Filename.xls” cannot be accessed. The file may be corrupted, located on a server that is not responding.
Well, this message is a bit misleading.
You won’t be able to decide that your file is actually corrupted or just not on the location.
My Excel File Got Corrupted, now What Should I Do?
There are many ways to recover the data from the corrupt excel files. But before you start, it is always advised to create a copy of the corrupted file.
You can save a lot of time with Stellar Repair for Excel, which make data recovery just with few clicks.
But before you go for a data recovery software, let’s try out some manual steps which can help.
When a workbook get corrupted the first thing comes to the mind is to recover data from it…
…and you what there’s a simple option there in the Excel which you can use to do this. Below are the steps you need to follow:
- First of all, open the Excel and click on the office icon.
After that, go to the “Open” and select the file which is corrupted.
Now, click on the open drop-down and select “Open and Repair”.
- At this point, you have two options:
- Repair File
- Extract Data
Let’s get into both of these options one by one…
1. Repair File
This option helps you to repair the file and the moment you click on it it takes a few seconds afterward and shows you the result with a message box and also provide you a log file.
And once it is done with repairing, you’ll get your file opened and you can save that file as a new copy.
Yes, that’s it.
2. Extract Data
If somehow you aren’t able to get your file repaired, you can also extract data from that file using “Extract Data” option.
Even in this option, you can get data in two ways.
- As Values
- With Formulas
In the first option, Excel simply extracts data as value ignoring all the formulas driving those value (which is the best way if you just need to have that data back ).
But in the second option, Excel tries to recover the formulas as much as possible.
Check out this smart technique by Jyoti which you can use it you aren’t able to recover data from the file.
Preventions to Not to have any Excel File Go Corrupt in Future
Future is fragile, what I’m trying to say is the more you work in Excel and process data there could be a chance that your workbook goes corrupt.
If there’s no security then what an EXCEL POWER user should do?
Well, there are few things which you can do or take care of while working with Excel so that you won’t have to worry about corruption of Excel workbooks.
Let’s see what you can do…
1. Change Recalculation Option
Now here’s the thing when you work with a hell lot of data, there a common thing that you gotta using formulas. Right?
But, the thing these formulas are something which makes your Excel file slows down sometimes make them go corrupt.
There’s one small tweak you can do in your workbook is change the calculation method.
Now with the manual calculation, you just need to whenever you open your file it won’t recalculate all the formulas.
And when you update your data you can simply click on the “Calculate Now” and it will calculate all the formulas again.
Quick Tip: Beware of Volatile Functions and use them with caution as recalculates them every time you change something in the worksheet.
2. Use VBA Codes Instead of Formulas
Now, this is what I do when I need to use complex formulas in a workbook.
Here’s how you can do this: Let’s say you have a formula in the cell A1, like below, which calculates the age.
=“You age is “& DATEDIF(Date-of-Birth,TODAY(),”y”) &” Year(s), “& DATEDIF(Date-of-Birth,TODAY(),”ym”)& “ Month(s) & “& DATEDIF(Date-of-Birth,TODAY(),”md”)& “ Day(s).”
Now, instead of simply entering it into the cell A1 which I would write a macro code which inserts this formula into the cell A1 and then convert it into the a value.
Here’s the code:
Sub CalculateAge()
Range(“B1”).Value = _
“=””Your age is “”” & _
“&DATEDIF(A1,TODAY(),””y””)” & _
“&”” Year(s), “”” & _
“&DATEDIF(A1,TODAY(),””ym””)” & _
“&”” Month(s), and “”” & _
“&DATEDIF(A1,TODAY(),””md””)” & _
“&”” Days(s).”””
Range(“B1”) = Range(“B1”).Value
End Sub
Note: To write these code you need to have basic understading of VBA (make sure check out this guide for this).
3. Use a File Recovery Application
Recently we asked a quick question to our readers on ExcelChamps that if they have ever faced a situation where they got a corruption message in Excel.
You’ll be astonied to hear that 50% percent of the people said “YES” they faced this thing in the past.
Now, this is alarming, if you are heading a team or you have a bunch of people in your company who use Excel…
…there’s a high probability that half of them gonna face this issue. So the best way to deal with this to have an App FIX your Excel file for you.
With STELLAR REPAIR FOR EXCEL, you just need a few clicks, yes that’s right. Let me show you with the below steps:
- First of all, download the app and install it (it’s simple).
- After that, open the app and click on the “Browse” and simply select the file which is corrupted.
- In the end, click on the REPAIR to let the Excel repair software fix your file (it takes a few seconds).
Once you complete repairing your file, you’ll get a message in your on the status bar and after that, you can open your file.
Final Thoughts
If you are a POWER Excel user then there’s a must for you to have known how to deal with a situation where you got a corrupt Excel file.
But I must recommend you to TRY OUT Stellar Repair for Excel so that’s you don’t have to worry about your Excel files anymore.
I’m sure you found this post helpful, and please don’t forget to share this tip with your colleagues, I’m sure they’ll appreciate it.
[Fixed] Excel VBA Runtime Error 9: Subscript Out of Range
Summary: The runtime error 9 in Excel usually occurs when you use different objects in a code or the object you are trying to use is not defined. This post will discuss the reasons behind the Excel VBA error “Subscript out of Range” and the solutions to resolve the issue. It will also mention an Excel repair tool that can help fix the error if it occurs due to corruption in worksheet.
Many users have reported encountering the error “Subscript out of range” (runtime error 9) when using VBA code in Excel. The error often occurs when the object you are referring to in a code is not available, deleted, or not defined earlier. Sometimes, it occurs if you have declared an array in code but forgot to specify the DIM or ReDIM statement to define the length of array.
Causes of VBA Runtime Error 9: Subscript Out Of Range
The error ‘Subscript out of range’ in Excel can occur due to several reasons, such as:
- Object you are trying to use in the VBA code is not defined earlier or is deleted.
- Entered a wrong declaration syntax of the array.
- Wrong spelling of the variable name.
- Referenced a wrong array element.
- Entered incorrect name of the worksheet you are trying to refer.
- Worksheet you trying to call in the code is not available.
- Specified an invalid element.
- Not specified the number of elements in an array.
- Workbook in which you trying to use VBA is corrupted.
Methods to Fix Excel VBA Error ‘Subscript out of Range’
Following are some workarounds you can try to fix the runtime error 9 in Excel.
Method 1: Check the Name of Worksheet in the Code
Sometimes, Excel throws the runtime error 9: Subscript out of range if the name of the worksheet is not defined correctly in the code. For example – When trying to copy content from one Excel sheet (emp) to another sheet (emp2) via VBA code, you have mistakenly mentioned wrong name of the worksheet (see the below code).
1 | Private Sub CommandButton1_Click() |
When you run the above code, the Excel will throw the Subscript out of range error.
So, check the name of the worksheet and correct it. Here are the steps:
- Go to the Design tab in the Developer section.
- Double-click on the Command button.
- Check and modify the worksheet name (e.g. from “emp” to “emp2”).
- Now run the code.
- The content in ‘emp’ worksheet will be copied to ‘emp2’ (see below).
Method 2: Check the Range of the Array
The VBA error “Subscript out of range” also occurs if you have declared an array in a code but didn’t specify the number of elements. For example – If you have declared an array and forgot to declare the array variable with elements, you will get the error (see below):
To fix this, specify the array variable:
1 | Sub FillArray() |
Method 3: Change Macro Security Settings
The Runtime error 9: Subscript out of range can also occur if there is an issue with the macros or macros are disabled in the Macro Security Settings. In such a case, you can check and change the macro settings. Follow these steps:
- Open your Microsoft Excel.
- Navigate to File > Options > Trust Center.
- Under Trust Center, select Trust Center Settings.
- Click Macro Settings, select Enable all macros, and then click OK.
Method 4: Repair your Excel File
The name or format of the Excel file or name of the objects may get changed due to corruption in the file. When the objects are not identified in a VBA code, you may encounter the Subscript out of range error. You can use the Open and Repair utility in Excel to repair the corrupted file. To use this utility, follow these steps:
- In your MS Excel, click File > Open.
- Browse to the location where the affected file is stored.
- In the Open dialog box, select the corrupted workbook.
- In the Open dropdown, click on Open and Repair.
- You will see a prompt asking you to repair the file or extract data from it.
- Click on the Repair option to extract the data as much as possible. If Repair button fails, then click Extract button to recover data without formulas and values.
If the “Open and Repair” utility fails to repair the corrupted/damaged macro-enabled Excel file, then try an advanced Excel repair tool, such as Stellar Repair for Excel. It can easily repair severely corrupted Excel workbook and recover all the items, including macros, cell comments, table, charts, etc. with 100% integrity. The tool is compatible with all versions of Microsoft Excel.
Conclusion
You may experience the “Subscript out of range” error while using VBA in Excel. You can follow the workarounds discussed in this blog to fix the error. If the Excel file is corrupt, then you can use Stellar Repair for Excel to repair the file. It’s a powerful software that can help fix all the issues that occur due to corruption in the Excel file. It helps to recover all the data from the corrupt Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm) without changing the original formatting. The tool supports Excel 2021, 2019, 2016, and older versions.
‘Unable to Save Excel Workbook’ Issue [Fix 2024]
Summary: You may unable to save your Excel Workbooks due to several reasons. Many users have reported this issue on the Tech Forums. This blog will discuss a few instances when users cannot save their Excel files. It lists the causes behind the issue and their possible solutions. It also mentions the Stellar Repair for Excel to fix the saving error if it is due to corruption in the Excel file.
It is easy to work with Microsoft Excel but sometimes, the application may create issues thereby hampering the smooth functioning of the workbook. One such issue is “unable to Save Excel Workbook”.
Let’s take a look at the issue of Unable to Save Excel Workbook
Instance 1:
In an organization, users connected to one of the servers (Windows 2008 R2) using Citrix – a Terminal Server configured with Windows 2008 R2 –and accessed their data through a File Server, also configured with Windows 2008R2. Since the connectivity to Shared Drive was established through a Terminal server, any conflict amongst the server configuration may create conflict in shared file.
This issue was discussed at length at one of the Tech Forums , where the users were unable to access their workbooks stored on the shared drive. The File menu did not work. As a result, the users were forced to save the workbook by creating quick access shortcuts or locally on the desktop. In many cases, the saving option was ruled out completely.
Instance 2:
A similar problem was reported, wherein the users received an error when saving an Excel workbook after inserting a chart in an existing workbook (previously saved) or copying values from an existing workbook. A system is configured with Windows 7 and Microsoft Office 10 configuration. The issue arises when the user is unable to save the changes after editing in a saved spreadsheet. The following message displays on the screen:
Figure: Unable to Save Excel WorkBook Issue
Further, if the user clicks ‘Continue’, the following error message is received:
“Excel encountered errors during save. However, Excel was able to minimally save your file to <**filename.xlsx**>”.
Note: This issue impacts build Version 1707 (Build 8326.2086) and later, and also only occurs with files that are stored locally, such as on the desktop. This problem does not occur if you manually enter values or insert a chart in a newly created workbook.
Plausible reasons for the ‘Unable to save Excel workbook’ Issue
- The issue was detected in Microsoft Office Professional Plus 2010 32-bit, Service Pack 14.0.6029.1000.
- Excel version on the user system may or may not match with Excel version on File server.
- The issue of ‘Unable to Save Excel Workbook’ impacts only the Build Version 1707 (Build 8326.2086) and later.
- In case of Issue 2, the problem surfaces when the user adds files, tables or charts in the locally saved excel files, such as on the desktop.
Methods to fix the ‘Unable to Save Excel Workbook’ Issue
There may be an issue with the Build version or the Registry Values settings may not be appropriate, which does not allow the Excel workbooks to save.
But, before starting to resolve the issue, verify the following:
- The location where the file is to be saved may not have enough space to save the Excel file: Check the available space and save again. You may also use the option of ‘Save As’ to save the file at a new location.
- Excel file may be a shared one where edits are not allowed by a specific user: There are restrictions attached to documents and other files shared over the network. Check for these restrictions.
- Antivirus may interrupt in during file saving: Antivirus in the system may not allow saving of the files. Request the system administrator to uninstall the antivirus and reinstall after saving.
- The file is not saved within 218 characters: If the file is not saved due to the naming issue, then check the character length and try again.
- Differences in Windows versions of the local system and those on network drive may cause excel not saved issues. Check that all the systems have the same configuration and are updated to the recently available versions.
- Excel spreadsheet is corrupt: If none of the above factors have not caused hindrance in saving the file, then there may be a probability of corruption in the Excel spreadsheet .
Once verified, look for a healthy and restorable backup. If backup is missing, resolve the issue of “Unable to open Excel File” with manual settings on local system or through a reliable Excel repair software.
Method 1: Modify Registry Entries
If multiple users are unable to access their workbooks stored on the shared drive and facing unable to save Excel file problem (see Instance 1 above), then follow the below steps:
- Go to ‘Registry Entry’. To do this, type ‘regedit’ in the Start Search box, and press ENTER
Figure: Edit Registry
- You are prompted for the administrator password or for a confirmation, type the password, or click Continue
- Locate the following registry subkey, and right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
Figure: CSC Location
- Point the cursor to New, and click Key
Figure: Create new key
- Type ‘File Parameters’ in the available box
Figure: File parameters
- Right-click Parameters, point the cursor to New, and click DWORD (32-bit) Value
Figure: File parameter (DWORD – 32 bit) value
- Type ‘FormatDatabase’, and press ‘ENTER’. Right-click ‘FormatDatabase’, and click ‘Modify’
Figure: Modify format database
- In the Value data box, type ‘1’, and click ‘OK’
Figure: Value data
- Exit ‘Registry Editor’
- Restart the system and verify if the files can be saved now
Method 2: Try Google Uploads
If the user is unable to save the changes after editing in a locally saved spreadsheet (see Instance 2 above), then follow these steps:
- Upload the unsaved Excel file to Google Docs. Ensure that the file gets converted to Google Sheets format.
- Check if all the formulae are active and working.
- Make changes to the Google Sheet and verify that all the changes are working fine.
- Use the Google Sheets export feature to download the file in Excel format.
Method 3: Resolve manually with Open and Repair
If the Excel file is found to have corruption, try out the Excel Open and Repair utility:
- Open a blank Excel File. Go to File and Click Open.
- Go to Computers and click Browse.
- Access the Location and Folder and click the arrow icon beside Open followed by Open and Repair.
Figure: Illustrates Steps to use ‘Open and Repair’ method
The Open and Repair utility is not competitive enough and may not fix corruption in severely corrupted files. Hence, if you are unable to save Excel workbook after applying the manual methods, then you can search for a useful software-based repair utility.
Method 4: Excel File Repair Software
Specifically meant to resolve Excel file corruption. Stellar Repair for Excel helps you to repair every single object including charts, tables, their formatting, shared formulae and rules and more.
- Install and Open the software and select the corrupt Excel File. You can also click the Find option if the file location is not known.
- Click Scan and allow the software to scan and repair the corrupt Excel file.
- Once repaired, the software displays the fixed file components to verify its content.
- Click Save to save the file data in a blank new file as ‘Recovered_abc.xls’, where abc.xls is the name of the original file.
See the working of the software which has been declared as a tool that provides 100% integrity and precision.
The Excel repair software takes care to save the repaired data in a new file to minimize the chances of further corruption.
Conclusion
‘Unable to save Excel file’ is a generic problem that may appear due to various reasons. In this blog post, we presented some of the actual instances reported by users on community forums.
Windows updates, the Build versions, the Service Packs of the local systems and those on the network drive must be either similar or in sync with each other. Any deviation may cause issues in accessing or saving the Microsoft files, as reported in Instance 1 is caused where user is unable to save Microsoft Excel file on the Network Drive. In case, the user is unable to save the file on network drive then the problem lies with the Registry value.
Another case is when the users receive an error while saving an Excel workbook after they insert a chart in an existing workbook or copying values from an existing workbook. This issue is known to affect build Version 1707 (Build 8326.2086) and later, and only occurs with locally stored files.
When a user is unable to save a specific Excel file, then the problem can be resolved using the manual methods or the software based utility. The mode of repair depends upon the level of corruption in Excel file.
Hence, it is suggested to analyze the nature of the problem and decide an appropriate resolution method.
[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 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.
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,
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.
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.
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.
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.
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.
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
- Uncheck all the checkboxes and click OK
- 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
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.
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’
- 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
- 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
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
- 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.
How to fix Microsoft Excel has stopped working error?
Summary: This blog discusses the possible reasons behind ‘Microsoft Excel has stopped working’ error and solutions to resolve the error manually. You can use Stellar Repair for Excel to quickly repair the file and recover all its data in a hassle-free manner.
Has your Microsoft Excel program stopped working or is acting strange? Excel not responding is a common issue you may experience on launching the application or opening a spreadsheet.
Figure 1 – Microsoft Excel Has Stopped Working Error Message
Possible Causes behind ‘Microsoft Excel has Stopped Working’ Error, and Solutions Thereof
Note: Several users have reported about encountering the ‘Excel has stopped working’ issue on Windows 10, 8, and 7 OS after installing an update for Excel (KB3118373). If you too have installed the update, then uninstall it and check if it solves the error. For detailed information, refer to this link .
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.
How Do I Restore Excel File ?
Excel (XLS/XLSX) file corruption is a common issue that may arise due to problems, such as abrupt system shutdown, system crash, malware or virus intrusion, unsupported add-in, etc. However, MS Excel comes with a recovery feature that allows users to recover or restore Excel files lost or corrupted when the MS Excel quits unexpectedly or computer crashes due to hardware or software-related issues.
But sometimes, the restored version of the Excel file may not contain all the data or changes you made recently. In such cases, you are left with the option to repair the damaged or corrupt Excel file with the help of an Excel repair software, such as Stellar Repair for Excel .
Solutions to Restore Excel File
Below we have discussed various solutions to repair, recover, and restore unsaved, lost, corrupt, or inaccessible Excel files with the help of MS Excel options and Excel repair software.
NOTE: Some of these methods work only if you had enabled or configured certain required settings or options before corruption or losing the Excel file.
1. Restore Lost or Unsaved Excel File via ‘Recover Unsaved Workbooks’ Option
The Recover Unsaved Workbooks option allows you to restore the Excel file that you forgot to save before closing MS Excel or it stopped working. The steps are as follows:
- Navigate to ‘_File > Open._’
- Scroll to the bottom and click on ‘Recover Unsaved Workbooks.’ This opens a File Explorer browser window.
- Now look for the Excel file that you lost and then double-click on it to open and restore the Excel file.
- Once the file is open, click on File > Save As and save it to your desired location.
However, this option works only if you had enabled and set up the ‘Save AutoRecover information every X minutes_’ option and enabled the ‘_Keep the last AutoRecovered version if I close without saving’ option.
Also, this may not restore the most recent copy of your Excel file, but it will surely save your time that went into creating and editing the workbook.
2. Repair and Restore Corrupt or Inaccessible Excel File
If the Excel file you are trying to open or access is corrupt, MS Excel will display an error message. When MS Excel detects corruption, it starts ‘File Recovery Mode’ to repair the Excel workbook.
However, if it doesn’t start automatically, you can manually repair minor corruption error and restore the Excel file by following these steps:
- Navigate to File > Open and then navigate to the corrupt or damaged Excel file location.
- Select the file and then click on the arrow beside the ‘Open’ button to choose the ‘Open and Repair…’ option.
- Now click ‘Repair’ if you want to recover maximum data from a corrupt or inaccessible Excel workbook and restore it to a new Excel file.
If the ‘Repair’ option fails, use the Extract Data option that extracts values, data, and formulas from the Excel workbook.
3. Revert Excel File to Last Saved Version
When an Excel file gets corrupt or damaged while working, you may revert the Excel file to the last saved version. This allows you to restore the Excel file version that isn’t corrupt or damaged. The steps are as follows,
- Click File > Open.
- Double-click the name of the workbook that you have opened in Excel.
- Click Yes to reopen the workbook.
The workbook opens without any changes you’ve made that might have caused the workbook to become corrupted.
4. Use Excel Repair Software to Restore Excel File
If the corrupt or damaged Excel file isn’t repaired by using MS Excel options or you lost data after restoring the unsaved version or after reverting to the last version, you can rely on an Excel repair software, such as Stellar Repair for Excel.
The software repairs Excel files with 100% integrity and restores the Excel data, such as table, Pivot tables, charts, etc., while preserving the workbook properties and formatting. The software is safe as it doesn’t alter or make changes to the original Excel file and saves the repaired data to a new Excel workbook at your desired location.
It supports Excel files (XLS and XLSX), created in MS Excel 2019, 2016, or older versions. It resolves Excel corruption errors, such as Unable to open Excel file, in a few clicks.
To repair a corrupt or inaccessible Excel workbook by using Stellar Repair for Excel software, follow these 3 simple steps,
- Select the corrupt or damaged Excel workbook file (XLS/XLSX).
- Repair and then preview the Excel workbook.
- Save the workbook at default or your desired location.
Once saved, you can open and start editing or working on the Excel sheet. Make sure to enable AutoRecovery and AutoSave options to avoid data loss due to corruption.
Conclusion
In this article, we discussed methods and solutions to restore Excel file when it gets damaged or corrupt due to various issues. Although Excel can help you recover or restore Excel file after corruption, it can resolve only minor corruption errors. Thus, it may fail if the Excel file corruption is severe. In such cases, an Excel repair software, such as Stellar Repair for Excel, comes in handy. It resolves Excel corruption, repairs tables, charts, chart sheets, Pivot table, etc., and restores them to a new Excel sheet with 100% consistency.
Also read:
- How to remove Google FRP Lock on Zero 30 5G
- How to Motorola Get Deleted Pictures Back with Ease and Safety?
- How to identify missing drivers with Windows Device Manager in Windows 10 & 7
- How to Retrieve deleted photos on 12
- How to repair corrupted PDF v1.3 file when manual method fails | Stellar
- How to play AVCHD MTS files on Redmi 13C 5G?
- How to Recover Deleted Videos from iPhone 15 Pro Max Without Backup? | Stellar
- How to restore wiped call history on Realme 10T 5G?
- How to restore wiped messages on Lava
- How to restore wiped call history on Motorola G54 5G?
- How to recover lost data from Nokia G42 5G?
- How to recover deleted contacts from 150 (2023).
- 4 Ways to Transfer Music from Motorola Razr 40 to iPhone | Dr.fone
- How to fix error 1015 while restoring iPhone 8 Plus | Stellar
- How to Fix Corrupt video files of Oppo Reno 10 Pro 5G using Video Repair Utility?
- How to remove Google FRP Lock on Meizu 21
- How To Restore Missing Pictures Files from Poco X5 Pro.
- How to recover old messages from your 105 Classic
- How to Rescue Lost Contacts from Infinix Note 30 5G?
- How to Rescue Lost Photos from X100?
- 2 Ways to Transfer Text Messages from Vivo Y200e 5G to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How To Repair System Issues of iPhone 12 Pro? | Dr.fone
- How to retrieve erased videos from Motorola Edge 2023
- 4 Ways to Transfer Music from Itel P55 5G to iPhone | Dr.fone
- How to Rescue Lost Contacts from Vivo Y78t?
- How to recover old call logs from your Nokia G42 5G?
- How to Restore Deleted Infinix Note 30 VIP Racing Edition Contacts An Easy Method Explained.
- How to Electronically Sign a Excel 2016 Using DigiSigner
- How to Repair Broken video files of Tecno Pop 8 on Windows??
- How to restore wiped music on Samsung Galaxy A54 5G
- How to recover deleted contacts from Motorola Razr 40.
- 4 Ways to Transfer Music from Tecno Spark 10 Pro to iPhone | Dr.fone
- How to Fix iPhone 15 Stuck at attempting data recovery Loop | Stellar
- How to retrieve lost files from Google Pixel 8 Pro?
- How to retrieve lost files from Oppo ?
- How to restore wiped call history on Samsung Galaxy M54 5G?
- How To Get Out of Recovery on iPhone XR? | Dr.fone
- How To Exit Recovery Mode on iPhone 11 Pro Max? | Dr.fone
- How to Recover Deleted Data from iPhone SE using Stellar Data Recovery for iPhone? | Stellar
- How to Restore Deleted Infinix Photos An Easy Method Explained.
- How to solve MKV lagging problem in Razr 40 Ultra?
- How To Free Up iPhone 14 Pro Max Space | Dr.fone
- How to restore wiped messages on Xiaomi
- How to recover old music from your Tecno Camon 20 Premier 5G
- How To Recover Lost Data on iPhone 13? | Dr.fone
- How to identify malfunctioning drivers with Windows Device Manager in Windows 10
- Updated Ditch Adobe 10 Free and Open-Source Video Editors for Linux for 2024
- 9 Best Free Android Monitoring Apps to Monitor Phone Remotely For your Honor X7b | Dr.fone
- iSpoofer is not working On Honor Magic 5 Lite? Fixed | Dr.fone
- How to Transfer Text Messages from Vivo S18e to New Phone | Dr.fone
- Full Guide on Mirroring Your Oppo A2 to Your PC/Mac | Dr.fone
- In 2024, Pokemon Go No GPS Signal? Heres Every Possible Solution On Poco C55 | Dr.fone
- In 2024, Does Apple iPhone 6 Plus Have Find My Friends? | Dr.fone
- Top 10 Fingerprint Lock Apps to Lock Your Poco X6 Phone
- In 2024, How to Unlock Xiaomi Redmi Note 12 4G Bootloader Easily
- Looking For A Location Changer On Realme C55? Look No Further | Dr.fone
- Best Video Format Converter for PC and Online for 2024
- In 2024, 4 Things You Must Know About iPhone 14 Activation Lock
- Recover your pictures after X6 Pro has been deleted.
- 4 Ways to Unlock Apple iPhone 13 mini to Use USB Accessories Without Passcode
- 3uTools Virtual Location Not Working On Asus ROG Phone 7 Ultimate? Fix Now | Dr.fone
- Best Video Repair tool to Fix and Repair Corrupted video files of Oppo Reno 11F 5G
- In 2024, 5 Ways to Transfer Music from Tecno Pop 7 Pro to Other Android Devices Easily | Dr.fone
- 4 Ways to Fix Android Blue Screen of Death On Nubia Red Magic 8S Pro+ | Dr.fone
- In 2024, Two Ways to Track My Boyfriends Lava Storm 5G without Him Knowing | Dr.fone
- 3 Ways of How to Get Someones Apple ID Off Apple iPhone 8 Plus without Password
- 4 Methods to Turn off Life 360 On Honor Play 40C without Anyone Knowing | Dr.fone
- Motion Tracking Is the Process of Tracking the Movements of a Project in a Video. This Article Will Show You How to Apply Motion Tracking Effect Into Videos
- In 2024, How to Fix Pokemon Go Route Not Working On Samsung Galaxy S24+? | Dr.fone
- New 2024 Approved Blur Faces, Objects, or Text in Videos for Free A Simple Guide
- Title: How to Fix a Corrupted {{excel-ext}} File? The Everything Guide | 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-a-corrupted-excel-ext-file-the-everything-guide-stellar-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.