Article View: comp.apps.spreadsheets
Article #4Re: How to fix a corrupted Excel-file ?
From: *Steve White
Date: Wed, 28 Oct 1992 01:11
Date: Wed, 28 Oct 1992 01:11
34 lines
1854 bytes
1854 bytes
In <kka.720216369@tko.vtt.fi> kka@tko.vtt.fi writes:
> Hello World,
>
> is there any program out there (PD or commercial) to fix a corrupted
> excel file which is loaded 95 percent correct until it stops with
> an error message.
>
> Any hints are highly appreciated!
>
> Regards
>
> Klaus
Two possibilities that I know:
1. MacTools supposedly has a module that recovers Excel/Mac files, but I
haven't used it yet.
2. Open a new spreadsheet, select within the new sheet a range of cells
that would cover the corrupted sheet, enter into cell A1 of the new sheet
an external reference to the old sheet's cell range, make the entry
an array (in Mac/Excel, command-enter). Hopefully, then you then will
see in the new sheet the values in the old one. If you wish, you can then
do copy/paste special-values command to convert the formulas in the new
to the values in the old one.
Good luck!
Steve
--------------------------------------------------------------------------
<< The above are nothing more than my personal opinions >>
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------
Technical Details
Message-ID:
<1ckpc5INNm5u@lester.appstate.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!ogicse!usenet.coe.montana.edu!decwrl!concert!lester.appstate.edu!lester.appstate.edu!usenetReferences:
<kka.720216369@tko.vtt.fi>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!ogicse!usenet.coe.montana.edu!decwrl!concert!lester.appstate.edu!lester.appstate.edu!usenet From: WHITESR@CONRAD.APPSTATE.EDU (*Steve White ) Newsgroups: comp.apps.spreadsheets Subject: Re: How to fix a corrupted Excel-file ? Message-ID: <1ckpc5INNm5u@lester.appstate.edu> Date: 28 Oct 92 01:11:33 GMT Article-I.D.: lester.1ckpc5INNm5u References: <kka.720216369@tko.vtt.fi> Distribution: world Organization: APPALACHIAN STATE UNIVERSITY Lines: 34 NNTP-Posting-Host: conrad.appstate.edu X-News-Reader: VMS NEWS 1.24 In-Reply-To: kka@tko.vtt.fi's message of Tue, 27 Oct 1992 20:06:09 GMT