Recover Tool

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

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
 
Hi Kay,
I am looking for a tool to clean and
recover corrupt files. I am looking for some feedback and
recommendations.
Click to expand...


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.

BTW: I've heard more bad things about sharing XL files between XP and
2000.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top