'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why Excel 2021 AutoSave Option is Missing and How to Fix It
Question details
The user is unable to find the AutoSave feature in Excel 2021 Professional, as it does not appear in the Quick Access Toolbar or settings.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Attempting to enable automatic saving for workbooks stored on OneDrive using Office 2021.
- Observed behavior
- The AutoSave toggle is entirely absent from the Quick Access Toolbar and the Excel save settings menu.
Verify your exact Microsoft Office version by opening Excel, clicking on 'File', and selecting 'Account' to confirm whether you have a perpetual Office 2021 license or a Microsoft 365 subscription.
Enable AutoRecover as an Alternative to AutoSave
Since the real-time AutoSave toggle is exclusive to Microsoft 365, configure AutoRecover in Excel 2021 to prevent accidental data loss.
The 'AutoSave' toggle in the upper-left corner of the window is a cloud-saving feature that is functionally exclusive to Microsoft 365 subscribers. Because Office Professional 2021 uses a traditional perpetual license, it does not include this specific real-time saving toggle, even if your files are located on OneDrive. Instead, users must rely on the traditional AutoRecover feature.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on the 'Save' category located in the left sidebar.
Check the box that says 'Save AutoRecover information every X minutes' and lower the number to a frequent interval, such as 5 minutes.
Ensure the box for 'Keep the last AutoRecovered version if I close without saving' is checked, then click 'OK' to apply your settings.
Manually Sync Files Using the OneDrive Desktop App
Save files directly to your local OneDrive folder to ensure your manual saves are synced to the cloud and retain version history.
Experience Reliable Cloud Syncing and Backup with WPS Office
If your current perpetual version of Excel lacks the cloud integration and automatic saving features you need, consider switching to WPS Office. It is a highly capable, free alternative that seamlessly handles Microsoft Office files while offering robust auto-backup features.
- 1. Download and Install: Get the free WPS Office suite from the official website and follow the quick installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and directly open your existing Excel workbooks without worrying about formatting issues.
- 3. Enable Cloud Backup: Sign in to your WPS account to enable WPS Cloud, ensuring your files are automatically backed up and accessible anywhere.
Frequently Asked Questions
Can I get the AutoSave toggle in Excel 2021 without upgrading?
No, the real-time AutoSave toggle in the Quick Access Toolbar is a premium feature exclusive to Microsoft 365 subscriptions. Excel 2021 users must rely on manual saving and the AutoRecover feature.
Is AutoRecover the exact same thing as AutoSave?
No. AutoSave continuously updates your live file to the cloud (OneDrive or SharePoint) in real-time. AutoRecover periodically saves a temporary local copy of your file solely for emergency recovery if Excel closes unexpectedly.
Why did AutoSave disappear after my Microsoft 365 subscription expired?
When a Microsoft 365 subscription expires and you revert to a standalone perpetual license like Office 2021 or 2019, premium cloud-connected features—including the AutoSave toggle—are automatically disabled.
How do I add a regular Save button to the Quick Access Toolbar in Excel 2021?
Click the small down arrow at the end of the Quick Access Toolbar at the top of the Excel window, and select 'Save' from the drop-down list to make the floppy disk icon visible.
