Forum Discussion
Adi_Star
Mar 08, 2022Copper Contributor
In Excel: "The file format and Extension don’t match”.
This error is coming repeatedly even, I am clicking on Yes, and the file is corrupted. How do I repair my file? Is there any solution to recover my file?
Un4tune8
Aug 09, 2022Copper Contributor
Adi_Star I'm actually having this error now that I have upgraded to the latest version of Office 2013. I have actually figured out that if I shorten the filename by 4 characters the error goes away. The strange thing is the path and file name are less than 100 characters so it can't be path limit. Office version 15.5459.1000 does not give the error and Office version 15.0.5475.1001 does give the error. If I move the file back one folder in the path it will open without the error but the path and filename are only about 85 characters total. Strange!
MikeRabe
Aug 10, 2022Copper Contributor
This is caused by KB5002242, and happens when opening Excel files saved on a shared drive (or other UNC path), where the total length of the path and file name exceed about 90 characters. The normal maximum length is 218 characters. Uninstalling KB5002242 is a temporary fix for getting rid of the error message.
- Un4tune8Aug 10, 2022Copper ContributorThank you for the information. I hope they just fix it in the next office update since that is what appears to have actually broke it in the first place.