How to Enable Autosave in MS Excel to Protect Your Data

Date:2020-3-29 Author:Cordelia

An Excel sheet containing many complicated data can take much of your time to deal with. If there’s any emergency happens in the process of editing it like power outage, switch trip or system halted, your effort may lead to no end. Therefore, we better enable the autosave feature in Excel.

1. Click File, and choose Options on the left sidebar.

How to Enable Autosave in MS Excel to Protect Your Data

2. Go to Save pane in Excel Options. Here you can customize how workbooks are saved.

If you want to edit the file without additional worries, then increase the frequency of autosave by shortening the interval time between 2 auto saves (don’t forget to check the option if not). You can also customize the location to place your autosave files.

How to Enable Autosave in MS Excel to Protect Your Data

3. Hit OK. From now on the Excel file will be saved according to your setting automatically.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *