Automatic backup

[Marc]

My Excel 2002 creates a backup in "My Documents" of each
document I save.
It adds "Backup of..." at the beginning of the document's
name and put the xlk extension.
Where are the settings for this option? It's on at my
workstation and some colleagues want to have it too but
we can't find where to turn it on.
Thanks
Marc

 

[Gord Dibben]

Marc

File>Save As>Tools>General Options. Check "always create a backup".

Each file must be done separately. There is no global feature.

Gord Dibben Excel MVP XL2002