Creating Automatic Backup Files on another drive

[helvetik]

Excel / Word create automatic backup files (.xlk / .wbk) when the option is
selected. Can this backup be created not on the same drive as the main file
(e.g. C) but on another drive (e.g. Y) ? That way there is more data security

 

[E-Coder]

If you are referring to AutoRecover feature, you can select the destination
under Tools~Options~Save

 

[helvetik]

No, in Excel this is File~Save as~Tools~ General OPtions~select Always create
Backup

 

[Gord Dibben]

I know of no way to change the designated folder for those backup files.

Even if you could, I don't know how that would improve data security.

If you are interested in security I would suggest a regular backup of data files
to media that would be stored elsewhere than on your computer.

CD's, USB Flash drive or external hard drive come to mind.


Gord Dibben MS Excel MVP