Re: How do I deal with repeated document corruption in the same Excel.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nick Hodge (nick_hodgeTAKETHISOUT_at_zen.co.uk.ANDTHIS)
Date: 12/28/04


Date: Tue, 28 Dec 2004 08:39:37 -0000

Paul

I would suspect you need to get this out to a new workbook, not just rebuild
what you have. It sound like perhaps a style is corrupt or similar which is
not being rectified by your 'formula/format' rebuild

-- 
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"wanderingoscar" <wanderingoscar@discussions.microsoft.com> wrote in message 
news:9F71F3AB-B7B5-4700-85F5-A10047C2B1BB@microsoft.com...
>I have a relatively small and simple workbook that has now gone corrupted 
>for
> the third time.  It takes about 2 hours to replace all the formulae and
> formats that get stripped in the recovery function.
>
> This is intolerable!
>
> Paul 


Relevant Pages

  • Re: NETWORKDAYS() saved as =#N/A in XL2007
    ... That workbook looks nothing like the previous one. ... and then reopening the file it will corrupt after 3-5 tries. ... Microsoft Excel MVP ... it but here's an alternative to NETWORKDAYS: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: NETWORKDAYS() saved as =#N/A in XL2007
    ... You have macros in your workbook. ... and then reopening the file it will corrupt after 3-5 tries. ... Microsoft Excel MVP ... it but here's an alternative to NETWORKDAYS: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Corrupted DBP File
    ... Bill and Gil, ... Fortunately its header information for ... Error's 2 usually indicate a corrupt file. ... >> was able to rebuild the DDF Files using the utility out of Control ...
    (comp.databases.btrieve)
  • Re: Corrupt Excel Files after Crash
    ... next version's XML file structure should, I would think, make corruption ... workbook with this option enabled, create a new workbook, format it the ... Second, once a workbook begins to corrupt, it's on a death-spiral. ... way to cure a corrupt workbook is to copy your worksheets (using ...
    (microsoft.public.mac.office.excel)
  • Re: Corrupt File Issues - Opening in 2003
    ... And the others were based on a different workbook. ... The only time I've seen a corrupt workbook had one worksheet that was bad. ... I run a data extraction from a repository monthly which opens ...
    (microsoft.public.excel.programming)