Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
Hello To All,
I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
It should be right under the tools menu- auto-save. IF not you have to go
into Add-ins and add it in. "Ron" wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
If you still have autosave.xla from a previous version of excel, it'll work with
xl2002+. (Not sure about xl2007, though--I haven't tried it.) Jan Karel Pieterse wrote an addin (works in any version) 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.) Ron wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
Thank you so much for the quick response. I have opened the "tools" menu and
though I could not find "autosave" I did find the "Add-Ins." As I selection it to activate, it gave me a number of analysis tool packs, but none that stated specifically "autosave." Analysis ToolPak Analysis ToolPak - VBA Conditional Sum Wizard Euro Currency Tools Internet Assistant VBA Lookup Wizard Solver Add-in "Ron" wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
Autosave was removed with xl2002.
You'll have to find an old copy. Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm Ron wrote: Thank you so much for the quick response. I have opened the "tools" menu and though I could not find "autosave" I did find the "Add-Ins." As I selection it to activate, it gave me a number of analysis tool packs, but none that stated specifically "autosave." Analysis ToolPak Analysis ToolPak - VBA Conditional Sum Wizard Euro Currency Tools Internet Assistant VBA Lookup Wizard Solver Add-in "Ron" wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
go to TOOLS/OPTIONS/SAVE and click the Autorecover box.
"Ron" wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosave for Excel
Ron
If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as there was in earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. 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) Gord Dibben MS Excel MVP On Wed, 2 May 2007 14:09:02 -0700, rhoneyman wrote: go to TOOLS/OPTIONS/SAVE and click the Autorecover box. "Ron" wrote: Hello To All, I have been trying to figure out how to "autosave" files in Excel. It is very possible that I am looking in the wrong location(tools/options), but all I can seem to find is the auto recover. I am wanting to perform a backup of a workbook/file at increment saving times and have found nothing progressive except the level of personal dismay. Your help is greatly appreciated! Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set an autosave in Excel 2007 | Setting up and Configuration of Excel | |||
autosave macro excel | Excel Discussion (Misc queries) | |||
Can I use autosave in excel 2003 instead of autorecover? | Excel Discussion (Misc queries) | |||
Excel wont autosave; how can i fix this? | Setting up and Configuration of Excel | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions |