Excel is not responding - Microsoft Excel 2010

By -

Recently one of my team members had started getting an error message in Excel 2010. Every time when he tried to open Excel file, MS Excel would crash instantaneously with an error message “Excel is not responding”. He was very frustrated and contact me to resolve the problem. I had recommended him a list of solutions to resolve this particular error message. In this article I will describe all the solutions.



Solution 1: Install the latest updates
It is the simplest method! Try this method first before anything to fix the problem. Installing recommended or optional updates can fix the problem by replacing the old files.

Solution 2: Repair MS Office application
In some cases, it might be possible that one of the important file of MS Office application has been corrupt, damaged or deleted. So it might be very helpful to try an automatic repair option of MS Office. It will fix the entire problem related to the MS Office. To perform this, follow below steps:

  1. First, close all the MS Office programs that are running, for example Excel, Word, PowerPoint etc
  2. Now Open the Control Panel.
  3. Select "Programs and Features".
  4. Look for "Microsoft Office 2010" in the list.
  5. Click on the "Change" button at the top.
  6. Now select “Repair” from the list and click on the Continue button.
  7. You have done.

Solution 3: Uninstall & Reinstall MS Office application
It is very helpful method for severe cases. You can do this manually or with the help of Office uninstaller.

Solution 4: Start in safe mode
If above solutions do not work for you then try this method. It is likely one that will work for you. In some of the cases; crashing or not responding issues happen due to add-ins problems. When you start MS Office programs in safe mode then it does not load any add-ins that is possible cause of crashing.

How to do this: To start excel in safe mode, follow below steps:
  1. Open the Run window manually or press Windows+R key to get the Rum window.
  2. Now type “Excel.exe /safe” in the text box.
  3. Disable the add-ins.
Note: There is a space between the .exe & /

Solution 5: Test the File
If not responding issue is happening with any particular file that was created with the third party software then it might be possible that some of the feature not work properly in the MS Excel. First test the file outside the third party application and make sure third party is aware with this issue.

Solution 6: Change the default printer
When you open any MS office documents like .xls, .xlsx, .doc, .docx or any other the MS Office application communicate with the printer to figure out the margins supported by installed printer. If communication fails due to any reason then application will be crash. To fix the issue you have to change the default printer. Follow below steps to fix the issue:
  1. Open the MS Excel.
  2. Go-to the devices and printers windows.
  3. Now right click on the printer and choose as a default printer.
  4. Now open you file again.
Your Turn:
Have you ever experienced with the discussed error message? How did you fix the problem? Did you find this article useful? Please let me know through comments!

Comments

Post a Comment

Popular posts from this blog

How to solve “This document may be damaged (the file may be truncated or incomplete)” JPEG image error

By -
Image
JPEG image or any file type images are very sophisticated, If one pixel of your image get damaged or corrupt then that portion of image will get change. If header part of your image gets damaged then your image will not open. There are several reasons for corruption of JPEG images like virus attack, improper system shutdown etc. In the case of JPEG file corruption you need to repair it with some good JPEG repair software to access your image properly. These are some error messages which you may get in the case of images corruption. Different image viewer will show different message. In Windows Explorer “No Preview Available”. Windows Picture & Fax Viewer will show “Drawing Failed” message. Adobe Photoshop will show “This document may be damaged (the file may be truncated or incomplete)” message. In IrfanView “Can't read file header! Unknown file format or file not found!”. Adobe Photoshop “Could not complete your request because an unkno...
Read more

How to fix JPEG File Error: 'Windows Photo Viewer can't open this picture'

By -
Have you ever suffer with this error message when you are trying to view your pictures in Windows Photo Viewer/Gallery:  “Windows Photo Viewer can't open this picture because the file appears to be damaged, corrupted, or is too large.” My picture file extension was. Jpg. I found some solutions of the error. Here are all:  Solution:  1. Try to open them in another program and resave them. You can do it by changing the default program which Windows uses as default. Open Default Programs by clicking the Start button, and then clicking Default Programs.  In Default Programs, you can set default programs accordingly to your choice. Try these steps to do this task:  a. Right click of the images, open properties, click Change. b. In ‘Open with’ window, open Other Programs and select Windows Photo Viewer as default program or other program which you want to open with. c. Click Ok, all your images will open in Windows default photo viewer. 2. Downl...
Read more

How to fix BEX error in Word, Excel and PowerPoint

By -
Image
BEX error is a very common, which occurs due to buffer overflow problem. This error comes with many parameters and user gets an error message on the screen “ Application_Name has stopped working ”. In this blog, I will give you the solution of this problem for MS Word,Excel and PowerPoint. Take a look on the error message: Above image shows the BEX error for MS Word. When a user will click on the “ View problem details ” option then, a detailed error message will be appear on the screen. In the above image, Problem Event Name is BEX and second parameter is Application Name and so on. You can read more about these parameters from this article https://technet.microsoft.com/en-us/library/cc738483(WS.10).aspx General solution of the problem Here I am giving the solution for MS Word but, it is same for Excel and PowerPoint as well. Open MS Word in the safe mode and click on the File option. At the bottom end, user can see the Options as shown in the image below: ...
Read more