Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set interval for automatic save? (not auto recovery)
|
#2
|
|||
|
|||
Dee,
From a previous post by Dave Peterson: If you're running xl2k or earlier, install the autosave addin via windows|Start button|settings|control panel|Add or remove programs If you're running xl2002+, then if you can find a copy of the autosave addin from an earlier version, it should work ok. But xl2002+ has something called autorecovery. It's not the same as autosave, but will allow you to recover files if excel/windows crashes. As an alternative, you may want to consider using Jan Karel Pieterse's addin called AutoSafe (note spelling). It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) Jan Karel's version will know if there was a crash and prompt you to open the last version it saved. "dee" wrote in message ... |
#3
|
|||
|
|||
If you're running xl2k or below, you can load autosave and use:
tools|autosave There's a box for how many minutes between saves. Actually, this'll work if you're running Autosave.xla in any version of excel. (But autosave.xla doesn't come with xl2002+). dee wrote: -- Dave Peterson |
#4
|
|||
|
|||
Thanks for the info; I appreciate the quick response! I am running a brand new edition of Excel and somethings are just not the way they used to be....thanks again. "Paul B" wrote: Dee, From a previous post by Dave Peterson: If you're running xl2k or earlier, install the autosave addin via windows|Start button|settings|control panel|Add or remove programs If you're running xl2002+, then if you can find a copy of the autosave addin from an earlier version, it should work ok. But xl2002+ has something called autorecovery. It's not the same as autosave, but will allow you to recover files if excel/windows crashes. As an alternative, you may want to consider using Jan Karel Pieterse's addin called AutoSafe (note spelling). It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) Jan Karel's version will know if there was a crash and prompt you to open the last version it saved. "dee" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
cannot edit and save | New Users to Excel | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |