Why Does Excel Keep Crashing?
Microsoft Excel may crash due to any one or more reasons that include incompatible Add-ins, conflict with other programs, Outdated MS Excel programs or compatible issues are common. Again problems with MS Office installation and Partially damaged or corrupt Excel file also cause excel keeps crashing or excel file to keep closing automatically on windows 10.
1 Why Does Excel Keep Crashing?2 MS Excel crashed unexpectedly2.1 Launch Excel in Safe Mode2.2 Install Windows Update2.3 Check For Conflicting Programs2.4 Clear Conditional Formatting Rules2.5 Repair Installation of MS office package2.6 Open and Repair the excel sheet2.7 Disable Microsoft Excel Animation
MS Excel crashed unexpectedly
If your excel file keeps closing automatically or not responding, hangs, freezes, or stops working apply the solutions listed below. If you are trying to open an excel sheet from a network stored folder and that crashes frequently, then moving the file locally will help determine whether there is something wrong with the file, or with where the file is saved. Temporarily disable or uninstall third-party antivirus if installed on your computer to check if a Conflict between Antivirus and Excel causing the issue.
Launch Excel in Safe Mode
This is the very first step you need to perform to check if certain add-ins are interfering with your Excel sheet that causes the excel file keeps closing automatically. Start Excel in safe mode If the Excel still keeps on crashing, then move on to the next method. But if you notice the excel sheet work properly in safe mode then there is add-ins that may cause the issue. Remove problematic add-Ins in excel You can find out and remove the problematic add-ins following the steps below. Once done close the excel sheet and open it again normally check if there is no more problem with the excel sheet. In addition check this article from Microsoft support, How to troubleshoot startup problems in Excel.
Install Windows Update
Chances there Excel may crash or not respond on your computer because of bugs. You should try installing the latest updates for it to fix them.
Press Windows key + S, type check for updates and select the first resultthe windows update screen opens, hit the check for updates button to allow download latest windows updates from Microsoft server,Or you need to click on download and install if any optional updates are available.Once done, restart your computer to apply them.
In addition Update, Microsoft Office, Word, Excel, PowerPoint help of the following video.
Check For Conflicting Programs
When windows start, there are many processes that automatically get start executing in the background. And chances any of these programs may be conflicting with excel application that results excel keep crashes or not responding.
Press Windows key + R, type msconfig.msc and click okThis will open the system configuration windowGo to Services tab, checkmark on Hide all Microsoft Services then Select Disable all
Now move to the Startup tab, click open task manager linkAgain on task manager go to the startup tab, and disable all unnecessary programs start at boot,Click apply then ok, when ask for restart your PC and check if this help fix excel crashes problem on windows 10.
Clear Conditional Formatting Rules
If Excel freezes or crashes in Only One Spreadsheet there might be a problem with that particular sheet. In such cases clearing the conditional formatting rules help fix the problem.
Open excel sheet and select the Home tabNow click ‘Conditional Formatting followed by Clear Rules then Clear Rules from Entire SheetIf you have more than one sheets in the Excel workbook, repeat this step for all other sheetsAnd finally, click File Save as and save the Sheet as a new file at a different location
Repair Installation of MS office package
Again repairing the MS Office package also help fix the different issue with applications of MS Office suite, And probably a good solution to fix the excel crashes issue as well.
Press Windows key + R, type appwiz.cpl and click okThis will open the programs and features window, locate Microsoft Office among the list, right-click it and choose Change.A new popup open, here select the radio button repair then click continue to start finding and fixing related issues.It will take some time to complete the diagnosis process, Let the process complete once done restart your PC and open the excel sheet to check its status.
Open and Repair the excel sheet
Still need help, here a tweak help several users to fix the issue. applicable only if a specific excel file keeps closing automatically or not responding.
Press Windows key + S type excel and select Microsoft excel from there,On the File tab then Open, click Browse and locate the excel sheet (which is causing the problem) select itClick the arrow next to the Open button and then click “Open and Repair”.A new popup opens, here click “Repair” if you want to recover as much Excel data as possible,Click “Extract Data” to extract values and formulas from Excel when an attempt to repair the Excel is not successful.
Disable Microsoft Excel Animation
For a few users disabling animations in Excel not only resolve the Excel freeze and crash issue but also improves MS Excel performance as well.
To disable the animations in MS Excel,Open the excel sheet, Go to File then OptionsClick ‘Advanced’ and check ‘Disable hardware graphics acceleration animationClick ‘OK’ to close the window and then restart MS Excel
Did these solutions help fix Microsoft excel keeps crashing or not responding issues in windows 10? Let us know in the comments below. Also read:
Microsoft word documents open very slowly. Here is how to Make Microsoft Office Word/Excel Load FasterWindows 10 Freezes continuously and Auto Restart with BSODSolved: Computer restarts randomly while playing games windows 10Essential Cyber Security Tips Every Small Business Should KnowZoom Camera Not Working on Lenovo laptop? (7 Quick solutions to fix it)
