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.
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.
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@discussions.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
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@discussions.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
>
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@discussions.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@discussions.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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks