How to fix MS excel 2010 error “The file is corrupt cannot be opened”

By -
-->
After installing updated version of Microsoft office 2010, it may possible that documents created in lower version of MS office will not open. These errors are quite often with MS excel 2010. when you tried to open excel (.xls) file with MS excel 2010 which are created in MS excel 2007 or 2003, a error message “The file is corrupt cannot be opened” will pop up and you will not able to access your excel spreadsheet. In the above case their are two possibilities 1) Excel file actually get corrupt or 2) It is Microsoft office 2010 error. If excel files actually get corrupt then you need a excel repair software to fix it. For second reason Microsoft provide solution.

If you excel file opens perfectly in MS excel 2007 or 2003 but could open in MS office 2010 then you can fix it with below written methods.

Method 1: In this method you need to change and repair MS office 2010.

  1. Click Start, click Control Panel, click Programs, and then click Uninstall a program under Programs and Features.
  2. Select Microsoft Office.
  3. Click Change, and then wait while the change and repair is carried out.
  4. Exit after the process is completed.
  5. Double-click the Excel file that you want to open or open the file through an HTML link as you could by using previous versions of the program.



Method 2: In this method you need to change some file block setting which are responsible to open any files.
  1. Open MS Excel and click on File.
  2. In File menu click on Options.

  3. Then click on Trust Center --> Trust Center Settings.

  4. Then go to File Block Settings and uncheck Excel 97-2003 and Excel 2007.

One of these methods will most probably fix above written error message. If above methods didn't solve your problem then you need to contact MS office 2010 support team or you can try Excel recovery software to fix your problem.

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