How to Solve Error “The file is corrupt and cannot be opened” in Excel 2010

-

One of the MS Excel user got below error message, when he tried to open an .xls file in MS Excel 2010.

“The file is corrupt and cannot be opened”

Here's the complete scenario:
  • User was using MS Office 2007 on his PC for data maintenance & document writing.
  • He had recently upgraded his MS office program from 2007 to 2010.
  • He had got a spreadsheet (spreadsheet.xls) from his friend.
  • When he tried to open the file; got above error message.
  • When he tried to open the file on another computer with MS office 2007; file was opening successfully.
  • File was not corrupted.


Why got Error Message?
Above error message occurred due to protected view setting.

How to Resolve?
User had performed below steps to troubleshoot the above error message and problem was solved.
  1. Open the MS Excel 2010.
  2. Click on the File button & go to the Options tab.
  3. Now select the Trust Center and click on the trust center settings.
  4. Now select Protect view.
  5. Unmark all the options under protected view.
  6. Now click on the OK button.
  7. Close the MS Excel 2010.
  8. Again Start the MS Excel 2010.
  9. Now try to open your .xls file.
  10. Now save your file as .xlsx file format.
  11. Again perform the Step 2, 3 & 4.
  12. Mark all the options under protected view & click on the OK button.
  13. Restart the MS Excel 2010.
Note: Steps 11 & 12 will set the security options normal again. If you don't perform these steps then you will be open the files without security.

Comments

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob...
Read more

Ways to prevent corruption in FileMaker database

-
Image
Corruption in any type of database is impossible to avoid completely, even most secure and safest relational database like FileMaker Pro also got corrupt sometime. However you can still avoid corruption in FileMaker Pro to a certain limit, if you take necessary precautions. So let's first understand why FileMaker Pro got corrupt at first place. Reasons of corruption in FileMaker Pro: Since FileMaker is disk based application, so it just transfer the data as needed in main memory instead of loading the entire database. When it transfer data from main memory to hard disk and you unexpectedly quit the application then it is most likely that your FileMaker database becomes corrupt.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more