Forum Discussion

Muthu69's avatar
Muthu69
Copper Contributor
Jul 04, 2020

Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid

Hi All,   I have a excel.xlsx file saved in my system which has been corrupted .I atleast need to recover the data stores .It is a file of 124 KB and has around 35 worksheets in the workbook .I hav...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Nov 18, 2020

Muthu69 

With your permission and everyone involved, if I can recommend.

It can help us all if you upload an Excel file, no picture.

You could get a precise solution much faster with a file.

This would also be a blessing for all of us,

as we can understand the problem much better,

a win-win situation for everyone.

 

*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

  • stevejeane's avatar
    stevejeane
    Copper Contributor
    Apr 26, 2022

    Not sure where to start with this problem.

     

    I do not see a way to attach the file:

     

    NikolinoDE 

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Apr 26, 2022

      stevejeane 

      Drag and drop here or browse files to attach
      Maximum size: 71 MB • Maximum attachments allowed: 5
       
      if it doesn't work that way... then as an alternative solution,
      load your file and inform about the password (if you gave the file a password).
  • Jayz0507's avatar
    Jayz0507
    Copper Contributor
    Dec 15, 2021

    NikolinoDE Hi can you help me in my excel file?

  • dhexter29's avatar
    dhexter29
    Copper Contributor
    Mar 22, 2021

    NikolinoDE please help to open my file 

    thank you and God Bless

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Mar 22, 2021

      dhexter29 

      It was probably not saved as an Excel file.

      Before repairing, please change all Excel files to All files (*. *) .
      If this is not the case either, it is very likely that it will no longer be possible to restore the file.

       

       

      Additional Info: 

      Repairing a corrupted workbook

       

      Thank you for your understanding and patience

       

      Nikolino

      I know I don't know anything (Socrates)

      • glaydson's avatar
        glaydson
        Copper Contributor
        Apr 09, 2021

        NikolinoDE 

        In my case, the same problem occured after I moved my One Drive folder to another disk, because the original location had no more space.

        After moving, the files in the new place became outdated, probably because local files were not synchronized with the cloud.

        I deleted the original One Drive folder, and the system asked for a complete deletion, because the folder was too big.

        After knowing that some of my spreadsheets were outdate, I recovered them using third party software, but Excel doesn't open them, the message is the same in this post.

        I've tried all solutions posted here, and also all solutions proposed by Microsoft, but I had no success. It's frustrating because I can see that the size of the recovered file is a little bigger than the outdated file, what is coherent. Also, the same problem occurs with all spreadsheets restored. I still think that this thing is related to One Drive. 

        Finally, I tried to attach one of the files and received the error message: 

        • The attachment's caixa 2021.xlsx content type (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) does not match its file extension and has been removed.

         

Resources