Creating Automatic Backup Files on another drive

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

helvetik - 23 Feb 2007 19:25 GMT

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

Reply to this Message

E-Coder - 23 Feb 2007 20:02 GMT

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

> 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

Reply to this Message

helvetik - 23 Feb 2007 20:15 GMT

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

> If you are referring to AutoRecover feature, you can select the destination
> under Tools~Options~Save
>
> > 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

Reply to this Message

Gord Dibben - 23 Feb 2007 21:04 GMT

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

>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

Reply to this Message