Uncheck all the options under Protected View and confirm by pressing OK. First (and most-common cause) that I checked, was to make sure that I was flushing the outgoing stream. Once I open the file again it says that the file has been corrupted: Excel found unreadable content in '. This may occur for the following reasons: The document is damaged or incompatible with the current version of Excel. Click on arrow next to the Open button (highlighted in image), and select and on click Open and Repair.
Method #2: Data Extraction By using a macro, you can easily extract data from the corrupt spreadsheet. Click on Repair to fix corrupted XLSX file. In this article, we'll discuss those factors, common errors, and how we can repair a corrupt excel There are several reasons why a excel file may have been damaged. Recover corrupt excel files on Windows in xls, xlsx, xla and other formats on Windows.
In cell A1 of the new workbook, type =File Name!A1, where File Name is the name of the corrupted workbook that you copied in step 3, and then press Enter.