Recover Tool

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
 
J

Jan Karel Pieterse

Hi Kay,
I am looking for a tool to clean and
recover corrupt files. I am looking for some feedback and
recommendations.


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top