Enable Excel AutoSave for a OneDrive File in the Desktop App
Question details
Determine whether changes are automatically saved after opening a OneDrive workbook in the Excel desktop app.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- A student saves a copy of a workbook online in Excel for the web and continues working on it in the desktop app.
- Observed behavior
- The student wants subsequent edits to save automatically to the online copy rather than the original workbook.
Check that the workbook copy is stored in OneDrive and that you can sign in to the Microsoft account with access to it. AutoSave in desktop Excel generally requires a Microsoft 365 subscription and a supported workbook format.
Check AutoSave in the Excel desktop app
Use this method to confirm that edits to the OneDrive copy are saved automatically.
In Excel for the web, open the copy saved to OneDrive and select Open in Desktop App. Choose Open Excel in the confirmation window.
In Excel, sign in to the Microsoft account that has access to the OneDrive copy if you are asked to do so.
Find the AutoSave switch near the top-left corner of the Excel window and turn it on. If it is already on, leave it enabled.
Make an edit and check the save status near the workbook name. Confirm that the workbook is saved to OneDrive and that changes finish saving.

Check the file and account if AutoSave is unavailable
Use these checks if the AutoSave switch is off or cannot be enabled.
Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for editing spreadsheets. Its Excel format compatibility makes it easy to move existing workbooks into WPS, though it does not change Microsoft Excel's AutoSave settings.

Frequently Asked Questions
Does opening a OneDrive workbook in desktop Excel automatically enable AutoSave?
Not necessarily. After selecting Open in Desktop App, check the AutoSave switch near the top-left of Excel and turn it on if needed.
Do edits save to the original workbook or the online copy?
If you open the workbook created with Save a Copy Online, edits save to that copy. The original workbook remains separate.
Why can't I turn on AutoSave?
Check File > Info to confirm the workbook is in OneDrive, and check File > Account to verify your sign-in and subscription. AutoSave generally requires Microsoft 365 and a supported file format.
What happens if AutoSave is off?
Use File > Save to save changes manually. If the workbook is stored in OneDrive, an internet connection is needed to sync the saved changes online.




