Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / May 2008



Tip: Looking for answers? Try searching our database.

Auto recover - auto back up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kevs - 31 Dec 2007 19:10 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.