Monday, November 10, 2014

"The workbook cannot be opened".Excel Services & PowerPovot for SharePoint Troubleshooting




When opening an Excel workbook (.xlsx) in the browser the error "The workbook cannot be opened" is thrown:

This is caused by the account running Excel Services not having proper permissions to the Content Database.
When you upload an Excel workbook to a SharePoint library, the workbook is stored as blobs in the Content Database. When you choose to open this in
Excel Services, the account running Excel Services needs to retrieve and reassemble the workbook. If the account running Excel Services lacks proper
permissions, "The workbook cannot be opened".

We have a KB on how to resolve this issue: The Excel Services Application for SharePoint 2010 does not load or display workbooks http://support.microsoft.com/kb/981293 In this blog, I will step you through this KB; where to collect data and explain what the two below SharePoint Management Shell Commands do: $w = Get-SPWebApplication –Identity $w.GrantAccessToProcessIdentity("") You need to find the . To do this: 1. Browse to the report library where the failing workbook is located and make note of the URL.



2. Central Administration > Application Management > Manage web applications compare the URL to the list of Web Apps. Find the correct Web App URL and add it to “URL of the web application”.



You now have the first command: $w = Get-SPWebApplication –Identity http://tschauer 3. Central Administration > Security > Configure Service Accounts > from the first dropdown, select the application pool running "Excel Services Application" and add that account where is says “”.



You now have the second command:

$w.GrantAccessToProcessIdentity("Devtest\Excel_Services_Account")

So now you can run these commands by following the below steps:

1. Click Start, click All Programs. 2. Click Microsoft SharePoint 2010/2013 Products. 3. Click SharePoint 2010/2013 Management Shell. 4. At the Windows PowerShell command prompt (PS C:\>), type the following command, and then press ENTER:

$w = Get-SPWebApplication –Identity http://tschauer

$w.GrantAccessToProcessIdentity("Devtest\Excel_Services_Account")

When you run these commands you are:

1. Adding the account running Excel Services as a User to the Content Database (Security > Users).

2. Giving the account running Excel Services the SPDataAccess Membership (Account > Membership)

3. Giving the account running Excel Services Full Control to the Web Application (Via "Policy for Web Application")

1 comment:

Google+ Followers