Setting the AutoRecover Directory

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:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Click on the Save tab. (Click here to see a related figure.)
3. In the AutoRecover Save Location box, enter the full path of the folder in which you want the files saved.
4. Click on OK.

If you are using Excel 2007 then the steps are slightly different:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. Click the Save button at the left side of the dialog box. (Click here to see a related figure.)
3. In the AutoRecover File Location box, enter the full path of the folder in which you want the files saved.
4. Click on OK.