Fix an Excel Workbook Corrupted in Microsoft Teams
Question details
The user needs to recover Excel workbooks that become corrupted after collaborative editing in Microsoft Teams and Excel for the web.

- Product
- Microsoft Excel, Excel for the web, and Microsoft Teams
- Device & OS
- not provided
- Scenario
- Multiple users edit shared .xlsx workbooks in Teams and Excel for the web over several days or weeks.
- Observed behavior
- Multiple workbooks eventually report corruption and must be downloaded for local repair.
Identify an affected workbook and note where it is stored in Teams, SharePoint, or OneDrive. Ask collaborators to pause editing while you recover the file or test a simplified copy.
Repair the downloaded workbook in desktop Excel
Use this option when the shared workbook reports corruption and you need to recover its contents.
In Teams, open the channel or chat files, select the workbook, and choose More options > Download.
In desktop Excel, choose File > Open > Browse and select the downloaded workbook. Select the arrow next to Open, then choose Open and Repair.
Choose Repair. If Excel cannot repair the workbook, repeat Open and Repair and choose Extract Data to recover available values and formulas.
Choose File > Save As to save the recovered workbook under a new name, then check its sheets, formulas, and formatting before sharing it.

Restore an earlier version of the shared workbook
Use version history if a known-good copy exists from before the corruption appeared.
Test workbook features that may cause compatibility issues
Use a simplified test workbook to investigate recurring corruption across shared files.
Work with Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing compatible Excel files. It makes moving everyday spreadsheet work easier, though it does not fix corruption in Microsoft Teams or Excel for the web.

Frequently Asked Questions
Why does my Teams Excel workbook keep becoming corrupted?
The cause is not confirmed. Workbook features or compatibility may contribute, so review defined names in Formulas > Name Manager, table formulas and references, and rules under Home > Conditional Formatting > Manage Rules.
Can I recover a workbook without repairing it locally?
If version history is available, open the file's SharePoint or OneDrive location, select the workbook, and choose Version history. Restore a version saved before the corruption appeared.
Does data validation cause this corruption?
Data validation has not been established as the cause. Test a simplified workbook with and without validation under the same collaboration pattern, and compare the results.
What if Open and Repair cannot fix the workbook?
In desktop Excel, try File > Open > Browse, select the workbook, and choose Open and Repair from the Open button's menu. If Repair fails, repeat the process and choose Extract Data, or restore an earlier version from version history.




