Share via

SharePoint 2013: Excel Services Fails to Load Workbook

  • Article

Introduction

On a SharePoint Dev. Farm also called a “Next-Next-finish” farm when trying to open a workbook in the browser with or without Excel Services developers are receiving this error:

http://gokanx.files.wordpress.com/2014/01/000.png?w=330&h=138

There is an official Microsoft knowledge base for SharePoint 2010 about this that you can find here: http://support.microsoft.com/kb/981293

According to the support this problem occurs because the service account that runs the Excel Services Application does not have access to the SharePoint content databases.

The resolution is quite simple for SharePoint 2010 or SharePoint 2013:

To resolve this problem, the SharePoint Global Farm Administrator must grant access to the account to run the Excel Services Application. To do this, follow these steps for each Web application:

  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:PS> $w = Get-SPWebApplication –Identity <URL of the Web application>PS> $w.GrantAccessToProcessIdentity(“<insert service account>”)

After you do this, the service account is granted db_owner access to the SharePoint content database(s).

PowerShell

Locate the site where you get the error and find the WebApp Name. If you are a SharePoint Global Farm Administrator navigate to Central Administration > Application Management > Manage web applications URL of the web application and find your Web Application.

http://gokanx.files.wordpress.com/2014/01/0001.png?w=600&h=159

  • So we have to execute the first command line as demanded on the Support of Microsoft.

$w = Get-SPWebApplication –Identity http://spmoss99:7777/. Now we have to find the name of the service account that is being configured for Excel Services**.** Therefore please navigate to Central Administration > Security > Configure Service Accounts > from the first dropdown, select the application pool running “Excel Services Application” and get the Managed Account

http://gokanx.files.wordpress.com/2014/01/0002.png?w=600&h=241Our second command line as demanded on the Support of Microsoft looks like: $w.GrantAccessToProcessIdentity(“Domain\ManagedAccount”)

  1. Click Start, click All Programs.
  2. Click Microsoft SharePoint 2010/2013 Products.
  3. Click SharePoint 2010/2013 Management Shell and execute the two following lines.

Non-PowerShell

Well if you can’t use PowerShell but you still have the issue there is another way to fix it.

Connect to your SQL Server and expand Security > Logins and find the Managed Account that is being used for the Excel Services.

http://gokanx.files.wordpress.com/2014/01/0003.png?w=600

Under the properties Navigate to the User Mapping Page and select the Content Database of your Web Application where you get the error and add the Managed Account as a DB_Owner.

http://gokanx.files.wordpress.com/2014/01/0004.png?w=600&h=540

References