Open Corrupt Excel Workbook

Posted by: jackadision on 21 April 2019, 5:15 pm EST

  • Posted 21 April 2019, 5:15 pm EST

    I was working on an Excel for last 10 days, making annual report but today when I tried to open the Excel workbook, it doesn’t open and given me an error message – The Excel file is corrupt and cannot be opened.

    I don’t know what to do, I don’t have any backup and lost files are really very important. I invested so much time, can anyone help me to recover the corrupt Excel file.

    Pls help me...!!
  • Replied 22 April 2019, 5:45 pm EST

    Hello,

    Please inform about the control you use.
    This will help me assist you in the right manner.

    Best Regards,
    Esha
  • Replied 13 May 2019, 7:40 pm EST

    To repair corrupt Excel file make use of the Open and Repair tool, and check if this works for you. Or else sometimes due to system issues your Excel file start performing weird the corrupted Excel file that is showing corrupt becomes inaccessible and as a result, the networks, servers mark the Excel file as corrupted.

    So if your Excel file gets corrupted and you are unable to repair it, then move the file to another folder, drive or server and check if the issue is resolved.

    Despite this, you can also try to recover corrupt workbook data from the temp files.

    • First, open the temp folder location > locate the Excel temp files with TMP extension.

    For Windows 8/10 users:
    Go to – C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles

    For Windows 7 users:
    Go to – C:\Users\name\AppData\Roaming\Microsoft\Excel\

    • Locate temporary Excel files begin with “$” or “~” > end with “.TMP”.
    • Then copy the files > save to another Safe location > and change the extension from.TMP to .XLS/.XLSX.

    Hope this works to recover unsaved Excel file

    Source: https://support.office.com/en-us/article/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53

    http://www.repairmsexcel.com/blog/open-corrupted-excel-file-without-backup


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels