Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is Autorecovery = Autosave in Excel ? (97)

    The autosave function in XL is easy to understand. It automatically saves your file every 10 minutes or whatever.

    I can't get my head around the auto recovery in Word- can someone spell out for me what it does. Does it "auto save" a back up file? Why doesn't it just save the file I'm working on rather that save a backupfile in some black hole somewhere? (if that's waht it does).

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    When you make changes to a Word document, Word does not write to the file directly...it saves the changes in a temp file. Every time you save the document to disk, the temp file is renamed as the file. AutoRecover is simply that every so many minutes, Word saves a temporary file with an .asd extension. If you crash & restart Word & your document, Word will say that it has recovered the document & offer to save it as your document. If you look on the status bar, you will see a pulsing safe when Word is saving the file. Every time you save your file, or close it, the .asd file is deleted.

    For more information, press F1 (in Word) & look for AutoRecover.

    Cheers,

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    They are very different. Word has no AutoSave feature, only an AutoRecovery. The AutoSave basically is doing the same thing you do when you click the Save button... it does a full reliable save.

    The AutoRecovery only works as disaster relief. Should the computer stop, the next time you start it your file will show up automatically as a recovered document. You then grab that document and do a real save to keep it. The recovered document will have all your latest work in it up until the last time AutoRecovery copied it. That's because AutoRecovery periodically makes a copy of your work as a SEPERATE file from your real document. But when the recovered document comes up and you dismiss it without saving, your document is hosed.

    AutoSave, on the other hand, does a true full save of the document... just as you would by clicking File>Save. I've heard horror stories of times when AutoRecovery did NOT recover a document, and rumors that the feature itself might cause some machines to become more unstable and crash. I've never heard that about AutoSave, however.

    I use AutoSave rarely (and AutoRecovery never) because I'm so ingrained with proper saving habits. But, on occasion, I can be involved in a VBA project in Excel where I get so fixated I forget to save. I would then use AutoSave with the option to prompt me so I don't blow my work.

    Here's the freaky news. In OfficeXP they eliminated the real AutoSave feature, thinking users won't mind AutoRecover instead. But that's Microsoft, always thinking for us. They're so considerate.

    -Lenny

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Los Angeles, California, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    Be advised, if you must "End Task" on Word then your Autorecovery file (if there was one) is DELETED. Baddddddddd programming decision. If you haven't saved and are relying on AutoRecover (not the best idea) when Word freezes up, then POWER OFF the computer to make sure the autorecover is not automatically deleted.

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    The only good strategy is to save frequently. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> But seriously, I often make a set of changes that I want only in a new document (I plan to Save As) and I wouldn't be too happy if Word suddenly decided it was time to change the original. I'm not sure why that feature was implemented in Excel; I might go turn it off now that I've heard about it.

  6. #6
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    I have great saving habits, but still believe AutoSave has it's place. I use the "Prompt to Save" option in AutoSave (when I rarely use it at all). Like you, I may NOT want it to save on one occasion.

    A good example is an Excel spreadsheet that takes a good 15 seconds to save each time I save. As I'm working on it's VBA, I may be just reading the code and don't need to save every 10 minutes because I haven't done any work and don't need it to lock up for 15 seconds for nothing. So I save only when I should.

    But if I start coding and get fixated, I may forget to save when I really need to. It's hard to switch from "save often" to "save only when needed". The AutoSave reminds me and gives me the choice of saving or not. I can have it remind me every 15 minutes or so. AutoRecovery can NOT do that.

    I know lots of users who use AutoSave in Excel and wish it was in the other programs. I just say don't use it (or AutoRecovery) as a crutch for normal saving. Nonetheless, it was a wonderful feature. One that's removal by MS was unwarranted. But since when does MS need logic for thier decisions?

    -Lenny

  7. #7
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    >Be advised, if you must "End Task" on Word then your Autorecovery file (if there was one) is DELETED.

    Good point (among many not to rely on AutoRecovery). I know an executive who worked on a document (off the A drive) for three hours, never saved, and then a crash happened. He thought AutoRecovery was his safety net, but evidentally AutoRecovery doesn't work from the A drive. He lost all his work and was might miffed about it. I think users who rely heavily on it are setting themselves up for a fall.

    -Lenny

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Winston-Salem, North Carolina, USA
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    I can't tell you how many times during my Help Desk days I was awakened by my pager in the middle of the night because someone had worked on a document for 5 or 6 hours, had never saved it, then had his computer crash and wanted to know what he could do to recover the document. Usually the answer was nothing, an answer that doesn't make attorneys happy at 2am. Now, as a trainer, when I do new employee orientations, I always give them the save frequently in Word lecture. Manual saves are your best defense against losing your document, and the AutoRecovery option in Word is, IMHO, useless. I have to say it's somewhat more dependable in Word 2000 than it was in earlier versions, but it's still not to be relied on.

    Lee Morgan

  9. #9
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    I hear ya, Lee!

    I have about a three page document I wrote about proper saving habits that I shoot out to them. Classes I teach include the spoken version.

    -Lenny

  10. #10
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Los Angeles, California, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    When the system locks up or crashes and there is unsaved data in a Word document -- TURN THE POWER OFF. The autorecover file is almost always there on startup --- but, I can't repeat it too often, NOT if you use End Task to close the "non-responding" program.

    If using a DMS, I always advise Save, Close, Reopen because Ctrl S is not enough to ensure that a "Save" has occurred -- particularly with Excel documents. I have observed Excel files that were repeatedly "saved" by Ctrl S while the user was working, then Excel crashed, and the edits were GONE. One more time... Save, Close, Reopen.

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is Autorecovery = Autosave in Excel ? (97)

    Hi Van:
    Remember when I said that I had never had that experience (of having a distinction between save & save-close). I seem to have found more support for your position. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> If you look at this thread, I found that page numbers in the RD field would only update correctly after the source document was saved AND closed...saving alone didn't work.

Posting Permissions

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