Link to home
Get AccessLog in
Avatar of MASWORLD
MASWORLDFlag for France

asked on

Fix corrupted Excel xls or xlsx file after recovery

Hi Expert
i formate my D drive but I have done by mistake
so i recover all data using Power Data Recovery
many file working ok but some Excel file corrupted and unable to open
how can i fix it
Thanks
Avatar of John
John
Flag of Canada image

Can you start Excel in Safe Mode and open from there?  If not, and if no other backup, you will probably need to rebuild the spreadsheet.
Avatar of MouseCaptain
MouseCaptain

First try File | Open ... browse for the file, then click the dropdown triangle on the Open button and choose Open and Repair.  If it prompts, the "Repair" options is better, but if it fails, try again, choosing "Extract".

Then, check the size of the recovered file.  Is it likely all your data is included?  if so, you can try to access the data from the file without opening it by creating an external reference.  In cell A1 of a blank workbook, type a reference to the A1 cell of the corrupted workbook, following this format:

='C:\Folder\Path\[FileName.xlsx]SheeName'!A1

Beyond that, what is the file format?  There may be more options.

-TJ
Avatar of Roy Cox
Sometimes corrupt Excel files will open using one of the Open Office spreadsheet programs
Avatar of MASWORLD

ASKER

@John Hurst thanks
it's same error in save mode
you will probably need to rebuild the spreadsheet
do you mean i need to recreate the file or what
I meant start a new spreadsheet if the file cannot be recovered. This means entering new formulas.
@MouseCaptain thanks
i already trying repair option you mention above but not work
the size of file correct
In cell A1 of a blank workbook, type a reference to the A1 cell of the corrupted workbook, following this format:

='C:\Folder\Path\[FileName.xlsx]SheeName'!A1
not work
@all thanks
this is the file
PRICE-LIST.xls
I downloaded and opened the file. It is a mess and I am fairly sure it was damaged during recovery - put together improperly or has a piece missing. Excel cannot decipher it.
have you ever emailed it to anyone?  That may be your best chance to recover it.
Try to open the file in WordPad.  You may be able to get some text out of it.  Plus there are some free and paid uncorruption utilities available online, if your file is not of a highly sensitive security.
I took a quick look in Word Pad and it is no better that way - no useful information.

@MASWORLD - if you try a paid recovery service, let them know what happened. My concern is that not all the file was recovered.
When an Excel file is corrupted, then you can try several methods to recover it:

1. First of all, you can try to repair the file manually in Excel, as follows:

(1) On the File menu, click Open.
(2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
(3) Click Open and Repair, and then choose which method you want to use to recover your workbook.

You may find more information about this at:

http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx (for Excel 2003)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx?CTT=1 (for Excel 2007)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1 (for Excel 2013)

2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below

http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1#_Toc337637262

3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.

3.2 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.
 
Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.

4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR at http://www.rarlab.com to repair the file, as follows:

4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
4.3 Rename a_fixed.zip back to a_fixed.xlsx
4.4 Using Excel to open a_fixed.xlsx.
 

There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.

5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at

https://www.datanumen.com/excel-repair/

It provides a free demo version so that you can try to see if the data you want can be recovered or not.

Good luck!
@all Thanks
But all methods failed :(
Did you try to recover the data using another recovery app
many file may damage due bad recovery calculation
here is the top ten recovery soft ware
hop this help
what's top ten you mean
i can't see the link
do you suggest any one
ASKER CERTIFIED SOLUTION
Avatar of Temody
Temody
Flag of Egypt image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Yes thanks termody
it's working with many other files which damaged before
unfortunate with that file not work but 50% of the damaged file recovery and work thanks