Excel cannot open the file ‘file.xlsx’ because the file format

5 pts.
Tags:
Microsoft Excel
Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Excel cannot open the file claim format.xlsx because the file format or file is not valid. Verify that file has not been corrupted and that the file extension matches the file.

I see this most often when a file has been transferred around a lot and gets corrupted due to bad sectors on hard drives, bad thumb drives, etc…

Occasionally, I find a repair utility that will….kind of….fix it. You tend to lose all formatting and usually the user

Would have to spend more time doing than life than simply starting from scratch. If on a file server, shadow copies (previous versions) are a god send.
If it happens completely randomly, does it happen more often to the same group of people? Perhaps an update malfunctioned?

Discuss This Question: 24  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • clark445kent
    Hi, this error comes due to unsupported file extension of your excel file. In this situation, you have to need to rename the file and change its extension from '.xlsx' to '.xls'.
    8,235 pointsBadges:
    report
  • hunshabbir7
    This could be due to Excel version. If you have older version of Excel which doesn't support xlsx file extension when you try to open xlsx then this error could occur.
    2,900 pointsBadges:
    report
  • Harisheldon
    Before you open the file, try copying it and changing the extension to either an older version, .xls, or another type, like.csv, and see what you get.  I get this sometimes when reports are run and I have to save it to my desktop in another format before it opens.  It is a pain, especially when your boss is looking over your shoulder...
    12,885 pointsBadges:
    report
  • TheRealRaven
    What does the file content look like? Does it actually contain .XLSX data?
    29,400 pointsBadges:
    report
  • Brijesh
    Is that happens in excel 2007 or hopefully the file may be corrupted.
    14,450 pointsBadges:
    report
  • ToddN2000
    This may be due to the file being created on a newer version of Office. What version are you using? That file extension looks like an Office 2010 or newer. The person who created the file could save it as an earlier version so you can open it. I believe Office had a patch to correct this, but I can't find it in my note at the moment.
    117,375 pointsBadges:
    report
  • Kroy00
    Hi ToddN200
    Can you give me the information around the patch you mentioned? I was using the file in my laptop and all of sudden it happens and not opening. I am using exact same office version. 
    THanks. 
    20 pointsBadges:
    report
  • ammkidd
    Few useful manual solutions are given there in a blog which I have bookmarked a couple of months ago. The blog post has written on the MS Excel file and its corruption issues. 

    For more information, you can read N.Sem' Blog || How to Repair Corrupted Excel File? 

    I really hope this would be helpful for you. 

    Regards. 
    50 pointsBadges:
    report
  • Kroy00
    I tried both of manual steps from the blog.
    For the first solutions, after you select the corrupted XLSX file(step3), I am not seeing Open and Repair option. What version of office do you use? I am using excel 2013 and I dont see that option.
    So I tried the second solution, after I save the file as SYLK (*.slk) format, rather than those 2 message screenshot from the blog, I got the message pop up saying,
    Some features in your workbook might be lost if you save it as SYLK(Symbolick //link).
    Do you want to keep using that format?
    I just click yes, and follow the rest steps.. but no luck.
    Any help?
    20 pointsBadges:
    report
  • ToddN2000
    Here is the LINK for the compatibility ink to open other versions.
    117,375 pointsBadges:
    report
  • onemasum
    "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
    10 pointsBadges:
    report
  • prabuanand
    Excel cannot open the file claim format.xlsx because the file formate or file is not valid. Verify that file has not been corrupted and that the file extension matches the file.
    10 pointsBadges:
    report
  • rajeevtomar
    this is a trogan virus and it corrupt the directory of windows due to this excel file show the corrupt. we can use the microsoft scaner for this poblem
    10 pointsBadges:
    report
  • angelcsh88
    I got this error this morning when i went to open my file. Is there any way i can get this back. This file is extremely important to me and I need to get this back. Please someone help me.
    40 pointsBadges:
    report
  • ToddN2000
    What version of Office are you using and have you tried using the repair tool?
    117,375 pointsBadges:
    report
  • Subhendu Sen
    Look after the .bak file, if you can recover the same.
    121,900 pointsBadges:
    report
  • angelcsh88
    Microsoft Excel Worksheet (.xlsx). How to repair tool?
    40 pointsBadges:
    report
  • ToddN2000
    Repair a corrupted workbook manually
    1. On the File tab, click Open.
    2. In the Open dialog box, select the corrupted workbook that you want to open.
    3. Click the arrow next to the Open button, and then click Open and Repair.
    4. Do one of the following: To recover as much of the workbook data as possible, click Repair.
117,375 pointsBadges:
report
  • angelcsh88
    I already tried but still can not to open the file.
    40 pointsBadges:
    report
  • ToddN2000
    Sometimes it's just beyond repair. This is a case where a backup would help. If you do not have a backup sometimes you can get some of the information back if you have emailed this as an attachment. You may be able to get an older version from your sent items. The other option is if you emailed it to someone, have them send you a copy back.
    117,375 pointsBadges:
    report
  • Subhendu Sen
    Or you can get help from Word help menu which has a .chm file and it has an excellent contents that can help you a lot.
    121,900 pointsBadges:
    report
  • RoninRahul
    May be the file was edited to the extension .xlsx
    10 pointsBadges:
    report
  • gjgjgj
    When I get a corrupt Excel file that won't open in Excel, I open it with Libre Office and save it under a new filename. It works every time.
    10 pointsBadges:
    report
  • Robinsan
    You can try these basic methods to fix this opening file issue XLXS mentioned in Blog to fix the error of excel cannot open the file in MS.

    Method 1: Modify File Format of Workbook
    1. Launch MS Excel 2016 application[according to your version] on the system.
    2. Click on File tab to bring its menu.
    3. After that, select Export option from the pop-out menu.
    4. Next, select Change File Type under the Export section. Afterward, choose Workbook(*.xlsx) option under Change File Type heading.

    Method 2: Take Help of ‘Open and Repair’

    1. Start Excel application and click on File tab.
    2. Go to Open option and click on Browse to upload the file that is corrupted.
    3. From the Open window, select the file and go to the Open drop-down button.
    4. Hit the button and select Open and Repair. 

    30 pointsBadges:
    report
  • Forgot Password

    No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

    Your password has been sent to:

    To follow this tag...

    There was an error processing your information. Please try again later.

    Thanks! We'll email you when relevant content is added and updated.

    Following

    Share this item with your network: