+ Reply to Thread
Results 1 to 4 of 4

Excel cannot open the file 'file name.xlsx' because the file format or file extension is n

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    New Delhi
    MS-Off Ver
    2007
    Posts
    22

    Excel cannot open the file 'file name.xlsx' because the file format or file extension is n

    Dear Seniors,
    I have one .xlsx file which shows an error "Excel cannot open the file 'file name.xlsx' because 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 said file had a data since 2013 very difficult for me again organise the data can any body help / guide for the recovery of the excel file.
    Regards,
    Kosh
    ====

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,083

    Re: Excel cannot open the file 'file name.xlsx' because the file format or file extension

    Hi,

    Are you sure that the file is actually in xlsx format and not .xls for example?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Excel cannot open the file 'file name.xlsx' because the file format or file extension

    Good afternoon koshish

    Whether you can or can't restore this file, you need to consider some kind of backup exercise for your files.

    Your profile indicates you have XL2007 - I'm not sure if this functionality is available on that version, but in later versions you can go to open the file, but the "Open" button in the file selection pane has a dropdown arrow. Click on the arrow and one of the options is to Open and Repair. Try that.

    Beyond that, there are some links in this thread that may be of use. For the main one, you need to be able to open the file, which won't be any good in your case, but work through the others and see how you go.

    Regards

    DominicB

  4. #4
    Registered User
    Join Date
    10-22-2014
    Location
    New Delhi
    MS-Off Ver
    2007
    Posts
    22

    Re: Excel cannot open the file 'file name.xlsx' because the file format or file extension

    the files are in xlsx format

+ 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. Macro to open a list of spreadsheet and save them under file extension xlsx file
    By gdclyde in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2017, 07:16 PM
  2. Replies: 1
    Last Post: 09-21-2014, 06:22 PM
  3. How to save file with correct file extension, .xls or .xlsx?
    By Alexb77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 12:52 PM
  4. Replies: 4
    Last Post: 10-23-2013, 12:54 AM
  5. Replies: 3
    Last Post: 11-10-2012, 05:38 PM
  6. Replies: 10
    Last Post: 06-07-2012, 09:17 AM
  7. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM

Bookmarks

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