Troubleshoot:excel Services Fix-"The workbook cannot be opened".

1. Problem Description:

Open the Excel file in the SharePoint 2013 document library Prompt "The workbook cannot be opened" error box, the document does not display properly.

2, the cause of the problem:

The reason for this error should be that the Excel service account does not have the appropriate access rights to the content database. When you upload a document to a document library, the document is saved as a blobs in the content database, and when you open the document, the Excel service account will query the database and regenerate the document, and the above error occurs if the Excel service account does not have sufficient permissions.

3. Solution:

Give the appropriate permissions to the Excel service account.

3.1. Locate the Excel service account
Central Administration > Security > Configure Service Accounts > select the Excel Services application option.

3.2. Give the right permissions

$w = get-spwebapplication–identity Http://tschauer
$w. Grantaccesstoprocessidentity ("Devtest\excel_services_account")

Troubleshoot:excel Services Fix-"The workbook cannot be opened".