How do I stop Excel 2007 from creating backup copies?

[KLB]

I've unchecked "Save Autorecover information" under Office Button > Excel
Options > Save, but still Excel is creating a backup copy of *.xlsx files in
the same directory as the original (NOT in the directory I've indicated for
autorecovery files). How can I make it stop?

 

[Dave Peterson]

This isn't autorecovery that's making the backups.

When you do a SaveAs, you can click on:
Tools|General Options|and uncheck the "always create backup" checkbox.

This is a workbook setting. So you'll have to do this to each workbook that
creates backups.

 

[KLB]

Thanks, Dave. That took care of it.

I was led astray by Excel's online help--when you search for "backup" the
most relevant-looking topic it comes up with is about autorecovery. I now see
that discussion of the "Always create backup" option is buried under a topic
on repairing corrupt files.

--klb