Issue: In some cases, the Excel binder may become corrupt. When this occurs, users may one of the following errors when opening the binder in Excel desktop:
​
​

Repairing the file in Excel desktop can unlink it from its SharePoint or create an offline version of the Excel file. In this scenario, opening the file in Excel online typically won't work either, as it will indicate that the repair needs to be done in Excel desktop.

Cause: Corrupt Excel File / SharePoint limitation

Resolution/Workaround: Try the steps below to resolve:
​
**UPDATE:** Excel now allows the repair of Excel workbooks in Excel Online. Simply open the corrupted binder in Excel Online, load the add-in, and click "Continue" if prompted. This should resolve the issue with the workbook. Afterwards, open the workbook in Excel desktop to ensure that it is indeed fixed. If the issue persists, you can attempt the longer fix provided below:

1- Check out the file from Active.

2- Open the downloaded checked-out binder in Excel desktop.

3- Proceed with confirming "Yes" to repair the file.

4- After the repair is complete, save this repaired binder somewhere on your computer WITH .xlsx format.

5- Check in this repaired binder into Active.

This will fix it for all users who have never opened this file. However, for users who have opened the file in a corrupt state previously, Excel (caches/) tends to hold onto previous versions of the file and thinks it's still corrupt.

For users still unable to open the binder (and are still getting the repair error), try the steps below:

Open the file in Excel online, click into the file name at the top left, and navigate into the folder in SharePoint hosting this file. Once it takes you to the SharePoint folder, click the three dots and download a copy of the binder. Right click the downloaded copy, go to properties and unblock it if applicable. Ensure this downloaded copy has the same name as the binder name. This downloaded copy (directly from SharePoint) can be opened in Excel desktop, and it should update the cache of Excel to recognize the repaired file. Finally, get them to close excel and try opening the binder directly from the Active website. If the issue persists, allow the checked in file to sync 15 mins, then try opening it again.
​
If the issue persists, try clearing Excel's document cache on the affected machine. To do this, go to File > Options > Save. Delete any files from the AutoRecover file location and click Delete cached files button as follows:
​

If the issue persists, try cleaning this folder: C:\Users\user\AppData\Local\Microsoft\Office\16.0\OfficeFileCache

If the issue persists, get a colleague to open the binder, then wait 5 mins and try opening the binder again on the users screen.