Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

How to recover a corrupted excel file ?

Latest post Tue, Apr 14 2015 3:11 AM by DonaldWater. 2 replies.
  • Sat, Apr 11 2015 10:54 AM

    • fowlerfowl
    • Not Ranked
    • Joined on Sat, Apr 11 2015
    • Posts 1
    • Points 37

    How to recover a corrupted excel file ?

    HI

    We have a file server with windows 2003 sharing some folders, since the last lost of energy the server restarted but we have noticed that some excel files are now corrupted, we got the following message:

    "Excel cannot open the file myfile.xls because the file format or file extension is not valid"

    We have tried to open and repair the file, but always appears an empty file.

    Also, We tried "Excel repair toolbox" application but this tool indicates the following:

    "All bytes in the file myfile.xls are equal zero. Program can not do anything with an empty file"

    Any ideas?
    Regards.

    • Post Points: 37
  • Sat, Apr 11 2015 1:02 PM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 233
    • Points 3,157

    Re: How to recover a corrupted excel file ?

    It appears you have a major file system corruption. This is not an Excel question but a Windows recovery issue. You may need to use utilities such as CHKDSK or similar to see whether it can rebuild the file system. Then, you still may need to recover these specific files from backup. I wouldn't trust anything on that server until this is all done.

    Oh, and get a proper battery backup in place and make sure to use its usb connection so Windows knows to shut itself down safely before the battery is dead.

    Omar Freeman Kitchener, ON

    • Post Points: 5
  • Tue, Apr 14 2015 3:11 AM In reply to

    Re: How to recover a corrupted excel file ?

    Please try eRepair Excel is an advanced Excel repair tool, which is able to fix Excel files of any version (xlsx repair also supported), except for password protected files. Excel file repair tool retrieves the contents of the damaged Excel file and saves the recovered data as a new workbook, while the source Excel file remains unaffected.

    For more: http://excel.erepairtools.com/

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.