How to fix “The file is corrupt and cannot be opened” excel error
by Frances Reid Repair MS ExcelThere are many users who come
across error while using excels files. The error is common and due to this,
excel file becomes corrupt. While using excel files, users come across an error
messages “The file is corrupt and cannot
be opened”. The question is obvious to ask, is there any way to fix the
excel error? Well the solution is in this blog.
Microsoft Excel is one of the important parts of business which is used in almost all types of business whether it is large, small or medium scale. All the data are stored in single place and when you are unable to open the file then the problem occurs as it can affect the entire business. At that time, some manual methods are to be done to fix the error.
Mentioned below are some of the manual methods which can help you to fix the corrupt files:
Method 1:
1. Open excel 2010
2. After that select files and hit ion options
3. Select trust center and after that select settings
4. Select protected view and in that uncheck all options and again select OK
5. At last restart Excel and open any excel file
By doing this, excel file will open and after that you have to follow the below mentioned steps:
· After opening the excel document, save it in office new format, .xlsx format
· Select file and then options, select Trust Center, click on settings and select protected view
· Under protected view, check the options and select OK
· At last, restart excel 2010
By performing the above steps, the security options of excel files are activated and it will open the files with security.
Method 2:
1. First open excel 2010
2. Open the file and select options
3. Hit on trust center and choose trust center settings
4. Choose trusted location and after that add new location on drive as per choice
By doing so you will see that corrupt excel file will open easily.
Method 3:
· Copy the file name .xlsx in C drive so that you can get the file easily
· Run the command prompt
· Then using renames command, ‘rename filename.xlsx filename.xls, change file extension name to xls
· Open the file in excel
By following the above method, you can fix the issue and can recover complete data in Excel 2010
Method 4:
1. Even using the below mentioned methods, you can repair your Office program:
2. Hit on start option and select control panel, select programs and features
3. Now hit on office program which you want to repair and select on change
4. Then click on repair and continue
5. At last, restart your system after repairing process is complete.
By following the above mentioned ways, you can solve the error of excel file but if still you are unable to solve the situation then you must use MS Excel repair tool. It can easily fix the corrupt excel files and it can be used to recover everything like charts, worksheet properties, cell comments etc. This is one of the best repair tools to use.
Sponsor Ads
Created on Dec 31st 1969 18:00. Viewed 0 times.