+ Reply to Thread
Results 1 to 3 of 3

Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrupt"

  1. #1
    Registered User
    Join Date
    New York
    MS-Off Ver
    Office 2007

    Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrupt"


    After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.

  2. #2
    Registered User
    Join Date
    MS-Off Ver

    Re: Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrupt

    To repair corrupted Excel Files, try Open and Repair function of MS Excel first. It is built-in repair function that helps me fix my corrupt .xlsx files and open them. As it is a built-in feature, it has a drawback. It might not work in severe corruption issues. In such situation, we can try a third-party recovery programs to recover data from corrupt XLSX files that helps helps you repair corrupt .xlsx files and recovers your maximum possible data from them.

    Admin note: I have modified your post slightly to remove references to commercial software/sites, which are not permitted on this forum. If yo feel that these links should be restored, please PM me and explain
    Last edited by FDibbins; 01-14-2016 at 03:05 AM.

  3. #3
    Registered User
    Join Date
    MS-Off Ver

    Re: Excel spreadsheet gets error "Excel cannot open the file .xlsx.." How can I "uncorrupt


    When an Excel file is corrupted, then you can try several methods to recover it:

    1. First of all, you can try to repair the file manually in Excel, as follows:

    (1) On the File menu, click Open.
    (2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
    (3) Click Open and Repair, and then choose which method you want to use to recover your workbook.

    You may find more information about this at:

    (for Excel 2003)
    http://office.microsoft.com/en-us/ex...017.aspx?CTT=1 (for Excel 2007)
    http://office.microsoft.com/en-us/ex...840.aspx?CTT=1 (for Excel 2010)
    http://office.microsoft.com/en-us/ex...554.aspx?CTT=1 (for Excel 2013)

    2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below


    3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

    3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.

    3.2 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.

    Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.

    4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR at http://www.rarlab.com to repair the file, as follows:

    4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
    4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
    4.3 Rename a_fixed.zip back to a_fixed.xlsx
    4.4 Using Excel to open a_fixed.xlsx.

    There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.

    5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at


    It provides a free demo version so that you can try to see if the data you want can be recovered or not.

    Good luck!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Replies: 3
    Last Post: 11-10-2012, 05:38 PM
  3. Problem in Excel 2011 (mac): "file.xlsx is already open"
    By berlini in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-09-2012, 12:01 AM
  4. Replies: 1
    Last Post: 06-05-2006, 08:20 AM
  5. How do I open an "excel spreadsheet file, extention .xls"?
    By Kameron Lewis in forum Excel General
    Replies: 1
    Last Post: 08-21-2005, 07:05 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1