See all How-To Articles

How to Set Up AutoSave Location and Time in Excel

In this article, you will learn how to set up autosave options for save frequency and location in Excel.

 

autorecover location time

 

Excel’s AutoSave option allows us to change a file on OneDrive or SharePoint after every change, in real time.

For users not connected to OneDrive or SharePoint, Excel has AutoRecover. AutoRecover saves a version of the file we are working on every few minutes so the file can be restored if Excel crashes. The frequency of versions saved and file location are user-defined. We’ll show how to set up those options.

Set Up Location and Time for AutoRecover

To turn on the AutoRecover option and set up the location and time range, we follow these steps:

In the Ribbon, go to File > Options.

 

excel save options 2

 

In Excel Options, (1) choose Save, (2) check Save AutoRecover information every [number] minutes. Specify how often you want the file to be saved.

For the AutoRecover file location, (3) enter the path to the folder where files will be saved. (The default location is: C:\Users\*user_name*\App Data\Roaming\Microsoft\Excel)

 

autorecover options excel

 

As a result, a new recovery file will be saved every 5 minutes in the specified folder.

Turn Off AutoRecover

If we want to turn off AutoRecover, we need to uncheck Save AutoRecover information every [number] minutes in the Excel Options window.

 

autorecover options turn off

 

AutoRecover files are deleted from the selected folder when you turn off this option. Files are also deleted when you save and close them or quit Excel.