Auto save in excel 2000 keeps reverting to 10 minutes

[JT Spitz]

I keep trying to change the time between auto-saves to 30 minutes, but every
time I reopen excel 2000 it is back to 10 minutes. How do I get this change
to be permanent?

Thanks.

 

[Dave Peterson]

Create a workbook with this code in a general module:

Option Explicit
Sub auto_open()

On Error Resume Next
Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc 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.)

 

[JT Spitz]

Thanks for the information. Over the next few days I will try your macro
solution before I download anything new. I appreciate your quick response.

BTW, I may not be able to get back to this discussion thread as the search
for anything with my name (easier than any other type of search since I don't
log that many questions) only brings up items from 2008 and prior. I would
have to go through the list day by day/case by case to find this thread
again. I was lucky to find this as cases are, as you know, continually being
logged. The notify of any replies function also did not work here, there was
nothing in my email about your response. This situation happened a few
months ago and someone suggested I try logging cases a different way (can't
remember their suggestion), but I still see people are using this forum so
I'm a little confused. Anyway that is a separate issue that is low on the
priority list.

Getting this auto-save thing to work is higher on the list.

Thanks again.

JT

 

[Dave Peterson]

I use google to search groups.

http://groups.google.com/advanced_search?&as_ugroup=microsoft.public.excel.*

Give it enough information (you as the author, maybe a keyword or date) and
you'll find it.

 

[Gord Dibben]

See this KB article about autosave in Excel 2000 not retaining settings.

http://support.microsoft.com/kb/231117

Might be you're not fully patched.


Gord Dibben MS Excel MVP