I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP

I have excel 2000 and it already has autosave. I have it added from my addin
list, but it doesn't appear to be saving. I developed an excel program for
our shop floor and instead of relying on them to remember to save, I added in
the autosave on all their computers. I put the file on the network drive so I
(or anyone else) can review their data. I set the autosave for every 10
minutes (all open workbooks, NO prompt before saving). This way I was hoping
for 'live' data every 10 minutes.. however, it isn't autosaving. If it's 8am,
the last save may have been 2 hours ago instead of 10 minutes ago - and that
may have been a hard save for all I know... so I don't understand why it
won't save every 10 minutes. I have tried removing the autosave addin and
then putting it back and that doesn't do anything.

Thanks for any help/ideas anyone has!!

"Gord Dibben" wrote:

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP

jangaroo

Office 2000 Autosave had a bug which was corrected in a Service Release.

http://support.microsoft.com/default...b;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000


Gord

On Wed, 6 Sep 2006 06:17:02 -0700, jangarooo
wrote:

I have excel 2000 and it already has autosave. I have it added from my addin
list, but it doesn't appear to be saving. I developed an excel program for
our shop floor and instead of relying on them to remember to save, I added in
the autosave on all their computers. I put the file on the network drive so I
(or anyone else) can review their data. I set the autosave for every 10
minutes (all open workbooks, NO prompt before saving). This way I was hoping
for 'live' data every 10 minutes.. however, it isn't autosaving. If it's 8am,
the last save may have been 2 hours ago instead of 10 minutes ago - and that
may have been a hard save for all I know... so I don't understand why it
won't save every 10 minutes. I have tried removing the autosave addin and
then putting it back and that doesn't do anything.

Thanks for any help/ideas anyone has!!

"Gord Dibben" wrote:

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP

Hi

I have a similar problem with my version of Excel 2000 (9.0.6926 SP-3)

I'm patched to SP3 (which I would anticpate covers all the previous SP
releases) and my workbooks are set to save every 10 minutes without
prompts, but these settings are never retained.
I haven't found anything that would assist me with resolving this other
than the MS link;
http://support.microsoft.com/default...b;en-us;231117

Does anyone have any other suggestions I may try??

Thanks in advance

Phil


Gord Dibben wrote:
jangaroo

Office 2000 Autosave had a bug which was corrected in a Service Release.

http://support.microsoft.com/default...b;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000


Gord

On Wed, 6 Sep 2006 06:17:02 -0700, jangarooo
wrote:

I have excel 2000 and it already has autosave. I have it added from my addin
list, but it doesn't appear to be saving. I developed an excel program for
our shop floor and instead of relying on them to remember to save, I added in
the autosave on all their computers. I put the file on the network drive so I
(or anyone else) can review their data. I set the autosave for every 10
minutes (all open workbooks, NO prompt before saving). This way I was hoping
for 'live' data every 10 minutes.. however, it isn't autosaving. If it's 8am,
the last save may have been 2 hours ago instead of 10 minutes ago - and that
may have been a hard save for all I know... so I don't understand why it
won't save every 10 minutes. I have tried removing the autosave addin and
then putting it back and that doesn't do anything.

Thanks for any help/ideas anyone has!!

"Gord Dibben" wrote:

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP

I don't know why it doesn't stick for you, but you could do something like...

Create a workbook with this code in a general module:

Option Explicit
Sub auto_open()

On Error Resume Next
Workbooks("autosave.xla").Excel4IntlMacroSheets("L oc Table") _
.Range("ud01n.Frequency1").Value = 10
If Err.Number < 0 Then
MsgBox "Timer not changed!"
Err.Clear
End If
On Error GoTo 0

'ThisWorkbook.Close SaveChanges:=False

End Sub

Save it into your XLStart folder (so it loads, runs, and closes each time you
start excel).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Another option would be to dump autosave and use Jan Karel Pieterse's 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.)


wrote:

Hi

I have a similar problem with my version of Excel 2000 (9.0.6926 SP-3)

I'm patched to SP3 (which I would anticpate covers all the previous SP
releases) and my workbooks are set to save every 10 minutes without
prompts, but these settings are never retained.
I haven't found anything that would assist me with resolving this other
than the MS link;
http://support.microsoft.com/default...b;en-us;231117

Does anyone have any other suggestions I may try??

Thanks in advance

Phil

Gord Dibben wrote:
jangaroo

Office 2000 Autosave had a bug which was corrected in a Service Release.

http://support.microsoft.com/default...b;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000


Gord

On Wed, 6 Sep 2006 06:17:02 -0700, jangarooo
wrote:

I have excel 2000 and it already has autosave. I have it added from my addin
list, but it doesn't appear to be saving. I developed an excel program for
our shop floor and instead of relying on them to remember to save, I added in
the autosave on all their computers. I put the file on the network drive so I
(or anyone else) can review their data. I set the autosave for every 10
minutes (all open workbooks, NO prompt before saving). This way I was hoping
for 'live' data every 10 minutes.. however, it isn't autosaving. If it's 8am,
the last save may have been 2 hours ago instead of 10 minutes ago - and that
may have been a hard save for all I know... so I don't understand why it
won't save every 10 minutes. I have tried removing the autosave addin and
then putting it back and that doesn't do anything.

Thanks for any help/ideas anyone has!!

"Gord Dibben" wrote:

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP


--

Dave Peterson

Hi dave - sincere thanks for the code and suggestions - I'll look at
giving them a go when i'm back in tomorow.
Cheers
Phil


Dave Peterson wrote:
I don't know why it doesn't stick for you, but you could do something like...

Create a workbook with this code in a general module:

Option Explicit
Sub auto_open()

On Error Resume Next
Workbooks("autosave.xla").Excel4IntlMacroSheets("L oc Table") _
.Range("ud01n.Frequency1").Value = 10
If Err.Number < 0 Then
MsgBox "Timer not changed!"
Err.Clear
End If
On Error GoTo 0

'ThisWorkbook.Close SaveChanges:=False

End Sub

Save it into your XLStart folder (so it loads, runs, and closes each time you
start excel).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Another option would be to dump autosave and use Jan Karel Pieterse's 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.)


wrote:

Hi

I have a similar problem with my version of Excel 2000 (9.0.6926 SP-3)

I'm patched to SP3 (which I would anticpate covers all the previous SP
releases) and my workbooks are set to save every 10 minutes without
prompts, but these settings are never retained.
I haven't found anything that would assist me with resolving this other
than the MS link;
http://support.microsoft.com/default...b;en-us;231117

Does anyone have any other suggestions I may try??

Thanks in advance

Phil

Gord Dibben wrote:
jangaroo

Office 2000 Autosave had a bug which was corrected in a Service Release.

http://support.microsoft.com/default...b;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000


Gord

On Wed, 6 Sep 2006 06:17:02 -0700, jangarooo
wrote:

I have excel 2000 and it already has autosave. I have it added from my addin
list, but it doesn't appear to be saving. I developed an excel program for
our shop floor and instead of relying on them to remember to save, I added in
the autosave on all their computers. I put the file on the network drive so I
(or anyone else) can review their data. I set the autosave for every 10
minutes (all open workbooks, NO prompt before saving). This way I was hoping
for 'live' data every 10 minutes.. however, it isn't autosaving. If it's 8am,
the last save may have been 2 hours ago instead of 10 minutes ago - and that
may have been a hard save for all I know... so I don't understand why it
won't save every 10 minutes. I have tried removing the autosave addin and
then putting it back and that doesn't do anything.

Thanks for any help/ideas anyone has!!

"Gord Dibben" wrote:

jangaroo

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 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 Tue, 5 Sep 2006 10:13:02 -0700, jangarooo
wrote:

I have the autosave setup for 10 minutes, all open workbooks (not all active
workbooks), but it doesn't save every 10 mintues. If I go look at the file in
say 'my documents' the last save may have been 2 hours ago. Why?

Gord Dibben MS Excel MVP


--

Dave Peterson