To enable AutoSave in Excel for Microsoft 365 on Windows, save your workbook to OneDrive or SharePoint, then switch on the AutoSave toggle near the upper-left corner of the Excel window. AutoSave continuously saves changes to supported cloud files; it is different from AutoRecover, which helps restore work after Excel closes unexpectedly.
Before you start, make sure you are signed in to Microsoft 365 and have access to a OneDrive or SharePoint location. AutoSave generally cannot be turned on for a workbook saved only on your computer, a network drive, or a removable drive. If you prefer to keep a file local, you can still use AutoRecover and save manually.
What You’ll Need
- Excel for Microsoft 365, installed and signed in with your Microsoft account or work or school account.
- A workbook saved in OneDrive or SharePoint, with permission to edit it. A personal OneDrive account or an organization’s SharePoint library can work.
- An internet connection for cloud syncing. Excel can sometimes keep changes locally while offline, but those changes will need to sync after you reconnect.
Step-by-Step
- Open the workbook in Excel. Start Excel and open the file you want to protect. If you have not created it yet, create a blank workbook. The AutoSave control may be visible even before you open a file, but you need a supported cloud file for it to stay on.
- Sign in to your Microsoft account. In Excel for Windows, select File > Account and check the account information. If you are not signed in, choose the sign-in option and follow the prompts. For a work or school file, use the account that has access to your organization’s OneDrive or SharePoint. A sign-in prompt or an account mismatch can prevent the file from syncing.
- Save the workbook to OneDrive or SharePoint. Select File > Save As. Choose a OneDrive location or a SharePoint site you can edit, browse to the folder, enter a file name, and select Save. If the workbook already lives in OneDrive or SharePoint, check its location from File > Info or the title bar rather than saving another copy unnecessarily. Keep an eye on the file name and folder so you know which copy you are editing.
- Turn on the AutoSave switch. Find AutoSave near the upper-left of the Excel window, close to the Save control, and switch it to On. In some window layouts, the switch may appear in the title bar. If Excel asks whether to turn on AutoSave for the file, confirm. The workbook needs to be saved to a supported cloud location before Excel can keep this setting on.
- Check that changes are being saved. Make a small, harmless edit, such as typing a temporary word in an empty cell, and watch for a saving or saved status near the file name. Wait until Excel indicates that the change has synced, then undo the test or remove it. You can also close and reopen the workbook to verify the edit persisted, but first confirm that it finished saving. Avoid testing with important data or closing while a sync is still in progress.
- Set up AutoRecover as an additional safeguard. AutoSave does not replace recovery settings. In Windows Excel, go to File > Options > Save. Check that saving AutoRecover information is enabled and choose a reasonable interval, such as every 5 or 10 minutes. The exact choices shown can vary by Excel version. This setting can help recover unsaved work after a crash, but it is not a substitute for cloud AutoSave or regular backups.
On a Mac, sign in to the Office account and save the workbook in OneDrive or SharePoint, then use the AutoSave switch in Excel’s title area. The switch and surrounding controls can look different from Windows. Excel for the web saves cloud workbooks automatically as you work, so it may not show the same desktop AutoSave switch. If you are using a different Excel edition, check that version’s account and file-saving controls.
Common Mistakes
- Leaving the file on the computer. A workbook in Downloads, Documents, or a desktop folder is local unless that folder is actually inside a synced OneDrive location. Use File > Save As and choose OneDrive or SharePoint, then verify the location.
- Confusing AutoSave with AutoRecover. AutoRecover keeps recovery information at intervals and is most useful after a crash. AutoSave writes supported cloud-file changes as you work. Turning on one does not automatically turn on the other.
- Editing the wrong copy. A local copy and a cloud copy can have the same name. Check the file’s location in Excel before making important changes, and avoid switching between copies without a clear naming system.
- Assuming the toggle guarantees an instant backup. AutoSave syncs changes to the cloud, but network interruptions, account permissions, or sync conflicts can delay saving. Wait for the saved status before closing or disconnecting, especially after a large edit.
- Using a file type or workbook setup that limits the feature. Older formats or certain compatibility and protection arrangements can make AutoSave unavailable. If Excel displays a warning or disables the switch, read the message before changing formats or settings; a conversion may affect workbook behavior.
Tips
- Use clear file names and folders. For example, store a working budget in a named project folder in OneDrive instead of leaving multiple versions in different locations. This makes it easier to identify the cloud copy that AutoSave is updating.
- Check sync status before shutting down. After a large paste, import, or series of edits, give Excel time to finish syncing. If you are offline, reconnect and confirm the pending changes have reached the cloud before relying on another device.
- Keep version history in mind. OneDrive and SharePoint can provide file version history, depending on your account and organization settings. It can help restore an earlier cloud version if a saved change causes a problem. Version history is not a replacement for keeping separate backups of critical files.
- Protect local-only work with AutoRecover. If you cannot use cloud storage, check the AutoRecover interval under File > Options > Save on Windows and save manually with Ctrl+S (on Mac, Command+S). Recovery files may not include every change made since the last recovery point.
- Be careful with shared workbooks. AutoSave can save edits while other people are working in the same cloud file. Coordinate changes to important sheets and watch for conflict or sync messages rather than assuming another person’s edits are already visible.
Troubleshooting
The AutoSave switch is missing or grayed out. First check that you are using Excel for Microsoft 365, that you are signed in, and that the workbook is stored in OneDrive or SharePoint. A locally saved file will not qualify just because OneDrive is installed on the computer. Use File > Save As to save a cloud copy, then reopen or select that copy and check the switch again. If the workbook is read-only, protected, in an older format, or subject to organization restrictions, resolve the displayed warning or ask your Microsoft 365 administrator about the policy before changing the file.
AutoSave keeps switching off. Confirm that the workbook remains in the cloud location and that Excel is signed in to the account that owns or can edit it. Check whether the file has been opened in compatibility mode or whether Excel reports an unsupported feature or format. Save a separate copy in a current Excel workbook format if appropriate, then test AutoSave on that copy. Do not overwrite the original until you have checked that conversion will not remove needed features.
Changes are not appearing on another device. On the computer where you edited the file, check Excel’s status for upload or sync errors. Confirm the internet connection, available OneDrive storage, and account used on both devices. Wait for the upload to finish, then open the same file from the same OneDrive or SharePoint location on the other device. If you see a conflict copy or conflict message, compare both versions before deciding which edits to keep.
You closed Excel and lost recent edits. Reopen the workbook and check whether the edits were saved or whether Excel offers a recovery file. On Windows, you can also look under File > Info > Manage Workbook for available recovery options; the wording and options may differ by version. For a cloud workbook, check its version history if available. Recovery is not guaranteed, particularly if Excel was offline or the file never finished saving.
Frequently Asked Questions
Does AutoSave work with files saved on my computer?
Generally, no. Excel’s AutoSave switch is designed for supported workbooks stored in OneDrive or SharePoint. A local workbook can still be saved with Ctrl+S on Windows or Command+S on Mac, and AutoRecover can help after some unexpected closures.
Is AutoSave the same as AutoRecover?
No. AutoSave continuously sends changes in a supported cloud workbook to OneDrive or SharePoint. AutoRecover saves recovery information periodically and may help restore work after a crash. Turn on AutoRecover separately if you want that extra protection.
Can I enable AutoSave in Excel without OneDrive?
For Excel’s desktop AutoSave feature, the workbook needs to be in OneDrive or SharePoint. If you do not use either service, save manually and configure AutoRecover. Excel for the web also works with cloud-stored files.
Does Excel for Mac have AutoSave?
Yes. In current Microsoft 365 versions, save the workbook to OneDrive or SharePoint and use the AutoSave switch in the Excel window. The control’s placement can differ from Windows. Mac also has AutoRecovery settings, which are separate from AutoSave.
Does AutoSave work when I am offline?
Offline changes may be kept on your device temporarily, but they cannot sync to OneDrive or SharePoint until the connection returns. Reconnect and check for a completed save or any conflict message before closing Excel or editing the same file elsewhere.
How often does Excel save with AutoSave on?
AutoSave saves changes as you work rather than waiting for a manual save interval, but syncing may take time depending on the file, connection, and service. Check Excel’s save status before closing, and do not treat the switch as a guarantee that every keystroke has already reached the cloud.
Related
- How to Delete Leading Zeros in Excel Without Losing Data
- Delete Information in Excel Cells: Safe, Clear Steps
- How to Delete Only Filtered Rows in Excel Without Errors
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hanging Indent in Word: Set It Up for Clean CitationsTo add a hanging indent in Word, select the paragraph or paragraphs, open Home > Paragraph dialog launcher,…
- Excel Merge Cells and Combine Text: How They DifferIn Excel, merging cells joins a selected area into one larger cell, but it does not combine the…
- Excel Not Responding? Recover an Unsaved FileIf Excel is not responding and your work has not been saved, do not force-close it right away.…
- Excel Table Formatting Tips for Clearer, Easier DataFor clear, reliable Excel table formatting, convert your data range into a table with Ctrl+T, confirm that the…
- Excel Copy and Paste Rows Into Columns: 3 Easy MethodsTo copy a row into a column in Excel for Microsoft 365 on Windows, select the row cells,…
- Excel Column Hide Shortcut Key: Windows and MacIn Excel for Microsoft 365 on Windows, select the column or columns you want to hide and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.