Fix Excel AutoSave Turned Off or Saving a Copy in OneDrive
Question details
The user needs to troubleshoot Excel AutoSave when a cloud workbook opens with AutoSave disabled or saves as a numbered copy instead of replacing the original.
- Product
- Microsoft Excel with OneDrive or SharePoint
- Device & OS
- not provided
- Scenario
- A workbook is opened from cloud storage and the user wants AutoSave to update the original file.
- Observed behavior
- AutoSave is turned off, or Excel saves a copy with an appended number rather than overwriting the original workbook.
Confirm the workbook is stored in OneDrive or SharePoint rather than on a local drive. Have the Microsoft account credentials and the original cloud folder available so you can compare the signed-in account and storage location.
Verify the Microsoft account, cloud location, and edit permissions
Use this solution when AutoSave is disabled as soon as the workbook opens or when the file may belong to another account or folder.
Excel AutoSave generally requires a workbook saved in OneDrive or SharePoint, an active sign-in to the account that owns or accesses the file, and edit permission for that location.
In Excel, open the workbook and select File > Info.
Review the account shown in the Info page and confirm it is the same Microsoft account connected to the workbook's OneDrive or SharePoint location.
Check the file path or location in File > Info and make sure the workbook is stored in OneDrive or SharePoint, not only on the local computer.
Use the Share or Manage Access option for the file and confirm that your account has permission to edit the workbook.
Save a copy back to the original cloud folder
Use this option when the file opens correctly but Excel creates a numbered copy instead of updating the original workbook.
Edit OneDrive Workbooks with WPS Office and Preserve Excel Compatibility
WPS Office is a free, lightweight alternative for opening, editing, and saving Excel workbooks when Excel AutoSave or account synchronization is causing problems. Its familiar spreadsheet interface supports common cloud workflows and maintains compatibility with Microsoft Excel formats for easier migration.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
- 2. Open the Excel workbook: Select Open from the WPS home screen and choose the .xlsx or .xls workbook from your computer or connected cloud folder.
- 3. Edit and save the workbook: Make your changes, select File > Save As, and choose the desired cloud folder and Excel format, such as .xlsx.

Frequently Asked Questions
Why does Excel AutoSave turn off for a OneDrive workbook?
AutoSave can be unavailable when the workbook is stored locally or in an unsupported location, when Excel is signed in to a different Microsoft account, or when you only have read-only access.
How can I check which account Excel is using?
Open the workbook, go to File > Info, and review the signed-in account. Compare it with the account that owns or can edit the OneDrive or SharePoint folder.
Why does Excel save a file with a number at the end of its name?
A numbered copy can appear when Excel cannot overwrite the original file because of a location mismatch, insufficient permissions, synchronization problems, or a conflicting open file. Use File > Save a Copy and select the original cloud folder.
Can I use WPS Office to open an Excel file from OneDrive?
Yes. In WPS Office, select Open and browse to the synced OneDrive folder, or download the workbook first. Save it as .xlsx when you need to maintain Microsoft Excel compatibility.




