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

  • Thread starter Thread starter Robert
  • Start date Start date
R

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?
 
This is a workbook setting (not an application setting).

Show the File|SaveAs dialog.
Tools|General Options|Uncheck the "Always create backup" box.
 
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
 
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.
 
Back
Top