Microsoft Excel is the highly popular application of Microsoft Office suite.
This is used by many people for carrying various calculations and performing various tasks.
It is undoubtedly very useful application, but since there are many cases when the Excel starts crashing, freezes and even locks up.
Well, this is a very frustrating issue as the user was unable to do anything in the Excel file.
In many of our earlier blogs, I have described many MS Excel nightmares and their fixes.
And today in this article I am going to describe one of the common issues that many Excel users had faced in their life once – Excel keeps crashing, or Excel freezes.
Some of the common errors received by the users when Excel crashes are
- Excel is not responding.
- Excel has stopped working.
- A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.
These are the common errors that are faced by the users while working on the Excel file time to time.
The errors are often faced by the user when the Excel crashes, freezes or even locks-up.
This interrupts the entire works, as Excel stopped responding, and as a result, users were unable to do anything on the Excel file or access the entire information stored in the workbook.
So, to fix the issue and stop Excel from crashing you need to carry out certain fixes.
How to Fix Excel Keep Crashing Issue:
Step 1: Remove COM add-ins
The COM add-ins are very bad and this causes several issues in the Excel file, so the best is to disable it.
The COM add-ins fight over the memory and cause the Excel to freeze and crashing issue.
So, the best is to disable the COM add-ins, follow the steps to do so:
- Choose File then go to Options and Add-ins.
- Then at the bottom of dialog box > modify the Manage drop-down to COM add-ins > choose Go.
- After that clear checkbox for the enabled COM add-ins > click OK.
Hope disabling the COM add-ins fixes Excel crashing issues. But if not then follow the second solution:
You May Also Read:
- FIX: Crashing, Freezing, Not Responding or Stop Working Issues in MS Excel 2013 and 2016
- Fix Corrupt Spreadsheet Excel File on Windows/Mac
- Ways to Fix “Excel 2013 has stopped working” Error Message
Step 2: Remove Microsoft Excel Animation
This is also found causing Excel crashing, freezing issue.
The Excel animation is automatically turned ON and found causing several issues, this commonly makes the Excel perform slow and even crashes.
So the best is to turn OFF the animation.
Follow the steps to turn off animation in Excel:
- Select File > Options > then under General Section > uncheck animation
This helped some users to fix the issue.
Step 3: Explore Excel File Details and Contents
The Excel files exist for the long time period in the computer and they are upgraded from version to version.
This often travels between the users, and the users take over the Excel file but don’t know what is included in it.
Below given are the areas that cause crashing and slow responding issues in Excel file:
- The formulas that reference entire columns.
- More than thousands of hidden or 0 height and width objects
- The array formulas that reference an uneven number of elements in the arguments.
- Unnecessary styles caused due to regular copy paste between the workbooks.
- Invalid and unnecessary defined names
Check the areas to know what is causing Excel crashing issue.
Step 4: Run Excel in Safe Mode
Safe mode enables the users to safely utilize Excel without any issues commonly the startup programs.
So, the best is to try once to start Excel in Safe Mode.
Press and hold CTRL when you start the program or else by using the “/safe” (excel.exe /safe) option while starting the program from command line.
Now while running Excel in safe mode, this avoid functionality and settings like the alternative startup location, toolbars changes, the xlstart folder and even the Excel add-ins.
Hope by starting Excel; in safe mode Excel crashing issue is fixed but if not then it is recommended make use of the automatic MS Excel Repair utility, to fix Excel issues, errors, corruption and others.
Automatic Solution: MS Excel Repair Tool
Make use of the professional recommended MS Excel Repair Tool to repair corrupt, damaged as well as errors in Excel file. This tool allows to easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data. With the help of this, you can fix all sort of issues, corruption, errors in Excel workbooks. This is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating system. This supports the entire Excel versions and the demo version is free.
Steps to Utilize MS Excel Repair Tool:
So, this is all about Excel crashing issue.
I tried my best to share with you some of the possible working solutions to stop Excel from crashing and start using it without any hassle.
Make use of the given solutions and check which one works for you to fix the issue
Apart from that, it is also found that in many cases the antivirus conflicts with the Excel file and this causes Excel file to crash, freeze or not respond. So the best is try to update your antivirus software or you can also temporary disable it to check whether this solves the issue.
Also, keep your Windows operating system updated with the latest updates to keep it perform better.
If, in case you have any additional questions concerning the ones presented, do tell us in the comments section below or you can also visit our Repair MS Excel Ask Question