Excel can stop responding or crash, causing you to lose unsaved changes. The AutoRecover feature automatically saves a backup copy of your open workbooks at a set interval. This article explains how to adjust the AutoRecover save frequency to better protect your data.
Key Takeaways: Adjusting AutoRecover Settings
- File > Options > Save: This menu contains the primary controls for the AutoRecover feature and its save interval.
- Save AutoRecover information every X minutes: This setting determines how often Excel creates a temporary backup file of your workbook.
- AutoRecover file location: You can view and change the folder where Excel stores its temporary backup files for recovery.
Understanding Excel’s AutoRecover Feature
AutoRecover is a background process in Excel that periodically saves a copy of your workbook. This is separate from manually saving your file with Ctrl+S. If Excel closes unexpectedly, the next time you start the program, it will show a Document Recovery pane with these AutoRecovered versions. You can then choose to open the recovered file and save your work.
The default AutoRecover interval is 10 minutes. For work on critical or complex files, this may be too long. A shorter interval, like 5 minutes, reduces potential data loss. However, setting it too low, such as 1 minute, can cause performance issues on slower computers as Excel pauses to save frequently.
AutoRecover vs. AutoSave
AutoRecover is not the same as AutoSave for files stored on OneDrive or SharePoint. AutoSave continuously saves changes to the cloud file as you work. AutoRecover creates local backup files on your computer’s hard drive. You need AutoRecover even if you use AutoSave, as it protects against application crashes before a cloud sync completes.
Steps to Change the AutoRecover Save Interval
Follow these steps to adjust how often Excel saves AutoRecover information. The change applies to all workbooks you open in Excel on this computer.
- Open Excel Options
Launch Excel. Click the File tab on the ribbon to go to the Backstage view. Select Options at the bottom of the left-hand menu. - Navigate to Save Settings
In the Excel Options dialog box, click the Save category in the left pane. This section contains all settings related to saving files and AutoRecover. - Adjust the AutoRecover Interval
Locate the section titled “Save workbooks.” Check the box for “Save AutoRecover information every X minutes.” In the minutes box, type a new number between 1 and 120. A value between 5 and 10 minutes is recommended for most users. - Confirm the File Location
Just below the interval setting, you will see the “AutoRecover file location.” Make a note of this folder path. You can click Browse to change it if needed. Click OK to save your new settings and close the dialog box.
Common Mistakes and Limitations
AutoRecover Is Not a Substitute for Saving
AutoRecover files are temporary. They are typically deleted when you close Excel normally. You must still regularly save your workbook manually. Do not rely on AutoRecover as your primary save method.
Files Must Be Open for a Full Interval
If you set the interval to 5 minutes, Excel will not create an AutoRecover file until 5 minutes after you open the workbook. If a crash happens at the 4-minute mark, you may lose all changes since the file was opened. Save your work immediately after making significant changes.
AutoRecover May Be Disabled
If the “Save AutoRecover information” checkbox is unchecked, the feature is off. No backup files will be created regardless of the interval setting. Always verify the box is checked after changing the interval.
AutoRecover Settings: Default vs. Custom
| Item | Default Setting (10 min) | Custom Shorter Interval (5 min) |
|---|---|---|
| Data loss risk | Potential loss of up to 10 minutes of work | Potential loss of up to 5 minutes of work |
| System resource use | Minimal performance impact | Slightly higher disk activity every 5 minutes |
| Best for | General, light editing tasks | Working on critical data or complex calculations |
| Recovery file location | C:\Users\[Username]\AppData\Roaming\Microsoft\Excel\ | Same default location, unless manually changed |
You can now control how often Excel creates backup copies of your work. Set the AutoRecover interval in File > Options > Save to match your project’s importance. For maximum safety, combine this with the manual save habit using Ctrl+S. An advanced tip is to periodically check the AutoRecover file location to ensure backup files are being created, especially after a major Windows update.