Now a user can work without losing data that might happen due to an excel crash or any system issue.

Then click on the OK button all the settings will be applied to the workbook.Īs we can see in the above example of an Excel AutoSave, a user can configure the time at which time interval you want to save the workbook for AutoRecover and select the respective file where you want to save the file. Step 4: Now AutoSave setting will be open where a user can configure AutoSave settings, tick mark on the AutoSave checkbox, configure the time at which time interval you want to save the workbook for AutoRecover, and select the respective file where you want to save the file. Step 3: After clicking on Options, a pop-up will open with a header as Excel Options click on the Save. Step 1: Open Excel and Click on the File tab. Example #1Ī user has a standalone book data of sales, income, PBDIT, and Profit details of each quarter of ABC Company. Let’s understand How to Enable AutoSave in Excel with some examples. It is also useful when we accidentally close the working file. Shortcuts to Save the Excel file: We can use Ctrl + S shortcut to save the workbook manually.ĪutoSave in Excel helps us to protect our files in case of a system crash. So, there is no need to worry about losing data due to any problem rather we will lose very minimal data instead of losing it completely.

As per our requirement, we can change as per our requirement, let us take an example, suppose if we are working on something that is very important and wants to reduce the time to 1 min. When we enable AutoSave mode in Excel, we can save our workbook file in a gap of every 10 minutes. Excel functions, formula, charts, formatting creating excel dashboard & others

Turn on autosave in word 2013