OneDrive File Issues

Fix Excel AutoSave Format Error for XLSX Files on OneDrive

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

Restore Excel AutoSave for an XLSX workbook stored on OneDrive when Excel says a modern Office format is required.

Fix Excel AutoSave Format Error for XLSX Files on OneDrive
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the cloud copy

In Excel, select File > Open and choose OneDrive. Sign in if prompted, then open the XLSX workbook from its OneDrive location.

2
Save the workbook

Select File > Save and resolve any prompts or save errors before continuing.

3
Turn on AutoSave

Use the AutoSave switch near the top of the Excel window. If the format error remains, check the workbook's permissions and sync status.

Reopen the OneDrive workbook and save it manually
Free Microsoft Office alternative

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.

Open and edit XLSX spreadsheets with WPS SpreadsheetCompatible with Microsoft Excel file formats, including XLSXFree and lightweight Office alternativeFamiliar spreadsheet interface for an easier transition
microsoft office alternative - wps office

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.