OneDrive Excel File Corrupted? Practical Repair Steps

If an Excel file stored in OneDrive appears corrupted, first protect the current copy: make a separate copy if you can, then use OneDrive Version history to restore a known-good version or Excel for Microsoft 365 on Windows to try File > Open > Browse > Open and Repair. A sync warning, permission problem, or unfinished download can look like corruption, so check those before replacing the workbook.

What a corrupted OneDrive workbook can mean

OneDrive stores and synchronizes files; Excel reads and edits the workbook. A file that will not open from OneDrive is not necessarily damaged. The issue may be in the workbook itself, the local copy being synchronized, the connection, or the app trying to open it. Identifying which situation you have helps avoid overwriting a recoverable version.

True workbook damage can happen if Excel or the device shuts down while saving, storage fills up, or a transfer is interrupted. But errors such as a file being locked, unavailable, or in an unsupported format can have other causes. A cloud icon or sync status showing an error is a reason to investigate synchronization, not proof that the workbook’s contents are corrupted.

Start with a specific observation: Does the file open in Excel for the web but not the desktop app? Does a downloaded copy open? Does Excel report that the file format or extension is invalid? These clues point to different next steps. If the workbook contains important or confidential information, avoid uploading it to an unfamiliar online repair service.

Protect the file before trying repairs

Do not repeatedly save over the only copy or delete the file and re-create it. Before experimenting, use OneDrive on the web to download a copy, or use File > Save As in Excel to save a separate local copy if the workbook opens. Give the copy a distinct name so it cannot be confused with the synchronized original. If a copy cannot be downloaded or opened, leave the original in place while checking Version history.

Check OneDrive’s sync status as well. In File Explorer, a status icon beside the workbook can indicate whether it is available locally or still syncing; the exact icons and wording can vary with OneDrive settings and version. If OneDrive reports an error, resolve the sync issue or wait for synchronization to finish before testing again. Avoid editing the same workbook simultaneously in multiple places while you are diagnosing it, because concurrent edits can create a conflict copy.

Keep the original file in OneDrive while you investigate.
Make a separate copy before attempting a repair or changing the file type.
Record the exact Excel error message; it can distinguish a format issue from a sync issue.
Do not rename the extension as a repair method. Changing .xlsx to .xls, for example, does not convert the workbook and can make it harder to identify.

Restore a previous version in OneDrive

If the workbook opened before a particular edit or save, Version history is often the safest first recovery option. It can let you retrieve an earlier version without trying to reconstruct the file. Available versions depend on the account, retention settings, and how the file was stored, so an older version is not guaranteed to be present.

Open OneDrive in a web browser and find the workbook.
Select the file’s More actions menu, usually shown as three dots, and choose Version history. In some views, right-clicking the file also exposes this command.
Review the available versions and their dates. If possible, open or download a candidate version to check that it contains the expected data.
Download the earlier version or make a separate copy before choosing Restore if you want to preserve the current state.

Restoring a version makes that version the current file, so first preserve the current copy if it might contain useful recent edits. If the workbook is shared, tell collaborators before restoring it: a restore can change what everyone sees. Version history is not the same as the Recycle bin. The Recycle bin is primarily for deleted files; use Version history to look for earlier saved states of a file that still exists.

Use Excel Open and Repair on Windows

For Microsoft Excel for Microsoft 365 on Windows, Open and Repair is the built-in repair attempt for a workbook that Excel cannot open normally. Work from a downloaded or copied version when possible, rather than risking an overwrite of the only cloud copy.

Open Excel, then choose File > Open > Browse.
Select the workbook in the file picker. Do not double-click it to open it.
Select the arrow beside the Open button, then choose Open and Repair.
Choose Repair first. If Excel cannot repair the workbook, repeat the process and choose Extract Data if that option is offered.
If the workbook opens, immediately use File > Save As to create a new file with a different name. Check important sheets, formulas, charts, and links before treating the repaired copy as complete.

Repair may recover the workbook structure, but it cannot promise to restore every element. Extract Data is intended to recover values and formulas when possible; formatting, charts, objects, or other workbook features may be missing. Compare the repaired file with a previous version or another reliable source before relying on its contents.

Excel for Mac and Excel for the web do not necessarily present the same Windows Open and Repair workflow. If you are using a Mac, first preserve a copy and try opening the workbook in Excel for the web or on a Windows computer with the desktop repair option. Menu availability can vary by Excel version. Do not assume that repeatedly opening and saving a damaged file in another app will repair it.

Check whether the problem is OneDrive or Excel

Try opening the workbook in Excel for the web from OneDrive. If it opens there, the stored file may be readable and the problem may be related to the desktop app, an add-in, or the local synchronized copy. If it fails in both places, try downloading a copy and opening that copy in desktop Excel. These tests are clues rather than definitive diagnoses, because web and desktop Excel do not support every workbook feature in exactly the same way.

Confirm the file has finished downloading and that you selected the intended workbook. A similarly named conflict copy may contain newer edits than the original. Check OneDrive’s activity or sync messages, and look for filenames that indicate a conflict. If the desktop app displays a Protected View or security notice, read the message before enabling editing; a security warning is not itself proof that a file is corrupt.

If other workbooks also fail to open, the issue may be Excel rather than this particular file. Close Excel and try again. On Windows, you can test whether an add-in is involved by starting Excel in Safe Mode: press Windows key + R, type excel /safe, and press Enter. On Mac, Windows shortcuts and this Safe Mode command do not apply; use the Mac app’s available troubleshooting and update options. If only one workbook fails, focus first on its version history and a separate downloaded copy.

Resolve common sync and format problems

OneDrive synchronization can be interrupted by a connection problem, a paused sync, insufficient storage, or a file that is open and being edited elsewhere. Check that OneDrive is signed in to the expected account and that its status indicates the file has finished syncing. If the account is out of storage, free space or address the account limit before expecting new changes to upload. Do not remove the local file simply to force a sync unless you know which copy is authoritative.

Also check the extension and the app expected to open the file. Common Excel workbook types include .xlsx and macro-enabled .xlsm. A file may fail if it was only partially downloaded, if its extension was changed without converting its contents, or if another application saved it in an incompatible format. If the workbook came from someone else, ask them to confirm the original format and, if possible, provide a fresh copy.

Excel for the web can be a useful comparison, but it is not a universal repair tool. Some features, external connections, macros, or workbook elements may behave differently in a browser. If it opens on the web, download a copy and preserve it before continuing in desktop Excel, especially if the file relies on specialized features.

When repair does not work

If Open and Repair fails, return to OneDrive Version history and look for an earlier usable save. If no suitable version is available, check whether you have another legitimate copy, such as a downloaded backup or a copy held by a collaborator. For a work or school account, an administrator may be able to advise on retention or recovery options; what is available depends on the organization’s policies and Microsoft 365 setup.

If Excel itself appears unstable across multiple files, update Office and consider repairing the Microsoft 365 installation through Windows Settings. The exact labels can change by Windows version, but the installed apps options commonly include Microsoft 365, Modify, and Quick Repair or Online Repair. These options address the Office installation, not the damaged contents of a particular workbook, and an online repair may require an internet connection.

For a workbook with critical business, research, or financial data, keep every copy and note which recovery steps you tried. Do not treat a file as correct just because it opens: verify key totals, formulas, dates, named ranges, and worksheets against a known source. If no clean version exists and the data is essential, consult your organization’s IT support or a reputable data-recovery professional rather than repeatedly modifying the only remaining copy.

How to reduce the risk of future damage

Keep OneDrive synchronization enabled and wait for it to finish before shutting down or moving between devices. Use Excel’s normal save process and avoid forcing a device to power off while a workbook is saving. For shared files, let collaborators know before major restores or offline edits, and check for conflict copies after working without a connection.

For important workbooks, maintain an independent backup in addition to synchronization. OneDrive helps keep files available and can provide version history, but synchronization is not identical to a complete backup strategy: unwanted changes or deletions can also synchronize, and version availability depends on retention. Periodically verify that a backup can actually be opened, and preserve source data used to rebuild critical reports.

Frequently Asked Questions

Can I recover a corrupted Excel file from OneDrive?
Often, if OneDrive has an earlier version available. Open the file’s Version history, inspect earlier saves, and download or copy a usable version before restoring it. Recovery is not guaranteed if no suitable version was retained.

Does OneDrive Version history overwrite my current workbook?
Choosing Restore changes the current file to the selected earlier version. Preserve or download the current copy first if its recent edits might matter, then verify the restored workbook before sharing it as the new working copy.

What does Open and Repair recover?
Excel may repair workbook contents or offer Extract Data when a normal open fails. Recovery can be incomplete: formulas or values may be recoverable while formatting, charts, or other features are not. Save the result as a separate file and check it carefully.

Why does my Excel file open in the browser but not on my computer?
The desktop app, local OneDrive copy, an add-in, or an Excel feature may be involved. Download a separate copy, check sync status, and try the Windows Open and Repair option if the desktop app still cannot open it.

Should I delete the file and download it again?
No, not before preserving the cloud copy and checking its sync status. Downloading a separate copy can be a useful test, but deleting the original may remove a version or create confusion about which copy contains the latest edits.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.