• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I am unable to open corrupt MS Excel 2010 file?

R

ReynoldStephens

New Member
I cannot open corrupt excel file because of virus attack or malware affection, I have corrupted workbook.

How to get back corrupted MS Excel file.

Any help.
 
Community of
enthusiasts must aid you- http://www.techrepublic.com/forums/questions/how-to-open-xls-file/

How to Recover
Corrupt Excel Files


1.Launch
Microsoft Excel using the Excel executable icon or through the
"Start" bar.

2.Click
"File", "Open" and an Open window will pop up. Highlight
the file that is corrupt by clicking the file just once. Click the arrow to the
right of the "Open" at the bottom of the window. Select the option
"Open and Repair."

3.Select
"Repair" when the window directions prompt you. If Excel is unable to
repair the file it will give you the option to "Extract Data." Pick
this option and save the new file. If changing the name of your file be sure
that all calls to this file get changed also.

4.Try
saving the file in HTML format if Excel stops responding while working in the spreadsheet.
Select "File" then "Save as Web Page." A new Save Window
will pop up.

5.Pick
the option "Entire Workbook" in the new window. Click "Save"
and close the file. Reopen the new HTML file that you just closed, by selecting
"File" and "Open." Wait for the file to completely open and
then do a "Save as Type" and select "Microsoft Excel
Workbook."

6.Rename
the file to a different name so not to overwrite the old one. Some data may be
lost by saving as HTML but at least the entire file will not be lost. This same
procedure can be used to recover files, but instead of saving it as HTML you
save it as XML Spreadsheet format.
Otherwise apply
Excel Repair Toolbox
How it works, see:- https://www.repairtoolbox.com/excelrepair.html
 
Follow the below mentioned steps to fix corrupted Excel files

1. Click File > Open.
2. Click the location and folder that contains the corrupted workbook.
3. In the Open dialog box, select the corrupted workbook.
4. Click the arrow next to the Open button, and then click Open and Repair.
5. To recover as much of the workbook data as possible, pick Repair.

If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.

If above mentioned steps fails then try Excel Repair software - Fix Corrupt Spreadsheet Excel File
 
See if an Excel spreadsheet gets corrupted, it can't be opened. Though, there is a way to open corrupt spreadsheet, but sometimes it may fail. You can try to open the spreadsheet by using Open and Repair technique. It's very simple.
Open MS Excel > click on File tab > Open > select corrupt .xlsx file > click on the arrow beside open button > Open and Repair.


This technique is useful, but not so effective if file is severely corrupted. In such situation you can check some third-party recovery applications…
 
You must log in or register to reply here.
Back
Top