I love Microsoft Windows 10 but one thing that was really getting on my nerves was that Excel was taking ages to open and save files. I also noticed that even when trying to add a formula, Excel would ‘freeze’ for awhile and would display the message Not Responding.
What causes the slow performance of Excel?
There seems to be some sort of conflict between Cortana and Excel. I don’t use Cortana as I prefer the various Google tools so the steps as below have no negative outcomes for me. I also seem to be using Google Sheets alot more these days but I still use Excel for large data-sets (e.g. when working with large lists of MailChimp subscriber data).
Although I use Excel 2016, the steps below should work for other versions too.
Instructions to solve Excel being slow in Windows 10
I found the solution on the web however can’t find the link to the fix. Below are the steps that worked for me in speeding up Excel.
- Log in to Windows 10.
- On your keyboard press the Windows key + I (to get to Settings).
- Type Cortana.
- Click Cortana and Search settings.
- Change the Hey Cortana setting to Off.
- Restart your PC.
Excel will now run far more quickly.