Auto recover - auto back up

[kevs]

Just lost lot of work today. Can someone please let me know how to use these
feature best for future? Appreciate it.

Kevs


OS 10.4.11
Office 2004

 

[JE McGimpsey]

Just lost lot of work today. Can someone please let me know how to use these
feature best for future? Appreciate it.

There is no Auto backup function in XL. You can set each file to create
a backup *when saved* (click the Options Button in the Save As dialog).

If you want all new files to create a backup, check that checkbox when
you save your default workbook (i.e., the file "Workbook", no quotes, no
extensions, in your XL startup folder).

Autorecover settings depend on how frequently you want to save (more
frequent if you're entering a lot of data, less frequent if not - I use
5 minutes). Autorecover can cause XL to pause momentarily while the
autorecover file is saved, so more frequent is not necessarily better.

Autorecover only protects against crashes - when XL starts up, it looks
for an Autorecover file. If one exists, XL presumes there was a crash,
and opens the Autorecover file. Autorecover files are deleted when you
close XL normally.

The best usage is, as in Word, to get used to typing CMD-s frequently.

 

[CyberTaz]

Yes - ignore them, leaving them at their default settings & pray that you
never have a situation occur that causes them to exhibit what they are
designed to do. In the meanwhile learn to use Command+S periodically while
you work.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs]

Yes - ignore them, leaving them at their default settings & pray that you
never have a situation occur that causes them to exhibit what they are
designed to do. In the meanwhile learn to use Command+S periodically while
you work.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Thanks guys, just exploring everything after this recent disaster.
Kevs



OS 10.4.11
Office 2004

 

[bbruti]

So, if XL makes an auto recover file, where does it put this file? Assuming a mistake (closing without saving the wrong workbook when you have several open at once) and a "normal" (non crash) close, does the auto recover file stay somewhere or is it trashed if the associated workbook is closed?

thanks

 

[hannahmadeleine]

is there any way to recover a file that i didn't save (and no, i don't use time machine...)? i think i already know the answer, but just checking.

 

[JE McGimpsey]

is there any way to recover a file that i didn't save (and no, i don't use
time machine...)? i think i already know the answer, but just checking.

If you quit XL normally, then you're out of luck. AutoRecover will only
recover files that were in use if XL crashes.