In this video, you learn some tricks to solve excel not responding issues.
Step 1
Go to the File -- Option
Click on the Advanced tab -- Display
Check the box that says "Disable Hardware Graphics acceleration"
Step 2
General section: Disable Dynamic Data Exchange(DDE)
Step 3
Click on the Protected View -- Trust Center Settings
Go to the Protected View "Uncheck all the options".
Got to "File Block Settings" Under the Trust Centre Settings Uncheck all the options
Step 4
Open Control Panel-- Programs and Features
Microsoft Office: Click the Repair option
After the Repair is Done "Restart Computer"