Fix Excel AutoSave Format Error for XLSX Files on OneDrive
Question details
Restore Excel AutoSave for an XLSX workbook stored on OneDrive when Excel says a modern Office format is required.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- A user wants to automatically save changes to an XLSX workbook stored on OneDrive.
- Observed behavior
- Excel reports that AutoSave requires a modern Office format even though the workbook is already an XLSX file.
Confirm that the workbook has an .xlsx extension and that you can sign in to the OneDrive account where it is stored. Check that you are using a supported Microsoft 365 desktop version of Excel.
Reopen the OneDrive workbook and save it manually
Use this approach to verify that Excel opened the cloud copy and can save changes to it.
In Excel, select File > Open and choose OneDrive. Sign in if prompted, then open the XLSX workbook from its OneDrive location.
Select File > Save and resolve any prompts or save errors before continuing.
Use the AutoSave switch near the top of the Excel window. If the format error remains, check the workbook's permissions and sync status.

Check OneDrive permissions, synchronization, and co-authoring
Use these checks if the workbook still cannot use AutoSave after being reopened and saved.
Edit XLSX Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility helps you move existing workbooks into WPS, although it does not fix Microsoft Excel or OneDrive AutoSave errors.

Frequently Asked Questions
Why does Excel say my XLSX file needs a modern format?
The extension may already be correct, but AutoSave can also depend on the cloud location, edit permissions, sync status, Excel version, and co-authoring support. Open the file through File > Open > OneDrive and try File > Save.
Does the workbook have to be stored on OneDrive?
Excel AutoSave works with supported files stored on OneDrive or SharePoint. Use File > Open to select the cloud copy rather than a separate local copy.
Can I use AutoSave on a shared workbook?
You need edit access to the shared file, and the workbook and storage setup must support co-authoring. Open it in OneDrive on the web to check your access, or ask the owner for edit permission.
What should I do if OneDrive is not syncing the workbook?
Open the OneDrive app and review its sync status. Resolve any reported sign-in, storage, or sync errors, then reopen the workbook in Excel and try AutoSave again.




