• Crash after rename Auto-backup copy (<save option)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Crash after rename Auto-backup copy (<save option)

    Author
    Topic
    #400330

    Edited by unkamunka to make the link “live”

    Hurray hurray, thewave
    I got stuck on an Excel feature that apparently has a lot in common with fastening seat belts: they’re there to save you, but in some particular circumstances you’re better off without them…
    I renamed an Excel file and its backup copy (the file Excel automatically produces when you have activated this particular file save option). And since then I can’t open it anymore without Excel crashing each time I try to reopen the file. Halfway the loading process of the file Excel gets stuck, shows a message box ‘Can’t read file’ and crashes immediately after you’ve clicked (no choice…) ‘OK’ (God MS’ never lasting smile).
    Didn’t help opening:
    – a restore from a backup dating from some days ago
    – a copy of the files on a folder on my hard disk
    – only the ‘original’ file after removing the backup copy from the folder on my hard disk
    – a copy of the files on my portable featuring Excel XP.
    Didn’t help either: run “excel.exe /regserver”
    With other files than this one, Excel opens without a hassle.

    BTW, I had a look in the MKDB and look what I found:
    Microsoft Knowledge Base Article 149235: How to Prevent File Corruption
    Feature number 2: Automatic Backup ribbon thumbup ribbon

    Maybe I’ll find some time over the weekend to measure up the damage – a fine job, definitely (I’m not maintaining a detailed log about the data validation, formula and pivot table changes and graph creations I do, certainly not from the moment I started using that backup copy option +- one month ago) and maybe start all over from the last ‘working’ version I’ve left scream weep.
    But in the mean time, you never know: any suggestions are greately appreciated,
    Hasse

    Viewing 0 reply threads
    Author
    Replies
    • #781143

      Maybe this page gives some pointers:

      http://www.jkp-ads.com/CorruptFiles.htm%5B/url%5D

      Also check my download page and spot the file called Autosafe.zip.

      • #781237

        J K,
        I’ll certainly give that autosave.zip a look – I’m curious if it ‘ll work on Excel 97 too.
        At first sight it ‘ll probably be very useful – at least for the future.
        So thanks!
        Hasse
        FYI: I can confirm what you stated on your website about Office XP being able to sometimes repair XL files with trouble. In my case the resulting repaired file seems to contain all data – the graphs have vanished.

        • #781243

          My AUtosafe works on all Excel versions from XL97. But as from XP Excel has its own recovery option (Tools, Options, Save tab), which works very similar to my Autosafe (and I still wonder where they got it from )

        • #781244

          My AUtosafe works on all Excel versions from XL97. But as from XP Excel has its own recovery option (Tools, Options, Save tab), which works very similar to my Autosafe (and I still wonder where they got it from )

      • #781238

        J K,
        I’ll certainly give that autosave.zip a look – I’m curious if it ‘ll work on Excel 97 too.
        At first sight it ‘ll probably be very useful – at least for the future.
        So thanks!
        Hasse
        FYI: I can confirm what you stated on your website about Office XP being able to sometimes repair XL files with trouble. In my case the resulting repaired file seems to contain all data – the graphs have vanished.

    Viewing 0 reply threads
    Reply To: Crash after rename Auto-backup copy (<save option)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: