need help to recover corrupt excel file after pc crash

%3CLINGO-SUB%20id%3D%22lingo-sub-2948199%22%20slang%3D%22en-US%22%3Eneed%20help%20to%20recover%20corrupt%20excel%20file%20after%20pc%20crash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2948199%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20computer%20froze%20and%20I%20had%20to%20force%20restart%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20a%20very%20important%20Excel%20file%20with%20data%20that%20is%20not%20available%20anywhere%20else%20open%20when%20this%20happened%2C%20and%20after%20the%20restart%20the%20file%20(saved%20on%20OneDrive)%20could%20not%20be%20opened%3A%20an%20error%20message%20saying%20%22Excel%20cannot%20open%20the%20file%20'Events%20checklist.xlsx'%20because%20the%20file%20format%20or%20file%20extension%20is%20not%20valid.%20Verify%20that%20the%20file%20has%20not%20been%20corrupted%20and%20that%20the%20file%20extension%20matches%20the%20format%20of%20the%20file%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20using%20the%20Excel%20%22open%20and%20repair%22%20option%20(both%20repair%20and%20recover)%2C%20change%20the%20calculation%20to%20manual%20in%20the%20formulas%20option%2C%20add%20an%20%22everyone%22%20user%20with%20full%20access%20in%20the%20file%20security%20properties%2C%20changing%20manually%20the%20extension%20from%20.xlsx%20to%20.xls%20(didn't%20work%20as%20it%20would%20only%20result%20in%20.xlsx.xls)%20but%20nothing%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20please%20assist%3F%20I%20will%20lose%20days%20on%20work%20if%20I%20cannot%20recover%20the%20data%20(calculations%20are%20not%20important)%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaria%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2948199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2961449%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20to%20recover%20corrupt%20excel%20file%20after%20pc%20crash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2961449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1214168%22%20target%3D%22_blank%22%3E%40maria_f_uipi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frepairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ERepairing%20a%20corrupted%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22%22%3EWhen%20you%20open%20a%20workbook%20that%20has%20been%20corrupted%2C%20Excel%20automatically%20starts%20File%20Recovery%20mode%20and%20attempts%20to%20reopen%20and%20simultaneously%20repair%20the%20workbook.%3C%2FP%3E%3CP%3EExcel%20cannot%20always%20start%20File%20Recovery%20mode%20automatically.%20If%20you%20cannot%20open%20a%20workbook%20because%20it%20has%20been%20corrupted%2C%20you%20can%20try%20to%20repair%20the%20workbook%20manually.%3C%2FP%3E%3CP%20class%3D%22%22%3EYou%20can%20also%20try%20other%20methods%20to%20recover%20workbook%20data%20when%20repairing%20a%20workbook%20is%20not%20successful.%20As%20a%20preventive%20measure%2C%20you%20may%20want%20to%20save%20your%20workbook%20often%20and%20create%20a%20backup%20copy%20every%20time%20that%20you%20save%20it.%20Or%20you%20can%20specify%20that%20Excel%20automatically%20creates%20a%20recovery%20file%20at%20specific%20intervals.%20This%20way%2C%20you%20will%20have%20access%20to%20a%20good%20copy%20of%20the%20workbook%2C%20if%20the%20original%20is%20deleted%20accidentally%20or%20if%20it%20becomes%20corrupted.%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EYou%20will%20find%20the%20repair%20steps%20in%20the%20top%20link.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

My computer froze and I had to force restart it.

 

I had a very important Excel file with data that is not available anywhere else open when this happened, and after the restart the file (saved on OneDrive) could not be opened: an error message saying "Excel cannot open the file 'Events checklist.xlsx' because the 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".

 

I have tried using the Excel "open and repair" option (both repair and recover), change the calculation to manual in the formulas option, add an "everyone" user with full access in the file security properties, changing manually the extension from .xlsx to .xls (didn't work as it would only result in .xlsx.xls) but nothing worked.

 

Could someone please assist? I will lose days on work if I cannot recover the data (calculations are not important)

 

Thank you in advance.

 

Kind regards,

 

Maria

2 Replies

@maria_f_uipi 

Repairing a corrupted workbook

When you open a workbook that has been corrupted, Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.

Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually.

You can also try other methods to recover workbook data when repairing a workbook is not successful. As a preventive measure, you may want to save your workbook often and create a backup copy every time that you save it. Or you can specify that Excel automatically creates a recovery file at specific intervals. This way, you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted.

You will find the repair steps in the top link.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

@maria_f_uipi 

There are many ways to repair corrupt Excel file. If open and repair is not working then, you can change the file format. 

You can check this video: https://www.youtube.com/watch?v=eumfyKhzvPc