OneDrive File Issues

Fix Excel AutoSave Turned Off or Saving a Copy in OneDrive

Algirdas JasaitisAlgirdas Jasaitis Nov 12, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook information page

In Excel, open the workbook and select File > Info.

2
Check the signed-in account

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.

3
Confirm the storage 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.

4
Verify editing access

Use the Share or Manage Access option for the file and confirm that your account has permission to edit the workbook.

AutoSave requirement: AutoSave may remain unavailable for local files, unsupported locations, or workbooks opened with read-only access.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
  2. 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. 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.
Open and edit workbooks in a familiar spreadsheet interface without relying on Excel AutoSave.Work with Microsoft Excel .xlsx and .xls files while preserving common formulas and formatting.Use a lightweight office suite for everyday spreadsheet editing and file sharing.Move between WPS Office and Microsoft Excel with broad format compatibility.
microsoft office alternative - wps office

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.