How to Set Path of Backp (Excel-XLK).

[Guest]

Ver:Office 2000
While Using Excel I set The backup option ON (by Save AS - Tools - General
Options - Always Create Backup Checked) so that every time I save, a backup
is created, Now my problem is that this backup file in created in the same
folder in which original file is saved. I want know how this backup file can
be created in any different Folder.

 

[David McRitchie]

Hi Vikas,
I think the same directory is used because files are renamed
and the .bck extension is is mostly the same but a permanent copy is
saved. (least that's the way it seems to me)
You can create your own backup, see
Backup your files, always take backups
http://www.mvps.org/dmcritchie/excel/backup.htm#demand-