Welcome toExcel2007.Tips.Net
Helpful Links
Excel2007 Tips
Family Tips
Gardening Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Specifying Where Excel Saves AutoRecover Files
Summary: Excel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ended abnormally. You can specify where you want these AutoRecover files stored by using the information in this tip.Excel has a feature that causes automatic saving of temporary files, in case there is a problem with your computer. (You know the routine—power goes out, whatever.) This feature is called AutoRecover. When an AutoRecover file is saved to disk, it is placed in a directory that you specify. To change the directory used for saving AutoRecover files, follow these steps:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click the Save button at the left side of the dialog box. (Click here to see a related figure.)
- In the AutoRecover File Location box, enter the full path of the folder in which you want the files saved.
- Click on OK.
Related Tips:
Create Rock-Solid Lists! Bulleted and numbered lists can help make your writing clearer and easier to follow. If not done properly, however, they can be a nightmare to work with. Discover the ins and outs of Word's lists with this great reference available in two versions. Check out Word Bullets and Numbering today!