If an Excel file in SharePoint seems corrupted, first avoid saving over it: download a copy, then use SharePoint’s Version history to restore or download a healthy earlier version. If no good version exists, try Excel for Microsoft 365 on Windows: open a local copy with File > Open > Browse, select the workbook, choose the arrow beside Open, and select Open and Repair.
What a corrupted SharePoint Excel file means
SharePoint stores and serves workbooks, but a file that fails to open from a SharePoint library is not necessarily damaged. The problem could be in the workbook itself, in a downloaded or synchronized copy, or in the route used to open it. An interrupted upload, an incomplete sync, a browser or network issue, or a workbook feature that Excel for the web cannot handle can all look like corruption at first.
Clues that point more strongly to actual file damage include an Excel message that the file format or extension is invalid, a repair prompt, or repeated failures when opening a downloaded copy in desktop Excel. By contrast, if the same workbook opens after you download it, or opens in desktop Excel but not in a browser, the cause may be a browser, compatibility, permission, or connection issue rather than damaged workbook contents.
It also helps to distinguish the original library file from a local copy. A file in a synced OneDrive folder can be temporarily unavailable or out of date while synchronization catches up. Editing that copy may create a conflict or make it harder to identify the latest good version. Start by checking the file in SharePoint online and its version history before making changes.
Common causes and clues
Excel workbooks contain more than visible cell values. They may include formulas, formatting, charts, pivot tables, links, macros, and other workbook structures. An interrupted save or upload can leave the file incomplete, while an application crash or storage problem can damage a local copy. These are possible causes, not proof that SharePoint itself caused the damage.
- Incomplete upload or sync: A connection interruption during transfer may leave a copy that is not fully available. Check whether SharePoint shows a recent modified time and whether the uploader finished syncing.
- Wrong file or extension: Renaming a file extension does not convert its format. For example, changing a non-Excel file’s name to end in .xlsx does not make it a valid workbook.
- Browser or Excel for the web limitation: Some workbook features may behave differently or require desktop Excel. If desktop Excel opens the downloaded file, the workbook may be intact.
- Conflicting edits: Multiple people or devices can create competing copies or sync conflicts. Compare file names, modified times, and version history rather than assuming the newest-looking local copy is authoritative.
- Permissions or service interruption: An access error or temporary loading failure can prevent opening without indicating corruption. Ask whether another authorized user can open the file and check whether the issue affects other files.
What to do first: protect the original
Do not repeatedly edit, overwrite, or rename the only copy. Make a safe copy before attempting repairs, and note the file name, its SharePoint location, and when the problem first appeared. If Excel offers to repair a workbook, save the repaired result under a new name so the original remains available for comparison.
- Open the SharePoint document library in a browser and confirm that you have the correct file. Check its modified time and whether other users report the same problem.
- Download a copy using the file’s menu or the library’s Download command. If it is in a synced folder, first confirm that OneDrive has finished syncing; a cloud-only file may need to download before desktop Excel can open it.
- Try opening the downloaded copy in Excel for Microsoft 365 on Windows. If it opens, use Save As to create a separate working copy and compare it with the library version before replacing anything.
- If it does not open, check SharePoint Version history for an earlier version. Download that version to a separate location before deciding whether to restore it to the library.
These steps preserve choices. Restoring or repairing immediately can replace the version other people are using, and a repaired workbook may omit some content. If the workbook is business-critical, coordinate with its owner or SharePoint administrator before changing the shared file.
Recover an earlier version from SharePoint
Version history is usually the quickest way to undo damage when the workbook was healthy before a particular edit, save, or upload. In the SharePoint library, select the file or open its three-dot menu, then choose Version history. The exact menu presentation can vary with the SharePoint view and site configuration. Review the dates and, where shown, the people who made changes. If you can, download a candidate version first and test it without replacing the current file.
If you decide to restore a version, use the Restore command beside that entry and confirm the prompt. SharePoint makes the selected version current; this is not the same as permanently erasing every later version. Still, check the version list afterward and make sure you selected the intended workbook and date. Version history availability, number of retained versions, and permissions depend on library settings and organizational policies, so an older version may not be present.
If the file was deleted rather than corrupted, check the site’s Recycle bin, provided you have permission. Restoring a deleted file is different from restoring an earlier version of an existing file. If neither the Recycle bin nor Version history contains what you need, contact the site owner or administrator promptly; retention and recovery options depend on the organization’s Microsoft 365 configuration.
Use Excel Open and Repair on a copy
For a downloaded workbook that will not open normally, Excel for Microsoft 365 on Windows includes Open and Repair. In Excel, choose File > Open > Browse, navigate to the downloaded copy, select it, and choose the arrow beside the Open button. Select Open and Repair. If Excel offers a choice, try Repair first. If that fails, Extract Data may recover values and formulas while leaving other workbook features behind.
Review the result carefully. A workbook that opens after repair is not automatically complete: Excel may remove damaged elements, and charts, formatting, formulas, links, macros, or other content might be missing or changed. Check important sheets, formulas, named ranges, and any calculations that matter to your work. Save the repaired workbook with a new name, then compare it with an earlier SharePoint version before uploading it as the replacement.
Open and Repair is a Windows desktop Excel workflow; do not assume the same command is available in Excel for the web or Excel for Mac. On a Mac, first download a separate copy and try opening it with the current desktop Excel app. If it fails, prioritize SharePoint Version history or ask an administrator for a recoverable copy rather than experimenting on the only original.
Tell corruption apart from sync or browser trouble
Try a controlled comparison: open the library file in the browser, download it, and open the download in desktop Excel. If only Excel for the web fails, note the exact message and test desktop Excel; features such as macros or certain workbook operations may require the desktop app. If the download works but a File Explorer copy does not, check OneDrive’s sync status and whether that local copy is current.
When a synced workbook has a conflict, do not delete either copy until you have compared them. OneDrive may identify a conflicted file or keep separate copies, and the details depend on what happened during synchronization. Check both versions for recent edits, then save the version you need under a distinct name. If several people edited the workbook, ask them to pause changes while you identify the authoritative copy.
Also consider access and service issues. A message about permissions, a missing file, or a timeout is not the same as an Excel repair warning. Ask a colleague with appropriate access to check the library, and contact your Microsoft 365 administrator if multiple files or users are affected. That helps separate a single-workbook problem from a broader service or account issue.
What may be recoverable—and what may not
Recovery results depend on what remains intact. Version history can bring back a prior saved state, while Open and Repair may salvage parts of a damaged workbook. Extract Data is a fallback when opening the workbook normally is unsuccessful; it is not a guarantee that the original layout or every feature can be reconstructed. Treat any recovered file as a candidate that needs checking, not as a verified replacement.
Compare recovered content against another source if accuracy matters. For example, if a monthly sales workbook opens after repair, check totals against a prior report or source system, review formulas in key summary cells, and confirm that hidden sheets and filters are still present. Do not assume that a visible total proves every row was recovered. If there is no usable version history and repair yields incomplete data, an administrator may be able to advise whether organizational retention or backup options apply.
Reduce the chance of repeat problems
SharePoint and Excel provide useful recovery mechanisms, but the best protection is a clear process for shared workbooks. Keep version history enabled according to your organization’s policy, and ask the library owner how long versions are retained. Avoid replacing a shared file with a repaired copy until someone has checked it. For sensitive or operationally important workbooks, establish who can edit the file and how a recovery decision should be approved.
- Wait for uploads and OneDrive synchronization to finish before closing a device or moving the file.
- Use the SharePoint library as the shared source of truth; avoid circulating multiple email attachments as if each were current.
- When testing a repair, work on a downloaded copy and save under a new name.
- For important calculations, retain an independent source for critical data and validate totals after recovery.
- Ask the SharePoint administrator about version retention and recovery policies instead of assuming every old version will remain available.
Frequently Asked Questions
Can SharePoint corrupt an Excel file?
SharePoint stores and synchronizes files, but an opening error alone does not establish that SharePoint damaged the workbook. An incomplete transfer, a local sync copy, Excel compatibility, or permissions can produce similar symptoms. Compare the online file, a download, and Version history.
How do I restore a previous Excel file in SharePoint?
In the document library, open the file’s menu and choose Version history. Find the version you need and use Restore, or download it first to check it without changing the current library version. Whether older versions are available depends on library settings and retention.
Can Excel repair a corrupted workbook?
Excel for Microsoft 365 on Windows has Open and Repair for a local copy: File > Open > Browse, select the workbook, choose the arrow beside Open, then Open and Repair. Repair may not preserve every feature, so inspect the result and save it separately.
Why does an Excel file open in desktop Excel but not SharePoint?
Excel for the web does not handle every desktop feature or workflow identically, and a browser or permission issue may also be involved. If the downloaded workbook opens correctly in desktop Excel, that is evidence against assuming the file itself is corrupted.
What if Version history has no usable copy?
Keep the original unchanged and try Open and Repair on a downloaded copy. If the result is incomplete or the data is important, contact the site owner or Microsoft 365 administrator to ask what recovery options the organization retains.
Related
- Excel: Split a Cell by Hyphen in 4 Ways
- Excel Remove Duplicates from a Column: What to Know
- Excel Remove Print Area: Clear It Without Deleting Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Out of Office in Outlook 365: Set It Up on Any DeviceTo set an out-of-office message in Outlook 365, open Automatic replies, turn them on, write your message, and—if…
- Can You Make Columns in a Text Box in Microsoft Word?Yes. In desktop Microsoft Word, select the text box and use Shape Format > Columns to divide its…
- How to Calculate Average Hours in ExcelTo calculate average hours in Excel, enter each duration as a time value, then use =AVERAGE(B2:B6) for durations…
- Create a Bcc Distribution List in OutlookTo create a Bcc distribution list in Outlook, first make a reusable contact group or contact list, then…
- Resize Columns in Excel: Keyboard Shortcuts and TipsIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O,…
- Excel Sheet Protection: How to Protect and Unlock CellsTo protect a worksheet in Excel for Microsoft 365 on Windows, open the sheet, select Review > Protect…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.