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

Article ID: 981293 - View products that this article applies to.
Expand all | Collapse all

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 | Give Feedback

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 | Give Feedback

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 | Give Feedback

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 | Give Feedback

Properties

Article ID: 981293 - Last Review: October 6, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft SharePoint Server 2010
Keywords: 
kbexpertiseinter kbhowto kbsurveynew kbprb KB981293
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top