Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The last version of AUTOSAVE.XLA was Excel 2000 and it was buggy but fixed
with Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a). I would suggest you got the buggy version sent to you. Don't think that obtaining and running SR1 for Excel 2000 will solve that problem since you are running 2003. The Excel 97 version of Autosave.xla works fine on Excel 2003. Get a copy from here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm Gord On Fri, 18 Aug 2006 12:32:01 -0700, SoNearRedmondICouldThrowWaterBombsAtThem <SoNearRedmondICouldThrowWaterBombsAtThem@discussi ons.microsoft.com wrote: Thanks for the interest and help. I will look at AutoSafe when I have the chance. I am using Excel 2003 as it came as a part of Office Professional Ed. 2003. I in fact used one of my two "free" service calls to MS to get AutoSave sent to me as an add in. Auto recovery was not doing the job and I was loosing a lot of work which was painful to recreate mentally and emotionally. What happened is that my new Toshiba notebook would sometimes not come back from hybernation - a restart was required - and when Excel was restarted there were no recovered files. Perhaps this is due to some mistake I made in restarting Excel out of unfamiliarity with the auto recovery deal but the location of the files, if they existed, was not evident to me. This drove me back to autosave which is fine except for the problem that setting are not retained. I will call MS again and say the case was not resolved and thus see if I can get the fixed version of autosave. The version they sent me definately does not retain revised settings. "Gord Dibben" wrote: Would help if you mentioned which version of Excel you have. Different fixes for different versions. Since you're talking about Autosave, I will assume Excel 2000 because newer versions don't have Autosave only Autorecovery which is not the same thing. Office 2000 Autosave had a bug which was corrected in a Service Release. Try the advice below from Dave Peterson............ Start Dave Peterson text.......................... Maybe... http://support.microsoft.com/default...b;en-us;231117 XL2000: AutoSave Settings Are Not Retained Between Sessions of Excel 2000 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.) End Dave Peterson text........................................... Gord Dibben Excel MVP On Thu, 17 Aug 2006 15:40:02 -0700, SoNearRedmondICouldThrowWaterBombsAtThem <SoNearRedmondICouldThrowWaterBombsAtThem@discussi ons.microsoft.com wrote: Every time I start Excel anew the autosave reverts to the 10 minute interval, prompt before saving, default setting. I want, in general, 15 minutes and no prompt, just do it. It is annoying to always have to renew this setting. Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Default Settings for Table Options | Excel Discussion (Misc queries) | |||
How do I restore my original excel settings to default? | Excel Discussion (Misc queries) | |||
default settings on autosave in Office 2000 | Setting up and Configuration of Excel | |||
[Excel] How do I change the default import external data settings. | Excel Discussion (Misc queries) | |||
How do I change the default settings in charts? | Charts and Charting in Excel |