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:ģ.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zipģ.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.ģ.3 Rename a_fixed.zip back to a_fixed.xlsx For xlsx files, they are actually a group of files compressed in Zip file format. ![]() 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ģ. You may find more information about this at: ![]() ![]() (3) Click Open and Repair, and then choose which method you want to use to recover your workbook. (2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button. First of all, you can try to repair the file manually in Excel, as follows: ![]() When an Excel file is corrupted, then you can try several methods to recover it:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |