How can I stop Excel's saves "Backup of ######.xlk"

[Robert]

Excel is appears to be backing up files on it's own. Excel appends the file
name with "Backup of .........xlk" and saves file as an .xlk not a xls file.
How can I turn this off?

 

[Dave Peterson]

This is a workbook setting (not an application setting).

Show the File|SaveAs dialog.
Tools|General Options|Uncheck the "Always create backup" box.

 

[Gord Dibben]

File>Save As>Tools>General Options.

Uncheck "always create backup"

Now save the workbook.

This is a workbook setting so has to be done for every workbook.

*.XLK is Excel's version of *.BAK


Gord Dibben MS Excel MVP

 

[David Biddulph]

You can turn it off, as others have explained, but if you do so, please
don't come back to us and ask us how you can retrieve the data when you've
accidentally saved something and overwritten your data without a backup.