Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

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

    Edited by unkamunka to make the link "live"

    Hurray hurray, <img src=/S/thewave.gif border=0 alt=thewave width=225 height=33>
    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:
    <!mskb=149235>Microsoft Knowledge Base Article 149235<!/mskb>: How to Prevent File Corruption
    Feature number 2: Automatic Backup <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15> <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15>

    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 <img src=/S/scream.gif border=0 alt=scream width=15 height=15> <img src=/S/weep.gif border=0 alt=weep width=21 height=16>.
    But in the mean time, you never know: any suggestions are greately appreciated,
    Hasse

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Maybe this page gives some pointers:

    http://www.jkp-ads.com/CorruptFiles.htm

    Also check my download page and spot the file called Autosafe.zip.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

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

    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.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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 <g>)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •