Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupt excel file (2003)

    Hi,
    I have a very small (110kb) but massively important excel document that appears to be corrupt and I am unable to open. Upon attempting to open, both via excel or explorer, I get the following message:

    The document is corrupt and cannot be opened. To try and repair it, use the open and repair command in the open dialog (File menu) and select Extract Data when prompted.

    I don't seem to have this command available to me (unless I am going seriously blind), any suggestions??

    The file contains minimal formula's and no code, just important data. I have no backup..... <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Thanks
    Nathan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Corrupt excel file (2003)

    In the first place, make sure that you make backups regularly and frequently from now on! This is essential!

    See Repairing corrupted files in Excel for some recommendations from Microsoft.

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt excel file (2003)

    <img src=/S/sad.gif border=0 alt=sad width=15 height=15> I'm not having a good week!! <img src=/S/sad.gif border=0 alt=sad width=15 height=15>. I have tried manual repair and just about every other possible option that I have come accross. Manual repair says 'unable to read file' and will neither repair or extract data. I think I will have to put this down to a [bad] experience and manually re-create.

    note to self: must make copie's!!!!

    <img src=/S/sad.gif border=0 alt=sad width=15 height=15> Nathan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Corrupt excel file (2003)

    There are third-party recovery tools. Most are not free but offer a limited free trial version. Several are listed in Steps to Recovering a Corrupt Excel File.

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Corrupt excel file (2003)

    Have you tried downloading and using Excel Viewer 2003 from the Microsoft site? It's a bit of a long shot, but you may find you can retrieve the data into another spreadsheet

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Corrupt excel file (2003)

    If you have OpenOffice (freely downloadable) you might try and see if that will open it. Otherwise attempting a straight formula link from a blank workbook to cells in the closed workbook might get something back?
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt excel file (2003)

    Thanks for all your suggestions.. I will attempt them all this evening and report back.

    I'm utterly baffled though!! I use massive workbooks all day most days with mass amounts of formula's, code, conditional and normal formatting >> never get any problems. I have a tiny workbook with data (typed in) I can't afford to lose, and it becomes corrupt?? NO sense!! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Corrupt excel file (2003)

    That's life - these things always happen where you least expect them and when it's maximally inconvenient... That's why frequent backups are so important.

Posting Permissions

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