To fix the issue try the given solution:
Method 1: Install the latest updates
You might need to automatically download and install recommended updates. Installing any new optional updates can often correct problems by replacing out date files and fixing vulnerabilities. To install the latest office updates click the specific link as per your version you are currently been using.
Install Windows updates in Windows 7
Install Windows updates in Windows Vista
Install Windows updates in Windows XP
If installing the latest Office updates did not resolve your issue.
Method 2: Investigate possible issues with add-ins
Add-ins can also enhance your experience, they can interfere or conflict with excel. Try starting excel without add-ins to observe if the problem goes away. Here’s how:
- Do one of the following:
If you are running Windows XP, click Start, and then click Run.
If you are running Windows Vista or Windows 7, click Start.
- Type Excel /safe, and then click OK.
- If the issue is resolved, on the File menu, click Options, and then click Add-Ins.
- Select COM Add-ins, and then click Go.
- Click to clear all the check boxes (Disable the Add-ins) in the list, and then click OK.
- Restart Excel.
If the issue doesn’t occur, start enabling the add-ons one at a time until the issue gets fixed up. This will allow you to configure which add-ins is actually causing problem. Don’t forget to restart excel each time you enables the add-ins.