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 - 31 Dec 2007 19:54 GMT
> 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 - 31 Dec 2007 23:21 GMT
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
On 12/31/07 2:10 PM, in article C39E7EB3.2FB3C%kevs@hotmail.com, "kevs"
> Just lost lot of work today. Can someone please let me know how to use these
> feature best for future? Appreciate it.
[quoted text clipped - 3 lines]
> OS 10.4.11
> Office 2004
kevs - 01 Jan 2008 20:12 GMT
On 12/31/07 3:21 PM, in article C39EE39D.2F8F7%onlygeneraltaz1@com.cast.net,
> 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
[quoted text clipped - 14 lines]
>> OS 10.4.11
>> Office 2004
Thanks guys, just exploring everything after this recent disaster.
Kevs
OS 10.4.11
Office 2004
bbruti@officeformac.com - 01 Apr 2008 01:33 GMT
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@officeformac.com - 07 May 2008 03:48 GMT
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 - 07 May 2008 12:27 GMT
> 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.