Fix an Invalid Excel File Format or Extension After OneDrive Sync
Question details
Open an Excel workbook that reports an invalid file format or extension after OneDrive synchronization.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- not provided
- Scenario
- The user needs to open a workbook synchronized through OneDrive.
- Observed behavior
- Excel reports that the file format or extension is invalid and does not open the workbook.
Check the OneDrive sync status and wait for the workbook to finish syncing. In File Explorer, confirm that the file has the expected extension, such as .xlsx or .xls; do not change the extension without converting the file.
Open the workbook in Excel Safe Mode
Use Safe Mode on Windows to check whether an add-in or startup setting is preventing the workbook from opening.
Press Windows+R, enter excel.exe /safe, and select OK.
In Excel, select File > Open > Browse, then choose the affected workbook.
If the workbook opens, select File > Save As and save a copy in the appropriate Excel Workbook (.xlsx) or Excel 97-2003 Workbook (.xls) format.

Use Excel Open and Repair
Try Excel's built-in repair option if the synchronized workbook may be damaged.
Restore an earlier OneDrive version
Use version history when an earlier copy of the synchronized workbook may still be available.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files into WPS, although it cannot guarantee recovery of a damaged OneDrive workbook.

Frequently Asked Questions
Will changing the file extension fix the error?
Not necessarily. The extension must match the actual file format. If the workbook opens, use File > Save As to choose a supported format instead of simply renaming the extension.
How do I open Excel in Safe Mode?
On Windows, press Windows+R, enter excel.exe /safe, and select OK. Then use File > Open > Browse to try the workbook.
Where is Open and Repair in Excel?
In desktop Excel, go to File > Open > Browse, select the workbook, and choose Open and Repair from the arrow menu next to Open.
Can I recover an earlier copy from OneDrive?
If version history is available, find the workbook in OneDrive on the web and select Version history. You can then download or restore an earlier version.




