How can I set Excel to automatically save files.

How do I make Excel automatically save files after a specified number of minutes. If I go to Tools - Options- Save- and set the "Save Autorecover Info"...this doesn't work.
dm25Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
The AutoSave add-in was, AFAIK, discontinued after XL2000 (probably because it was rubbish). The AutoRecover feature is there so that if Excel crashes, you can recover your work. It does not automatically save the workbook you are working on in its original location - probably because that is what most people disliked about the original AutoSave add-in. May I ask why you want this feature? Excel prompts you to save any changed workbooks before you close them anyway.
Regards,
Rory
0
 
andy195Connect With a Mentor Commented:
Your going about it the right way.  You may have to remove and re-install the autosave add-in if it is not working.

More info on the microsoft site here:

http://support.microsoft.com/kb/213943
0
 
gtglonerConnect With a Mentor Commented:
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
james-barrCommented:
Hi... What version of Excel are you using out of interest?
0
 
Rory ArchibaldConnect With a Mentor Commented:
dm25 has Excel 2002 according to the follow-up question posted later, FWIW.
0
 
james-barrCommented:
FWIW...?
0
 
Rory ArchibaldConnect With a Mentor Commented:
For what it's worth. (don't really know why I added that now that I read it again!)
0
 
andy195Connect With a Mentor Commented:
Within the Microsoft KB 213943 article did you have a read of this link http://support.microsoft.com/kb/289273/ 

Be advised the default autorecover save location is drive:\Documents and Settings\user_name\Application Data\Microsoft\Excel

Also be advised the following:
When an AutoRecover event is triggered
When an Excel file is open and AutoRecover is turned on, AutoRecover does not save the file until the first change is made to the file, the AutoRecover save time interval passes, and Excel has been idle for some time (the default is 30 seconds). After AutoRecover saves the file, the file is only saved at subsequent save intervals if further changes are made.

Hope that helps!
0
 
james-barrCommented:
I think dm25 must be on his Hols or something...  ;p

rorya is correct. If you are using Excel 2002 the feature does not exist in that version.
0
 
dm25Author Commented:
Not sure which solution is the correct one (I didn't have to resolve this problem), so I decided to split the points. Thank you all.
0
All Courses

From novice to tech pro — start learning today.