I have a group of guys, inputting data on an excel file and these are not all computer friendly. I am afraid that if I do not include an autosave, information can be lost if someone does not save his work.
2006-09-05 07:36:29 · 4 answers · asked by jc 2 in Computers & Internet ➔ Other - Computers
If those answers not good enough for you we can do a macro for that.
Just add these lines to the "ThisWorkbook" object
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
ThisWorkbook.Save
End Sub
If you are lost here, contact me
Read my profile, I am XLMan
2006-09-05 19:34:29 · answer #1 · answered by Anonymous · 0⤊ 0⤋
from the menu tools, options, save there is a check box that must be marked and it will auto save every ten minutes by default. more or less if you change the time.
2006-09-05 14:41:18 · answer #2 · answered by chrome_rider 4 · 0⤊ 0⤋
in the menu bar, go to tools, options and click on the 'save' tab and then select, save AutoRecover info every and you can click on the tab to select the time interval that you wish to use... e.g. 5, 10, 20 minutes.
2006-09-05 14:46:18 · answer #3 · answered by asian chick 3 · 0⤊ 0⤋
Tools->Options->Save
Check the Save... box and enter the number of minutes and then enter the save location.
2006-09-05 14:39:29 · answer #4 · answered by live2ride 5 · 1⤊ 0⤋