Forum Discussion

KPD22's avatar
KPD22
Copper Contributor
Feb 14, 2022

Excel cant open file because the file extension is invalid

My PC crashed and auto rebooted while i jut saved my file in microsoft one drive and i cant seem to reopen it again. I guess the data must be corrupted. How can i recover it?

12 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor

    KPD22 

     

    You wrote: 

    My PC crashed and auto rebooted while i jut saved my file in microsoft one drive and i cant seem to reopen it again.

     

    Hard to diagnose without a bit more data (and even with more data, the cause may be elusive). But let me ask a few diagnostic questions:

    1. Has this happened before?
    2. Have you done a cold re-boot (not just the auto-reboot you mention)?
    3. Can you open other Excel files currently? (i.e., is it just this one file?)
    4. What (generally) is different or distinctive about this file compared with others that you typically work with? (size, nature of data, presence of absence of VBA, macros, etc.)
    5. What about other MS Office applications and files? Are they all working normally, files can be saved, re-opened.
    6. How about non-Office files.
    7. What edition of Excel are you using?
    8. What PC and windows OS?

    To your subsequent question about posting files, it can be difficult at times. If it becomes necessary, you would be able to grant access to folks to your file on OneDrive (if you use it) or DropBox, or other such file sharing systems. But let's start with answers to those questions. (And if there's other information you can provide, please do)

    • KPD22's avatar
      KPD22
      Copper Contributor
      1. Never happened before
      2. Yes, i did
      3. Yes, the other files can be opened normally
      4. No difference from the other files in the same folder. It only uses simple formulas.
      5. Yes, everything else is working normally
      6. It's just this one file that is not opening
      7. Excel 365
      8. HP Pavilion & Windows 11
      • mathetes's avatar
        mathetes
        Gold Contributor

        In the header to this all, you do mention the words "because the file extension is invalid"

         

        I should have asked, (or you could have provided as well) --

        1. what is that invalid file extension? Is Excel giving that as a reason for not opening?
        2. Could you make a copy of the file and then change the extension to a valid extension (.xlsx)
        3. and see if that opens
  • KPD22's avatar
    KPD22
    Copper Contributor
    Is there no way for me to upload the excel file here?

Resources