Change Autosave defaults in XL2k

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RWN - 19 Oct 2005 04:07 GMT

Is it possible (registry?) to change the default settings for AutoSave-specifically the
time between saves and the "Prompt before Saving" values?

Signature

Regards;
Rob
------------------------------------------------------------------------

Reply to this Message

Dave Peterson - 19 Oct 2005 14:50 GMT

tools|autosave
There's a box for how many minutes between saves.

If these settings aren't being saved, then you may want to make sure you have
the latest Service Packs for xl2k. (I think one of those fixed this problem.)

Or...

http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_frm/t
hread/14a2546f258f6040/fc8d4dbcedd29c22?lnk=st&q=group:*excel*+insubject:%22Exce
l+insubject:97%2F2000+insubject:AUTOEXEC%22&rnum=1&hl=en#fc8d4dbcedd29c22

or

http://snipurl.com/ip16

Has some code that may help you.

> Is it possible (registry?) to change the default settings for AutoSave-specifically the
> time between saves and the "Prompt before Saving" values?
[quoted text clipped - 3 lines]
> Rob
> ------------------------------------------------------------------------

Signature

Dave Peterson

Reply to this Message

RWN - 20 Oct 2005 03:06 GMT

Thanks Dave;
I am up to date-I believe-with SP3.
This is one of those "minor annoyance" things.
If I forget to change it (I usually set it to 30 min with no prompting) it seems like it
always "intrudes" at the wrong time and has the nasty habit of changing the sheet I'm
viewing/working on.
Hopefully I'll be moving on to Off'03 shortly (keep up with the system at work) so it will
no longer be an issue.

Thanks again.

Signature

Regards;
Rob
------------------------------------------------------------------------

> tools|autosave
> There's a box for how many minutes between saves.
[quoted text clipped - 3 lines]
>
> Or...

http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_frm/t
hread/14a2546f258f6040/fc8d4dbcedd29c22?lnk=st&q=group:*excel*+insubject:%22Exce
l+insubject:97%2F2000+insubject:AUTOEXEC%22&rnum=1&hl=en#fc8d4dbcedd29c22

> or
>
[quoted text clipped - 9 lines]
> > Rob
> > ------------------------------------------------------------------------

Reply to this Message

Dave Peterson - 20 Oct 2005 03:16 GMT

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.

> Thanks Dave;
> I am up to date-I believe-with SP3.
[quoted text clipped - 39 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message