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

Article translations Article translations
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.

CAUSE

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

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.

STATUS

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

Properties

Article ID: 981293 - Last Review: October 6, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft SharePoint Server 2010
Keywords: 
kbexpertiseinter kbhowto kbsurveynew kbprb KB981293

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com