If you encounter a crashing problem on a particular sheet, you will need to clear the “Conditional Formatting Rules” to resolve the issue. This trick has helped many users, and you can try it in your case too. For doing so, follow these steps,
- Firstly open the problematic Excel sheet and select Home, and search Conditional Formatting in the excel sheet.
- From the drop-down list, select the Clear Rules option to proceed with clear rules from the whole excel sheet.
- Then go to the File and click on the option Save and you can save the excel sheet in a new folder as new.
- Check if the issue of resolved or still there.
Note: Repeat the same above steps on all sheets where you encounter a similar issue.
Sometimes when editing an Excel workbook and sharing it across different platforms, many cells may be formatted differently, which can cause problems such as freezing and crashing the Excel sheet.
A similar problem can occur when a workbook contains multiple worksheets with different formatting. All you have to do here is remove the different cell styles and formats; after removing all the formatting, open the Excel on your system and check for improvement.
FIX 6: Eliminate the Microsoft Excel Animation
As per some suffered users, discarding the animations in the MS Excel workbook helped them to get rid of the crashing issue. Adding animations in Excel needs excess power and processing resources. So, you need to discard the animation feature in Excel and check for improvement. For doing so,
- Firstly, launch the Excel Sheet, select File, and click on Options.
- Inside the Excel Options window, select Advanced from the left pane menu and tick the option beside Disable hardware graphics acceleration animation under the Display section.
- Once done, click on OK and restart the system and check the said issue is resolved or not.
FIX 7: Check Conflicting Processes/Programs
Many programs and services start automatically when you boot Windows, and sometimes these processes cause an error in your Excel application. In this case, you need to perform the selected startup or clean boot your system to resolve the issue; then, only the application will run successfully. For doing so, follow these steps,
- Firstly, type System Configuration in the search box and open the relevant search result.
- Inside the System Configuration window, tick before the option Hide all Microsoft services and click on Disable all option.
- Then click on Apply and OK button.
- Now move to the Startup tab and select Open Task Manager link.
- In the Task Manager window, select the Startup tab, and from the list of services, select the item you need to disable.
- Right-click on it and select Disable option from the drop-down menu.
- Then exit from the Task Manager, go to the System Configuration window and click on the OK button.
- Once done, restart the system and check whether the said issue is resolved or not.
FIX 8: Repair MS Office Package
Sometimes repairing the MS Office package might help you to resolve the MS Excel crashing and freezing issue. For doing so,
- Firstly, press Windows + R simultaneously to open the Run dialog box, type appwiz.cpl, and click on OK.
- Inside the Programs and Features window, scroll down and right-click over Microsoft Office and click on Change.
- Inside the newly opened dialog box click on Quick repair.
- And click on the Repair button from the bottom of the dialog box.
- Once done, restart the system and check whether the said issue is resolved or not.
FIX 9: Reinstall Microsoft Office
If none of the above fixes helped you, then you need to uninstall and reinstall the MS Office, which might help you to resolve the crashing issue in MS Excel. For doing so, follow these steps,
- Firstly, close all the Microsoft applications on your system.
- Then type control in the search box and open Control Panel from the search result.
- Now select the Programs and Features option and click on Uninstall a program.
- From the list of applications, select Microsoft Office and click on Uninstall.
- If a prompt appears on the screen, click on Yes to continue the uninstallation process.
- Once you have uninstalled the MS Office, reinstall it from a reliable source.
These are the top fixes for the MS Excel Keeps Crashing on Windows 10/11. We do understand this issue is very frustrating and can impact your work performance over the Excel sheet. And we are sure that any of the above solutions will definitely help you to solve the same problem.
In addition to the above fixes, you can utilize Excel inbuilt Open and Repair utility to resolve the crashing issue in your Excel. If you have any queries or feedback, write down a comment in the below comment box.
