Save Tab

Save workbooks

Application.DefaultSaveFormat = xlWorkbookNormal 
Application.AutoRecover.Enabled = True 
Application.AutoRecover.Time = 20 
Application.AutoRecover.Path = "C:\Temp\" 
ActiveWorkbook.EnableAutoRecover = False 

Autorecover exceptions for

Offline editing options for document management server files

Preserve visual appearance of the workbook

Cache Settings