Excel 2000 (office 2000)

I believe the is an add-on tool that will provide that feature, I think it requires sr1.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;231117

What SP are you running?

Please take a look at this:

http://www.exceltip.com/st/Auto-Recovering/_Auto-Saving_a_Workbook/677.html

jppinto

Not that i am aware of, but it is easily implemented using a little macro such as :
note : place this code in a module, update the filename & location !

Public keep_saving As Boolean

Public Sub auto_save()

    If keep_saving Then
        Application.OnTime Now + TimeValue("00:00:05"), "auto_save"
        ThisWorkbook.SaveAs "c:\temp\test  " & Replace(Now, ":", "-") & ".xls"
    End If

End Sub

Select allOpen in new window

and place this code in thisworkbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    keep_saving = False
End Sub

Private Sub Workbook_Open()
    keep_saving = True
    Application.OnTime Now + TimeValue("00:00:05"), "auto_save"
End Sub

Select allOpen in new window

above macro saves the worksheet each 5 seconds, so also update the timevalue to :

"00:05:00"

thanks