Excel how do I verify file is not corrupt so I can open my spreadsheets?

I was adding details to spreadsheet when file did not respond, found file hidden but cannot open as I cannot verify the file ok
 

Question Info


Last updated July 17, 2019 Views 6,659 Applies to:
Answer
Answer

A common error message that an Excel user generally encounters when he tries to open a spreadsheet received in an email is:

"Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

However, this error message is not limited to the Excel files that a user gets via emails. Instead, it is often encountered with commonly used files also. You may find that an Excel workbook, on which they were working for a long time, suddenly starts throwing this error message when you try to open it. 

To find out the unique number associated with this error message, press 'CTRL+SHIFT+I' together. After that, you will get number besides the error message: "101590"

Causes: This error message is encountered when:

The file is not compatible with the version of Excel that is used.

The file has got corrupt.

Resolutions: You can try the below mentioned resolutions to rectify this error message and regain access to your Excel sheet.

Change the File Extension of Your Excel Sheet: Sometimes, the problem is seen due to the unsupported file extension of your Excel file. To check the support of xlsx extension, go to 'My Computer'. Browse 'Tools >> Folder Options >> File Types'. Check if 'xlsx' extension is included there or not. If not, then rename this file and change '.xlsx' to '.xls'.

Use 'Open and Repair' Option of MS Excel: For this, open Excel, and then go to 'File >> Open'. Select the file that you want to open, but do not double-click it. Go to the 'Open' drop-down provided in the 'Open' dialog box, and then select 'Open and Repair' option from there. This process repairs the corrupt Excel sheet and opens it normally.

Excel Repair Software: If none of the above mentioned resolutions is able to do any needful to you, then use of Excel repair software is recommended. Stellar Phoenix Excel Repair is one such software. It repairs corrupt excel sheet and restores entire data stored in it without altering its original formatting.

You can try any of the above mentioned resolutions to rectify this error message: however, Excel repair software is best-suited one for the case wherein other two methods fail to do any needful to you, so download the software to start scanning of your excel file.

Abhishek Kumar

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.