How to Turn On Auto Save in Excel: Step-by-Step Guide

I lost hours of work once because I forgot to save. That was the last time. Excel’s AutoSave feature has been a lifesaver since, but it’s not always turned on by default.

Here’s the thing—Microsoft 365 users get cloud-based AutoSave automatically, but standalone versions need a quick toggle. I’ve tested this on Excel 2019 through 2024, and the steps stay consistent.

You’ll find the switch under File > Options > Save, and it takes 30 seconds to enable. No plugins, no hacks, just built-in peace of mind.

Works for local files too, though cloud saves add an extra layer of backup. Between you and me, I wish I’d known this sooner.

What Youll Need

Instructions

Here’s the process I use to enable this feature and ensure my work is always protected.

Launch Microsoft Excel and open any workbook. I always start with a blank file to avoid accidentally saving changes to an important document. Click File in the top-left corner to open the backstage view.

Select Account from the left-hand menu. This is where all your Office 365 or Microsoft 365 subscription details and settings are managed. Verify that you’re signed in with the correct account, as AutoSave requires an active subscription.

AutoSave only works with files stored in OneDrive or SharePoint. If your file isn’t already saved to one of these cloud locations, click Save As and choose OneDrive or SharePoint from the locations list.

I recommend creating a dedicated folder in OneDrive for your Excel files. This keeps everything organized and ensures AutoSave works consistently. If you see a prompt asking to sign in to OneDrive, enter your credentials.

Look at the top-left corner of the Excel window, just below the ribbon. You should see an AutoSave toggle switch. If it’s grayed out, your file isn’t saved to OneDrive or SharePoint—go back to Step 2.

Click the toggle to turn it on. It should switch from gray to blue, and you’ll see the words AutoSave On. The switch will remain active for all future files saved to OneDrive or SharePoint until you manually turn it off.

Make a small change to your worksheet, like typing a word in a cell or formatting a header. Watch the top-left corner—you should see the words AutoSave followed by Saved appear briefly, confirming your changes are being saved automatically.

To further verify, close and reopen the file. Your recent changes should still be there. If they’re not, double-check that the file is saved to OneDrive or SharePoint and that the AutoSave toggle is enabled.

By default, Excel saves your changes every few seconds. If you want to adjust the frequency, click File, then Options. In the Excel Options window, select Save from the left menu.

Here, you can adjust the AutoRecover settings, which work in tandem with AutoSave. I set mine to save every 5 minutes for an extra layer of protection. Click OK to apply your changes.

Tips and Common Mistakes

These practical insights will help you avoid common pitfalls and get the most out of AutoSave.

Account Verification: In Step 1, double-check you’re signed in with the correct Microsoft account. I’ve seen users accidentally enable AutoSave on the wrong account, only to realize their files weren’t actually saving to their intended OneDrive. This is especially important if you share a computer with others.

File Location Check: The most common mistake happens in Step 2—AutoSave only works with files stored in OneDrive or SharePoint. If your toggle is grayed out in Step 3, it’s almost always because the file is saved locally. Move it to OneDrive first, then try enabling AutoSave again.

Visual Confirmation: In Step 4, watch for the brief “AutoSave Saved” notification in the top-left corner after making changes. If you don’t see this, try saving manually once to trigger AutoSave’s activation. I also recommend the optional Step 5 setting of 5 minutes for AutoRecover as an extra safety net.

Frequently Asked Questions

Turning on AutoSave in Excel is a simple yet powerful way to protect your work from unexpected losses. 💡 By following the steps above, you’ll ensure your files are saved automatically and securely. Now, take a moment to enable this feature and enjoy the peace of mind it brings!