Excel Turn On AutoSave - Simple Guide

Reading time icon 2 min. read


Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Excel Turn On AutoSave

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.
AutoSave toggle
  1. If the AutoSave switch in the top left corner is unavailable, it indicates that you’re using an older version of Excel. Tap File.
Tap File
  1. Click Options.
Options
  1. Select Save under Excel Options.
Tap Save
  1. 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.
Save AutoRecover information every

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.

More about the topics: Excel

User forum

0 messages