Excel Auto Backup?

[TechErrrNo]

Hey. Does anyone know how to set Excel 2003 up so it automatically back up saved files to a different location? Thanks!

[smurfy]

There is no auto-save option, only auto-recover.
To change the default AutoRecovery option (if required):

1. From the Tools menu, select Options, and then select the Save tab (this is a new tab in Excel 2002 and Excel 2003).
2. Change the Save AutoRecover info every: ... minutes, set the Auto Recover save location, and then click OK.

However, it is possible to write your own Auto-Save macro that will trap a save event and automatically save a copy of the file.
Funnily enough, I have an open request to do exactly that. My task is for a specific workbook, not every workbook but it should be possible to have the code in the PERSONAL macro workbook to be triggered on all save events.