Excel cannot open file due to invalid file format or extention. File name has been changed to .~lock

%3CLINGO-SUB%20id%3D%22lingo-sub-2664838%22%20slang%3D%22en-US%22%3EExcel%20cannot%20open%20file%20due%20to%20invalid%20file%20format%20or%20extention.%20File%20name%20has%20been%20changed%20to%20.~lock%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2664838%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%20Would%20love%20some%20help%20with%20this%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20working%20on%20this%20worksheet%20when%20my%20pc%20crashed%20and%20has%20to%20restart.%20I%20click%20the%20file%20again%20and%20excel%20crashed.%3C%2FP%3E%3CP%3EThen%2C%20then%20I%20restarted%2C%20file%20name%20was%20changed%20to%20.%3CSTRONG%3E~lock.%3C%2FSTRONG%3ETomt%20testskjema%20ny.xlsx%3CSTRONG%3E%23%26nbsp%3B%3C%2FSTRONG%3E(new%20additions%20to%20the%20file%20name%20in%20bold).%3C%2FP%3E%3CP%3EI%20changed%20the%20file%20name%20to%20its%20original%20name%3B%20'Tomt%20testskjema%20ny.xlsx'.%20I%20then%20get%20the%20'Excel%20cannot%20open%20the%20file%20%3CFILENAME%3E%20because%20the%20file%20format%20or%20file%20extension%20is%20not%20valid.%20Verify%20that%20the%20file%20has%20not%20been%20corrupted%20and%20that%20the%20file%20extention%20matches%20the%20format%20of%20the%20file.%3C%2FFILENAME%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20change%20file%20extension%20and%20'open%20and%20repair'%20feature%2C%20with%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20tips%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20not%20attach%20the%20file%2C%20due%20to%20the%20below%20error%3A%3C%2FP%3E%3CUL%20class%3D%22lia-list-standard%22%3E%3CLI%3EThe%20attachment's%20tomt%20testskjema%20ny.xls.xlsx%20content%20type%20(application%2Fvnd.openxmlformats-officedocument.spreadsheetml.sheet)%20does%20not%20match%20its%20file%20extension%20and%20has%20been%20removed.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2664838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi there! Would love some help with this one.

 

I was working on this worksheet when my pc crashed and has to restart. I click the file again and excel crashed.

Then, then I restarted, file name was changed to .~lock.Tomt testskjema ny.xlsx(new additions to the file name in bold).

I changed the file name to its original name; 'Tomt testskjema ny.xlsx'. I then get the 'Excel cannot open the file <filename> because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extention matches the format of the file.

 

I have tried change file extension and 'open and repair' feature, with no luck.

 

Any tips would be greatly appreciated.

 

Could not attach the file, due to the below error:

  • The attachment's tomt testskjema ny.xls.xlsx content type (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) does not match its file extension and has been removed.
1 Reply