+ Reply to Thread
Results 1 to 10 of 10

excel file will no longer open, get error msg

  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    2010
    Posts
    4

    excel file will no longer open, get error msg

    hi to all,
    I have a huge .xlsx 2007 file, today at opening I've got an error - This file is not in a recognizable format. I applied open and repair, but it didn't assist me. I search recovery excel feature, if someone can assist, please...
    Last edited by FDibbins; 12-06-2016 at 01:27 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: excel file problem

    Welcome to the forum.

    I suggest that you change the title of your thread to something like "Excel file is not in a recognizable format error" or something more descriptive as all problems here could be classified as an excel file problem.

    Having said that, I suggest that you find the file in question in Windows File Explorer and right click on the file. A menu will appear and one of the choices should read something like "Restore Previous Versions." Click on that and you may be presented with a list of previous versions of the file. If you get such a list, double click on the one with the latest date to open it. If this opens, it will be the last version of the file without whatever corruption is causing the latest file not to open.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    12-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    2010
    Posts
    4

    Re: excel file problem

    Thanks man, I hope it must assist me, I'll say about the results.

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: excel file problem

    plz attach problem file.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: excel file will no longer open, get error msg

    I have changed your title for you (as was requested by newdoverman)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    12-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    2010
    Posts
    4

    Re: excel file will no longer open, get error msg

    I can't attach my file, because it contains data of my company...

    I don't mind changing a title, but can someone suggest more variants for solving?

  7. #7
    Registered User
    Join Date
    04-06-2015
    Location
    paris
    MS-Off Ver
    Excel 2007 SP3, Excel 2021
    Posts
    14

    Re: excel file will no longer open, get error msg

    @levers80

    Probably it's a corrupt ZIP file because last time it was saved something went wrong and the save process aborted.

    You can verify this by renaming this .XLSX file as a .ZIP file and then try to unzip its contents.

    If you get an error message, indeed the ZIP file is corrupt and you may recover all or parts of the contents by using a ZIP recovery tool.

    If you don't get an error message, that is good news for you, because it means the underlying file format is OK, and at worst you should lose marginal content. Of course to recover from this, it is a manual process. Perhaps you can use OpenOffice try to open it if you are lucky, or send it to me personally for further inspection.

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: excel file will no longer open, get error msg

    Did you locate the file in File Explorer and Right click on it and choose Previous Versions? If you did, if you received a listing of files, choose the latest version before the problems began and open it and save with a new name. If you didn't get a list of previous versions, do you have a backup plan where you work...if you don't have one the company certainly should implement one ASAP. If there is a backup plan in operation the latest versions of the file should be able to be retrieved for you.

  9. #9
    Registered User
    Join Date
    12-14-2016
    Location
    New Orleans
    MS-Off Ver
    2016
    Posts
    3

    Re: excel file will no longer open, get error msg

    Quote Originally Posted by levers80 View Post
    hi to all,
    I have a huge .xlsx 2007 file, today at opening I've got an error - This file is not in a recognizable format. I applied open and repair, but it didn't assist me. I search recovery excel feature, if someone can assist, please...
    MS Excel is one of the magnificent and complicated programs that was created among all other programs...Thanks to Microsoft!

    But another side of this software, that its files filled numerous data, and some external factors can damage it.

    That's why Microsoft developed AutoSaving every some seconds, minutes, hours - like you want and Open&Repair function for extreme cases, but there is situation when nothing of these helped, then refer to Excel online repair service - it is a new modern way to get one file after another - https://onlinefile.repair/en/excel.html

  10. #10
    Registered User
    Join Date
    12-01-2016
    Location
    Salt Lake City, UT
    MS-Off Ver
    2010
    Posts
    4

    Re: excel file will no longer open, get error msg

    I think this thing must be effective...

+ 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] Problem with Saving .csv file as excel file
    By dreindorf in forum Excel General
    Replies: 3
    Last Post: 02-10-2016, 06:59 PM
  2. [SOLVED] problem with copying the formula from one excel file to another excel file.
    By sourabh patil in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-06-2015, 05:59 AM
  3. Replies: 0
    Last Post: 09-06-2013, 05:31 AM
  4. Replies: 1
    Last Post: 07-15-2013, 05:25 AM
  5. Error of personal information in Excel File
    By waqarqrl in forum Excel General
    Replies: 1
    Last Post: 10-04-2012, 02:01 AM
  6. Problem saving Excel file that copies an embedded object from a separate file
    By bhodge10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 02:47 PM
  7. problem with insert Excel file in another Excel file
    By Rao Ratan Singh in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-11-2006, 04:15 PM

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