Cause # 5: Problematic Add-Ins
Quite common, when you install new add-ins to Excel, they might cause your spreadsheet program to behave weirdly 😵 Sometimes, a recently installed software might also cause this.
To check if it is an add-in that’s keeping you from typing in Excel, launch a new Excel in safe mode. Here’s how you can do this:
- Close the current Excel book.
- Hit the Window Key + R to launch the Run box as follows.
- Against the box Open, type ‘Excel/safe’.
- That’s it – Click Okay.
A new Excel window will be launched under safe mode. Try typing to see if you’re able to type in now.
Until now, we are only troubleshooting to see if add-ins are the actual problem.
If you’re able to type in Excel safe mode, this means the add-ins caused the problem and vice versa. Once you know those were the add-ins, the next step is to identify which add-ins exactly 🎯
- Open Excel.
- Go to the File tab > Options > Add-ins.
- At the bottom, against the box Manage, choose COM Add-ins.
- Press Go.
You’d see a list of all the installed add-ins now.
- Check the box for anyone add-in and uncheck all the rest.
- Press Okay.
- Restart Excel.
This time Excel will only run the selected add-in 🚴♂️
Try typing in now – if you can type in easily, then this was not the problematic add-in.
Enable another add-in and disable all the others, and again perform steps 4 – 6. Continue doing this until you’ve found the add-in that causes typing problems in Excel.
Once found, disable it, and you’re good to go 💪