Lately we got here throughout a number of complaints from Microsoft Excel customers who’ve issues with the software program. Apparently, this system is crashing every time they try to open a brand new file, or a minimum of 50 p.c of the time. The query is, then, is it attainable to do away with this challenge? Our reply to that is sure, and that’s what we are going to speak about as we speak.
Excel could maintain freezing or not responding whether it is utilized by another course of. So, when you’ll carry out some actions whereas Excel is in use, then it might not reply or freeze. Some COM add-ins or Excel add-ins also can trigger this drawback. As well as, if an Excel file is generated incorrectly by some third-party device and also you attempt to open that file in Excel, then additionally Excel could turn out to be unresponsive or crash. We’re going to focus on a number of fixes that may doubtless set issues straight earlier than the tip of the article. We propose attempting each choice till one works for you, so let’s get right down to it.
Excel freezing, crashing or not responding
You could possibly see any of the next error messages:
- Excel is not responding.
- Excel has stopped working.
- An issue precipitated this system to cease working accurately.
If Microsoft Excel crashes or freezes when operating a macro, with out saving, when opening file from the community, copy-pasting, deleting rows, then the next solutions could provide help to:
- Begin Excel in Protected Mode
- Disable Add-ins
- Set up newest updates
- Test if the file is being generated by third-party
- Carry out selective startup
1] Begin Excel in Protected Mode
To determine if one thing exterior is inflicting Excel to behave loopy, the most suitable choice is to start out it in Protected Mode. To start out Excel in Protected Mode, press and maintain the Ctrl key and double-click on an Excel file. Do not launch the Ctrl key till you see a affirmation field. In that field, press the Sure button and that may open Excel in Protected Mode. Alternatively, open the Run Command field (Win+R), sort excel.exe /secure in its textual content subject, and hit the Enter key on the keyboard. It will begin the Excel in Protected Mode.
If all points are resolved, then it merely means there’s an opportunity you might have to disable one or extra add-ins if any are activated.
Learn: Excel filter not working correctly
2] Disable Add-ins individually
OK, so ensure you’re nonetheless in earlier than transferring to deactivate add-ins. Sure, this may be completed even for those who’re not in Protected Mode, however seeing as we’re not positive what’s inflicting Excel to shut robotically, it’s finest to take the safer route.
To disable all add-ins, click on on File > Choices > Add-ins. From there, choose COM Add-ins, then click on on the Go button. Now, be sure that to uncheck all containers within the listing of enabled add-ins, then hit OK. Lastly, shut Excel, restart your Windows 10 pc, and also you’re good to go, hopefully.
Associated: Excel is sluggish to reply or stops working
3] Set up the newest updates
Perhaps your Workplace set up has but to accumulate new updates as a consequence of a selected setting in Windows 10. To ensure you will all the time get the most recent updates, click on on the Windows key + I to launch the Settings app.
After doing that, click on on Replace & Safety an scroll to Superior choices. Inside this part, customers ought to see “Give me updates for other Microsoft products when I update Windows.” Ensure it’s flip on, then return one step backward and click on on the “Check for Updates” button.
If updates are certainly out there, set up them, restart the pc and test as soon as extra to see if the crashing challenge has been solved.
Learn: Finest Excel Restore Instruments & Strategies
4] Test if the file is being generated by third-party
There are specific conditions the place a third-party software is producing Excel information. Nonetheless, on this case, the information could also be generated incorrectly, which suggests, sure issues may not work as they need to.
What it is advisable do right here is to disallow the third-party app from working along with your Excel file, then try to open this file in Excel. If it nonetheless doesn’t work, then the problem lies elsewhere.
Learn: Microsoft Excel shows Excessive CPU utilization.
5] Carry out Selective Startup
At this level, now we have to marvel in case your pc has selective startup enabled. Perhaps sure issues are not loading correctly after a reboot, so on this case, we advise enabling Selective Startup if it’s not on already.
Click on the Windows key + R, then sort msconfig, and eventually, hit the Enter key. You need to see the System Configuration window, simply navigate to the Normal tab and select Selective startup. After that, restart your Windows 11/10 pc and test if Excel continues to be appearing up.
Hope this helps!
