Forum Discussion

debrasheila's avatar
debrasheila
Copper Contributor
Jul 17, 2022

Unable to open Excel file

Re: File "Books ti read.xlsx" (sic) Error message: File format or file extension is not valid.  Verify that the file has not been corrupted and that the file extension matches the format of the file...
excel
office 365
suyashthomson's avatar
suyashthomson
Copper Contributor
Jul 21, 2022

 

Sometimes users are troubled with different types of runtime errors by which they are unable to access their Excel files. One of the Excel errors is “File Error: Data May Have Been Lost”. 

In order to repair the damaged excel file you have to perform the following steps:

 

  1. Open the excel file.

  2. Now select the corrupted workbook that you want to open.

  3. Then click on Open and Repair by clicking the arrow next to the Open button.

  4. Now perform any one of the following:

  • Click on Repair in order to recover the data from excel.
  • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

https://support.microsoft.com/en-us/office/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab 

 

I hope this method could help to recover the damaged excel file.

 

Best Regards,

Adi

 

Resources