Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Nixa, Missouri, USA
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreadsheet recovery

    Howdy folks. I have a users spreadsheet that is all of 2000 inventory data. Of course "what backup, don't you do those?" was the reply from the user. Now I have a 2+MB file that when attempting to open I get "Unable to Read file." Any ideas to recover? Any freeware recovery?
    I greatly appreciate your time.

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    St. Louis, Missouri, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet recovery

    Microsoft has a match for this in the Excel knowledgebase, article Q142117. Here's the address: <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/q142/1/17.asp>http://support.microsoft.com/support/kb/ar...s/q142/1/17.asp</A>

    The method I have been most successful with is to make a link from another workbook to grab the data. A bit of work, but at least you'll have your data.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Nixa, Missouri, USA
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet recovery

    Thank you. It worked. I did the (=filename.xls!a1) and took part of each page, a couple of hours and it worked. Thanks a million.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet recovery

    I would suggest you to check out my Autosafe utility. Find it at:

    http://www.bmsltd.ie/mvp (near bottom of web page)

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet recovery

    Any suggestions about the recovery of formulas too?
    Murphy's about to rob at least a day's work :-p.
    (Got a 18 Mb file which can't be opened no more - no useable results with opening it in Word/IE/WordPad)

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Spreadsheet recovery

    This is one of the main reasons you need a backup to recover from. use the backup first, then edit that to just add the new formulas you created since then.

    Barring a backup, you might attempt to open the file with Open Office. I have never used it, but heard that it does open some things that excel will not.

    I do not think there is any way to see formulas in a workbook without opening the workbook. You can see the values in closed workbook, but not the formulas.

    Steve

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet recovery

    You could zip and send it to me if you like, just send me a pm. <!profile=pieterse>pieterse<!/profile>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    OK with OpenOffice - Re: Spreadsheet recovery

    Thank you <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> JKP. FYI:
    - he saved my day using OpenOffice ('gonna try to install it here too one day). Got a message that some data might be lost but at first sight, only the conditional format in some tab(s) is lost (starting from row 257). Jippie;
    - if you are stuck, with no-one here to help you and you're even prepared to pay for it: a quick google search showed that there are fast recovery services & software available from 50$ & up. But of course it's better preventing...
    - when you use JKP's SafeAs utility, I would recommend the 'Move to recycle bin after closing' option to auto-copy backup file(s) to your trash (instead of deleting them when you close your file), so you can restore the file's last/... saved version from your Trash. This could save you a recovery-repair if, like in my case, excel e.g. fails to open a properly (?) closed file.

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OK with OpenOffice - Re: Spreadsheet recovery

    And another thing to do after recovery is to roundtrip via html as explained at the bottom of this page:

    http://www.jkp-ads.com/CorruptFiles.htm
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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