banner



How To Turn Autosave On In Excel

In this article, you volition learn how to turn on or off AutoSave and AutoRecover in Excel.

autosave one drive

Turn On AutoSave

The AutoSave option in Excel enables the states to salvage an Excel file to OneDrive or SharePoint. This feature was introduced with the Microsoft 365 version, and nosotros demand to have OneDrive set upwards and connected properly to use it. When the AutoSave option is enabled, your file is saved to 1 Drive or SharePoint and all changes are saved in real time equally you blazon. This means that we don't demand to save files manually at all. Also, we're able to easily track the file'southward version history and changes.

To turn on AutoSave, follow these steps:

1. In the Ribbon, get to File > Options.

excel save options 2

two. In the Excel Options window, (1) go to Salve, and (2) check AutoSave OneDrive and SharePoint Online files by default on Excel.

turn on autosave

3. In a higher place the Ribbon, (i) toggle On the AutoSave button, and (two) choose the OneDrive location.

autosave one drive

Now our file is saved to OneDrive and all changes will be saved in existent fourth dimension. If we want to run into version history, in a higher place the Ribbon, click on the file proper noun then Version History.

autosave version history

On the right side, we can see all changes with date, time, and user who made changes.

autosave version history 2

Turn Off AutoSave

If you want to plow off the AutoSave option, above the Ribbon, toggle Off the AutoSave button.

turn off autosave

Plow On AutoRecover

The AutoRecover option saves a version of a file at user-divers fourth dimension interval. While the AutoSave option saves a file in the OneDrive location, the AutoRecover option stores the file in the local computer, in the location divers by the user. To turn on this option, follow these steps:

In the Ribbon, get to File > Options. In Excel Options, (1) cheque Salve AutoRecover information every *number* minutes. Specify how often you want the file to exist saved.

For the AutoRecover file location, (iii) 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 to the specified folder.

Turn Off AutoRecover

If we desire to turn off AutoRecover, nosotros need to uncheck Salvage AutoRecover data 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 pick. Files are also deleted when yous salve and close them or quit Excel.

Source: https://www.automateexcel.com/how-to/turn-off-on-autosave/

Posted by: hickmanwithilt1989.blogspot.com

0 Response to "How To Turn Autosave On In Excel"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel