Options¦Save

Home Search Site Map

Up
Options¦Calculation
Options¦Chart
Options¦Color
Options¦Custom Lists
Options¦Edit
Options¦Error Checking
Options¦General
Options¦International
Options¦Save
Options¦Security
Options¦Spelling
Options¦Transitions
Options¦View

New! Excel User Group Now Open @ www.excelusergroup.org,

UK EXCEL USER CONFERENCE - LONDON, UK. APRIL 1st/2nd 2009 - TOTALLY FREE - DETAILS CAN BE CHECKED OUT HERE! Check It Out!


Menu command Type What happens next?
Save Tab

An added feature in Excel XP and up, it is much improved from the add-in of previous versions. Un-checking the 'Save AutoRecover info every:' would switch it off entirely, once checked, you can enter a number of minutes in the spinner control from 1 to 120, (Default is 10). The 'AutoRecover save location:' is the folder that autosaved files should be saved to. Enter the full path in the box.

Excel saves at the set interval a temp file in the folder specified, there is only ever one version in this folder and this is cleared each time the file is successfully saved or Excel is closed normally. If Excel crashes, re-starting will bring up the 'document recovery' task pane allowing you to recover the file at the point it was last auto saved.d.

You also have the ability to switch off document recovery for the active workbook only, which is handy if saves in the active workbook are long-winded, as this will happen each few minutes otherwise.

VBA Sub AutosaveSettings()
With Application.AutoRecover
.Enabled = True
.Time = 20
.Path = "C:\ExcelRecoverFolder"
End With
'*Disables* for the activeworkbook
ActiveWorkbook.EnableAutoRecover = False
End Sub

Top

Copyright Nick Hodge 2008. All Rights Reserved.