Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto save excel file every 10 minutes to its original file name
How can I automatically save Excel Workbooks every few minutes to the file
name as I could with Office 2000? |
#2
|
|||
|
|||
tools/options/save tab....set autorecover and it's location.....this is all i
know on this "MEG" wrote: How can I automatically save Excel Workbooks every few minutes to the file name as I could with Office 2000? |
#3
|
|||
|
|||
xl2k (and below) come with an autosave.xla addin.
Look under Tools|Addins for autosave. If you don't see it there, you'll have to install it from the distribution CD. After it's installed, you can turn it on via tools|Addins. There's an option under tools (if I recall correctly) that lets you change the interval (after it's installed and turned on). 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. MEG wrote: How can I automatically save Excel Workbooks every few minutes to the file name as I could with Office 2000? -- Dave Peterson |
#4
|
|||
|
|||
I think you'll find that autorecovery was added in xl2002.
paige wrote: tools/options/save tab....set autorecover and it's location.....this is all i know on this "MEG" wrote: How can I automatically save Excel Workbooks every few minutes to the file name as I could with Office 2000? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
save excel file formatted as f12.3 | Excel Discussion (Misc queries) | |||
Excel prompts me to save a copy or overwrite file. | Excel Worksheet Functions | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
How to auto save Excel spreadsheets | Excel Discussion (Misc queries) |