Learn the steps to troubleshoot the most common issues that can cause Excel to start. Techniques demonstrated will include: starting Excel in Save mode and removing add-ins.
- [Instructor] Let's spend some time on Excel and explore some of the common troubleshooting techniques that you can use if you're experiencing Excel startup issues. The basic troubleshooting steps include, first, and as always, ensuring that Office and Windows are up to date and determining if there's a conflict with another program or process. I tend to find a common culprit here is your antivirus software. You may want to start exploring if your antivirus program and Excel are having an issue. And finally, if Excel stops responding, there could be issues with the file itself including hidden objects in the file, excessive styles, invalid names, or incorrect formulas and arrays.
And we'll be covering troubleshooting techniques to address these specific issues in more detail in an upcoming lesson. Now, let's pop over to our demo and explore some of the other common troubleshooting techniques that you can use for Excel. First, let's start by running Excel in safe mode. And to do so, from your desktop click your Windows key and start typing "run". And please note that your screen may look a little different than mine depending on the operating system that you're using. Go ahead and click on Run. And now in the Open dialogue box you'll enter in excel dot exe space slash safe.
Don't forget the space. And then go ahead and click OK. If you're prompted to accept the license agreement, go ahead and click Accept. And you'll know you're running in safe mode because up at the top it'll say Excel Safe Mode. From here we can remove our add-ins. Some add-ins may be causing the problem. And to remove our add-ins click on File, Options, Add-ins. And then down at the bottom where it says Manage, click on COM and Go. And here you can start removing your Add-ins.
I'm going to leave the Microsoft ones, but I will remove the Inquire. To do so I'm going to go ahead and select it and click Remove. After removing the Add-in, restart Excel in normal mode and if the issue is no longer present, you can start adding the add-ins again until you determine which add-in is causing the issue. For our demonstration today I'm just going to go ahead and close this. And finally, if the issue persists, you can repair Excel. To do so, close Excel and then open the Control Panel.
I'm going to do so by clicking on the Windows key. And I happen to have Control Panel pinned to my Start screen. Yours may be in a different location. And then click in Programs, Programs and Features, and locate the Office program. Your naming convention may be a little different than what you see here depending on the Microsoft Office version that you're using and which school it came from. Your Office 365 may look a little different than if you have a retail version. You can go ahead and right-click on the Office Suite and then click Change.
I know it is counterintuitive but Change will actually launch Repair. First thing you'll want to do is run through a quick repair. And this will fix most of your issues right off the top. If that doesn't work, then move to the Online Repair. It will take a little bit longer. And those are your basic troubleshooting techniques to handle Excel if it has issues starting up. For additional tips, tricks, and troubleshooting techniques, see the Excel help center.
- Troubleshooting printing and startup issues
- Recovering lost and damaged files
- Fixing compatibility issues
- Troubleshooting Skype audio and video issues
- Accessing SharePoint sites
- Syncing files
- Connecting to email