Auto Save in Excel

[camioneur]

Anyone know a way to auto save a workbook in excel, I don't mean to auto - recovery I mean to back up at intervals, say every hour in case I forget or power failure or similar?

[wildwood]

I've looked for that function myself before, but haven't found it. I am pretty sure you need to use a third party utility such as Autosave XL or similar for that.

[Fitzer]

I'm using Excel 2002 at home and a different version at work and they both have an auto save feature. On 2002 it's under 'tools', 'options' and then the 'save' tab. On 2002 it is called autorecover, on the work version it is definately a save. Further investigation finds that earlier versions did not have it switched on by default, see here http://support.microsoft.com/kb/213943

[wildwood]

Fitzer, auto save is not the same as auto recover. Excel (2003) help file clearly states that;

"Note: Do not use AutoRecover as a substitute for regularly saving your work by clicking Save on the Standard toolbar ."

I suspect that your work version has a plugin program installed, as has almost all businesses. The more I think about it, the more I am convinced that Mr Gates' team has made a faux pas when leaving such a relatively simple utility out of Excel.