Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Another method for Saving Corrupt Data. (Excel 2000 >)

    I discovered another method for saving corrupt excel data. A common method is the save the file as HTML, and attempt to retrieve the data after opening it in that format in a browser.
    I have not come accross this following method much, but I figure that if you have corrupt data, you will be willing to try any method to save it....

    Well here is another method to try:

    1. Open two new workbooks.
    2. Select cell A1 in one of the workbooks and then press Ctrl+C to copy.
    3. Activate the second workbook and choose Paste Special on the Edit Menu, and then click Paste Link.
    4. Choose Links on the Edit Menu, click Change Source, locate the corrupt workbook, select it and click OK.
    5. Click OK again in the Links Dialog box.

    If luck is with you, data from cell A1 in the corrupt workbook should appear in cell A1 due to the linked formula.

    6. If so, press F2 to activate Edit Mode and press F4 three times to convert the references from $A$1 to A1.
    7. Copy the relative formula down and accross as far as needed to see all the data you need to retrieve.
    8. Repeat the process for each sheet in the workbook!

    PS: Lets hope you will NEVER need to implement this anyways - <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    Regards,
    Rudi

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

    Re: Another method for Saving Corrupt Data. (Excel 2000 >)

    I presume that if this succeeds, you'll next want to convert the link formulas to values, otherwise you'd remain dependent on the corrupt workbook. (Select range, copy, paste special > values)
    Note that this method only rescues values, not formulas, charts, etc.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Another method for Saving Corrupt Data. (Excel 2000 >)

    Thanx, that is important to state!
    Regards,
    Rudi

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

    Re: Another method for Saving Corrupt Data. (Excel 2000 >)

    As an alternative to opening the html file in your browser I'd suggest to try Excel first, if it succeeds, you recover almost everything of the corrupt workbook.

    See this page for more info on recovery of corrupt files.
    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
  •