Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Carol notes that Excel 2007 creates automatic backup files of every file she creates that is later edited. In earlier versions of Excel, there was an Automatically Create Backup option (which she never used), but she can't find the corresponding setting in Excel 2007 to turn off this feature.
Creating backups is done by default in Excel 2007, and it is done on a workbook by workbook basis. In order to turn it off for a specific workbook you need to follow these steps:
Following these steps affects only the current workbook; other workbooks remain unchanged in their behavior. If you want to change Excel 2007 so that backups aren't saved, by default, then you should try creating a new default workbook for the program. (How this is done is discussed in other ExcelTips. In short, you create a template named Book.xltx and store it in your xlstart folder.)
One thing that should be noted when working with Excel 2007—it is easy to confuse automatic backups with AutoRecover. These are not the same. AutoRecover is a way to save temporary information, between "hard saves," so that you can recover a workbook on which you are working if the power goes out. Automatic backups are copies of your workbook saved whenever you save the workbook itself. Since AutoRecover and automatic backups are two different features of Excel, changing the settings of one feature doesn't affect the other at all.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3884) applies to Microsoft Excel versions: 2007
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.