Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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.
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, and 2013. You can find a version of this tip for the older menu interface of Excel here: Setting the AutoRecover Directory.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When keeping track of dates, internally, Excel uses special date serial numbers that are based upon a specific day in the ...
Discover MoreExcel allows you to display your workbooks using a couple of different views. If you want to disable one of the views, it ...
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 © 2018 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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