Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 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:
Figure 1. The Save options of the Excel Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6172) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Setting the AutoRecover Directory.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Excel can check the data and formulas in your worksheet to see if it detects any errors. The rules used for this checking ...
Discover MoreGridlines are very helpful in seeing where cells are located on the screen. You are not limited to black gridlines; ...
Discover MoreWhen you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Here's how to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-02-28 05:10:35
Phil Brannigan
Hi Allen, we work with Excel files containing confidential data supplied to us by clients, and we have to comply with their data security requirements. We have set up a cloud-based service that allows us to open the files in Excel from the cloud store without downloading them. We can set permissions that enforce this practice. The client is happy with this except for one thing. Although the Excel file itself is not stored on the user's local drive, the temporary and auto-recover files are, and the client wants to know how we can ensure these cannot be used to view the confidential data. Is there a safe way to ensure these files are deleted once the Excel work is complete?
2015-07-07 07:37:42
Thomas Roes
I try setting this autorecover folder to a folder in the user home-directory using management software but...... autorevoverfiles are still created in the default folder (in the roaming profile, so this profiles grow's out off proportion).
This bloats the roaming profile.
Because I set this through management software (I can't/won't ask my users to set this all by themselfs) any manual changes will be overwritten.
The folder I specify does exist. What could be wrong.
2014-07-06 09:01:07
Greg
If you have an 'office' setup where the auto-recover file is saved to a Network location you could have a problem if the Network goes down as part of the failure.
2014-07-05 06:58:29
Alien
Interesting tip...but is there some advantage to switching the auto-recover file location? Presumably it will work just the same wherever it's filed.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments