Excel Turn On AutoSave - Simple Guide

Excel lets you turn on AutoSave to prevent data loss by saving your work automatically as you go. If you’re prone to forgetting to hit save or worry about system crashes, you can rely on AutoSave to keep your documents safe. 

It also ensures you always have a recent version of your work. I’ll show you how to enable this feature, so let’s get started!

How To Turn on AutoSave in Excel

Follow the below steps:

1. Launch Excel and open the target file.
2. Check the AutoSave toggle at the top left corner. It should be visible in Microsoft 365 connected to OneDrive or SharePoint. Toggle it “On.” When it’s on, you should see a shield on top.

3. If the AutoSave switch in the top left corner is unavailable, it indicates that you’re using an older version of Excel. Tap File.

4. Click Options.

5. Select Save under Excel Options.

6. Tick the “Save AutoRecover information every” box. The default duration is always 10 minutes; change it to 1 minute and press OK. This will save your work automatically every minute you write.

Turning on AutoSave in Excel is a simple but effective way to safeguard your work and prevent data loss. Follow the steps outlined, and you’ll never have to worry about losing important work again. To learn more about this feature, don’t miss out guide on where are Excel autosave files saved.

You can also learn to create an attendance sheet and turn off AutoSave if it bothers you. If you’d like to find out where the Excel autosave files are located, we have a separate article on that.