"Back of...." files help

[ddub25]

In the main folder where I save my Excel files I have backup files which are automatically generated. These are labelled "Backup of..." followed by the name of the orginal file.

Can anyone tell me why these are being generated? Is it an Excel setting or possibly a Microsoft Office setting (I can't see anything in the Excel Options settings that should be creating Backups)?

I don't mind having backups but they would be more useful if I could have them backed up to a different location on a different drive maybe. Any ideas.

Dan

 

[Smitty]

Unfortunately, AutoRecover isn't a backup system per se, because the files get deleted. They backup is only saved if Excel crashes or otherwise closes unexpectedly. See; http://support.microsoft.com/kb/289273

Check out Jan Karel Pieterse's AutoSafe Add-In.

 

[ddub25]

Ok, thanks Smitty

Dan