This is a very frustrating issue as this leads to XLS/XLSX file corruption and data loss scenarios. It happens due to several different reasons like running an outdated excel program, add-ins incompatibility and much more than we will discuss in detail below. Microsoft Excel is a popular and highly used application and this is the reason it is highly prone to corruption and due to this the corrupted Excel file can’t be opened and in a few cases crashes and show the error message “The file is corrupt and can’t be opened”. Luckily there are ways that worked for numerous excel users to solve the Excel workbook keeps crashing problem. And after doing research on the issue, we find out there are many different reasons that lead to the problem. So, here have a look at the common ones:
Why does My Excel Keeps Crashing?
Incompatibility of Add-Ins – When the add-in in the Excel file gets corrupted or become incompatible it starts causing issues with the Excel document. Removing the problematic add-ins may work for you to solve the problem.Excel is outdated – Windows operating system is regularly updated to become more stable and secure and if your Excel file is missing the important updates, it is more likely to become incompatible with the Windows update version and causes problems like crashing, freezing, excel not responding and much more.Other applications conflicting with Excel – If you recently installed any 3rd party programs then there is a possibility it is interfering and conflicting with the excel file and stopping it from working. Disabling or uninstalling the conflicting programs may solve the problem for you.Any issue with the installation of MS Office – If your Microsoft office is installation file gets corrupted or the update is applied poorly, this corrupted the Excel installation as well and may cause various problems including the one crashing. Reinstalling the MS office updated version properly might work for you.Excel file is partially damaged or corrupt – Sometimes due to unexpected closure of the excel file due to sudden power cut the opened workbook gets partially corrupted and cause a problem like crashing and freezing.Issues created by certain formatting and styles – When the excel workbook contains a number of worksheets using a different, improper combination of formatting this cause issues such as crashing and freezing of excel file. If this case is applicable then removing different formatting and style may work for you.Excel is created via third-party software – There are applications that are utilized for generating the Excel file for fetching data like downloading data from analytics in Excel format. And if it is not created properly via third-party apps. Some of the features won’t work as intended and cause crash, freeze and hang like problems.
As of now, you know the culprits that cause the issue, it’s time to perform the below-mentioned solutions.
Restarting Excel in Safe Mode
In this first solution, it is suggested to run MS Excel using safe mode. Safe mode allows Excel to run with a limited number of functions, bypassing Excel add-ins but excluding COM add-ins. You can try opening excel in safe mode follow the steps mentioned below – There is another alternative method to launch excel in safe mode. Open Run command by pressing Windows +R. Here type “excel/safe” and hit Enter. Check by opening an existing file that this issue has been resolved or not. If not, you should try the next solution.
Remove Problematic Add-Ins in Excel
If the excel is performing absolutely fine in safe mode, then there might be a possibility that defective add-ins are causing excel to crash repeatedly. These installed add-ins might be interfering or conflicting with the MS excel program. So, finding and removing the problematic add-ins may help you to solve the Excel crash issue Follow these steps to remove the faulty add-ins: In this manner, the add-in which is causing all the problems can be detected. Simply remove that particular add-in causing the error. If this solution does not solve the issue, then move to the next possible solution.
Install Latest Updates
If the option of downloading and installing Windows updates hasn’t been set to automatically, then you need to turn that option ON. The Windows update not only gives an upgraded look to the operating system but can also fix applications that are facing issues in the operating system, like MS Office. So upgrading your Windows to the latest update may solve the issue. Apart from updating Windows, it is equally important to manually update MS Office. To do this follow these steps: If the Excel you are using has been downloaded from the Microsoft Store, then you need to open the Store and update the MS Office. This not only fixes Excel crashing issue but is also a handful in solving various errors. After updating MS Office as per the latest update, check whether the issue has been resolved or not. If not, move forward to the next potential solution.
Clear Conditional Formatting Rules
In some cases, only a particular sheet might be causing issues like freezing or crashing. In such scenarios, try clearing the “Conditional Formatting Rules” to solve an issue with that specific sheet. Follow the below steps to clear conditional formatting rules: Now check whether the issue you were facing has been resolved or not.
Eliminate Numerous Cells Formatting & Styles
There are cases when the excel workbook is edited and shared by the different users on different platforms and in this scenario, there is a possibility numerous cells were formatted in a different manner and this can cause issues like freezing and crashing of the Excel sheet. This problem is likely to occur when a single workbook contains multiple worksheets with varied formatting. You should remove the different cell styles and formats, by referring to this link following the guide. After removing all the formatting open Excel to check whether the issue has been resolved or not.
Discard the Microsoft Excel Animation
Adding animation in excel need additional processing resources and power, so here it is suggested to remove animations in the MS Excel workbook. Doing this not only fix the Excel workbook crashing or freezing problem but also optimize the excel performance. In Excel, the animation option is turned on automatically and, in many cases, cause various issues to the users. This generally makes the Excel file slow and, in some case, even crashes and stop responding. So, follow the steps to disable animation in Excel. It is estimated disabling the Excel animations works for you to solve the crash problem in MS Excel, but if in case you still see the problem while opening or saving the file then head to the next potential fix.
Review the Conflicting Processes or Programs
Many processes and programs get automatically started as soon as you boot Windows. So, there are a lot of chances that these processes and programs might create an error in your Excel application. And to solve the problem you need to make selective startup or else you need to clean boot your Windows system. So that the application can run successfully. Below are the few steps that you need to perform, one by one: This solution worked for several MS Excel users but if this won’t solve the problem in your case then head to the next solution.
Repair the MS Office Package
Repairing the MS Office package also worked for several users to solve the crashing problem in MS Excel. And probably it is one of the good solutions to fix the issue. Follow the steps given to do so:
Reinstall Microsoft Office
If running the repair of the Office won’t help you to stop excel from crashing then reinstalling the MS office suite may work for you. There is a possibility that your office installation gets corrupted and therefore showing errors. So, uninstall and reinstall MS office by following the steps given below: Once the uninstallation process is complete restart your PC and then reinstall the Microsoft office on your computer.
Run the Open and Repair Tool
If none of the above-listed solutions works for you to solve the Excel spreadsheet keeps crashing problem, then there is a possibility that your Excel file is undergoing a serious problem and show errors like “The file is corrupt and cannot be opened” and as a result fails to open and stop responding. So here it is suggested to run the Excel inbuilt Open and Repair utility, this solves many Excel problems and helps to recover Excel file after crash. Follow the instructions given to do so: So, this is all about the Excel keeps crashing problem in Windows 10 & 11. It is estimated following the solutions given will help you troubleshoot crashing, freezing and not responding to Excel problems.
Fix: Spotify Keeps Crashing on Windows 10Zoom Keeps Crashing Windows 11? Try These FixesPUBG Keeps Crashing? Here’s how to fixFix: Dragon Age Inquisition Keeps Crashing to Desktop - No Error Message
