Excel: Disable AutoSave & Change Autosave Location
To disable AutoSave in Excel, go to the top-left corner and toggle the AutoSave switch to Off. To change the autosave location, you cannot directly change where AutoSave stores its temporary files, but you can change the default local save location and the AutoRecover file location via File > Options > Save.
Understanding AutoSave vs. AutoRecover
Excel has two separate features that are often confused: AutoSave and AutoRecover. AutoSave is a cloud-based feature that continuously saves your file to OneDrive, SharePoint, or OneDrive for Business. It only works when the file is stored in the cloud, and it saves every few seconds as you type. AutoRecover, on the other hand, is a local backup system that periodically saves a copy of your work to your hard drive. It is designed to help you recover unsaved changes if Excel crashes or your computer loses power. AutoRecover works for all files, whether they are stored locally or in the cloud.
How to Turn Off AutoSave
Disabling AutoSave is straightforward. Here are the steps:
- Open the Excel file that has AutoSave enabled.
- Look at the top-left corner of the window, just above the ribbon.
- Find the AutoSave toggle switch (it will be blue when on, gray when off).
- Click the toggle to turn it off.
If you want to disable AutoSave for all new files by default, you can change the setting in Excel Options:
- Go to File > Options.
- Select Save on the left sidebar.
- Under the “Save workbooks� section, check the box that says “AutoSave OneDrive and SharePoint Online files by default on Excel�.
- Uncheck it to disable AutoSave by default.
- Click OK.
Note that this default setting only affects files saved to OneDrive or SharePoint. Files stored locally will not have AutoSave regardless.
How to Change the AutoRecover File Location
While you cannot change the exact location of AutoSave’s temporary files (they are managed by the cloud service), you can change where AutoRecover saves its backup copies. Here’s how:
- Open Excel and go to File > Options.
- Select Save on the left.
- Under “Save workbooks�, find the “AutoRecover file location� field.
- Click the Browse button and choose a new folder.
- Click OK to save the change.
You can also change the default local file location (where Excel saves files when you choose “Save As� on a local drive) in the same section, under “Default local file location�. This is often what people mean when they ask about changing the autosave location.
Why You Might Want to Disable AutoSave
There are several reasons you might want to turn off AutoSave:
- Version control: If you are making major changes and don’t want every edit saved automatically, you might prefer to manually save only when you’re ready.
- Accidental edits: If you often make mistakes and rely on “Undo�, AutoSave can interfere because it saves the mistake before you can undo it.
- File size and performance: On very large files, AutoSave can slow down your work because it constantly writes to the cloud.
- Privacy: You may not want your work-in-progress to be synced to the cloud in real time.
If you disable AutoSave, you’ll need to save manually (Ctrl+S) or use AutoRecover to protect against crashes.
Common Problems and Misconceptions
One common misconception is that turning off AutoSave also disables AutoRecover. That is false. AutoRecover is a separate feature that still works even when AutoSave is off. Another issue is that AutoSave only appears when the file is saved to OneDrive or SharePoint. If you open a local file, you won’t see the toggle at all. If you want to use AutoSave but it’s grayed out, check that the file is actually saved to a cloud location, not just a local folder.
Another problem users face is that AutoRecover files are not saved as often as they expect. By default, Excel saves an AutoRecover copy every 10 minutes. You can change this interval in the same Save options menu by adjusting the “Save AutoRecover information every X minutes� setting. Setting it to 1 minute gives you more frequent backups but uses more disk space.
How to Recover Unsaved Work
If Excel crashes and you lose work, you can recover unsaved files using the AutoRecover feature. To do this:
- Open Excel and go to File > Open.
- Click Recent and then scroll to the bottom to find “Recover Unsaved Workbooks�.
- Select the file you want to recover from the list.
You can also find AutoRecover files directly in the folder you set in the options. The files have a .xlsb extension and are named like “AutoRecover save of Book1.xlsb�.
AutoSave vs. Manual Save: Which Should You Use?
For most users, AutoSave is a helpful feature that prevents data loss. It is especially useful when collaborating on shared files, as it ensures everyone sees the latest version. However, if you are working on a sensitive document that you don’t want to be cloud-synced, or if you prefer to control when changes are saved, turning it off is a reasonable choice. Manual saving gives you more control but requires discipline to avoid losing work.
Frequently Asked Questions
Can I change the autosave location for OneDrive files?
No, you cannot change where OneDrive stores its autosave data. The autosave location is managed by the cloud service and is tied to your OneDrive account. You can only change the AutoRecover file location, which is for local backups.
Why is AutoSave grayed out in Excel?
AutoSave is grayed out when the file is not saved to a cloud location. If the file is stored locally on your computer, AutoSave is not available. Save the file to OneDrive or SharePoint to enable it.
Does turning off AutoSave affect AutoRecover?
No, turning off AutoSave does not affect AutoRecover. AutoRecover is a separate feature that continues to work regardless of AutoSave status. You can still recover unsaved changes after a crash.
How do I change the AutoRecover time interval?
Go to File > Options > Save. Under “Save workbooks�, you’ll see “Save AutoRecover information every X minutes�. Change the number to your desired interval (e.g., 5 minutes) and click OK.
Where are AutoRecover files stored by default?
By default, AutoRecover files are stored in a hidden folder on your computer, typically under AppData\Roaming\Microsoft\Excel. You can find the exact path in File > Options > Save under “AutoRecover file location�.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.