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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

andy195Commented:
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
gtglonerCommented:
0
Rory ArchibaldCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

james-barrCommented:
Hi... What version of Excel are you using out of interest?
0
Rory ArchibaldCommented:
dm25 has Excel 2002 according to the follow-up question posted later, FWIW.
0
james-barrCommented:
FWIW...?
0
Rory ArchibaldCommented:
For what it's worth. (don't really know why I added that now that I read it again!)
0
andy195Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.