Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    Cleveland, Ohio, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Recover Tool (Excel XP SP -2)

    I have several Excel XP files that are corrupt. Most files receive a Run-time '6' error or they just freeze. A lot of the issue focuses on the fact the content has been manipulated over 10 years with various applications (Lotus 123, Access 97 and Excel 97, 2000 now they are in Excel XP). Some are linked in various manners (other spreadsheets, worksheets, access, etc.) Most recently they are shared between Excel XP and 2000. Some I can open while others I can't. I am looking for a tool to clean and recover corrupt files. I am looking for some feedback and recommendations. The catch is that I need it to retain links and formatting. I apologize if this question has been asked before (I am sure I am not the first).
    Smiles
    Kay
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

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

    Re: Recover Tool (Excel XP SP -2)

    I'll repeat what I've said on the MS newsgroup:

    Sometimes a corrupt file that still can be opened,
    can be cured using this method (XL2000 or up):

    - Open the file
    - Save-as filetype Webpage
    - close the file
    - Open the html file
    - save-as normal Excel workbook.

    I've heard too many complaints of trouble when workbooks are shared between XL2000 and XL XP.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    May 2002
    Location
    Cleveland, Ohio, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recover Tool (Excel XP SP -2)

    Thanks for your suggestion!!! Unfortunately, I am dealing with files that are crashing when opened (Run Time '6'). I do appreciate your response.
    Smiles
    Kay
    <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recover Tool (Excel XP SP -2)

    This may prove to be a totally uninspired suggestion (partly inspired by the fact that we don't know what in the corruption triggers the crash), but you might try seeing if you have any luck booting into Safe Mode and attemtping to open the files from there. Another remote possibility is attempting to open a copy with one of the open-source Office compatible packages.
    Gre

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

    Re: Recover Tool (Excel XP SP -2)

    OK some more thoughts then:


    Options to try and open a corrupt file

    - Set calculation to manual
    - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security)
    - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets.

    If that does not work, try creating a link to the file:

    ='c:my documents[MyFileName.xls]Sheet1'!A1

    and copy right and down. This at least gets you the worksheets values.

    if you don't know the sheet names, enter this:

    ='C:PathToFile[MyFileName.xls]'!A1

    and press enter

    If XL (2000) is able to extract them, it will prompt you for a sheet name.

    Sometimes the Excel viewer, Word or even Internet explorer (v5) enables you to open the file and copy information out of it.

    If the file is not protected, maybe you can open it with OpenOffice (www.Openoffice.org).

    Also, Excel XP can sometimes repair XL files with trouble.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  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: Recover Tool (Excel XP SP -2)

    There are also commercial file fixers (try googling "fix corrupt excel files") which I have not used so I don't know the value of them. Some claim to be able to recover the links and formulas and most have demos so you could "test them"

    Steve

  7. #7
    Lounger
    Join Date
    May 2002
    Location
    Cleveland, Ohio, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recover Tool (Excel XP SP -2)

    Thanks so much for everyone's comments and suggestions. One thing that I have noticed is that these files all work fine if they edited, saved and stored on a local hard drive. If they are used on a network drive (Windows XP SP-1) they seem to crash while saving and useless after that. Ever heard of such a thing? Thanks a million. Smiles
    Kay

  8. #8
    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: Recover Tool (Excel XP SP -2)

    Could be anti-virus software settings and you might need to speak to your IT department.

    Steve

Posting Permissions

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