PaavoNurminen

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. 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 to repair the file, as follows: 3.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip 3.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip. 3.3 Rename a_fixed.zip back to a_fixed.xlsx 3.4 Using Excel to open a_fixed.xlsx. There may still be some warnings when opening the fixed file in Excel, just ignore them 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. Good luck!