Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The Excel Services Application for SharePoint 2010 does not load or display workbooks


View products that this article applies to.

Symptoms

The Excel Services application for Microsoft SharePoint 2010 does not load or display workbooks.

This problem may occur in one of the following scenarios:
  • In a custom-security configuration.
  • When you add a new Web application to a farm.
  • When you do not perform a default installation.

↑ Back to the top


Cause

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

↑ Back to the top


Resolution

To resolve this problem, the 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 Products.

  3. Click SharePoint 2010 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>")

    Note The placeholder <insert service account> represents the service account that you use to run the Excel Services Application.
After you do this, the service account is granted db_owner access to the SharePoint content databases.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbexpertiseinter, kbhowto, kbsurveynew, kbprb, kb

↑ Back to the top

Article Info
Article ID : 981293
Revision : 4
Created on : 6/7/2019
Published on : 6/26/2019
Exists online : False
Views : 250