Excel Services Application not available - Event 5234 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010

Alert Name:   Excel Services Application not available

Event ID:   5234

Summary:   A front-end Web application computer cannot locate and send requests to the server for Excel Services Application. The Excel Services Application server computer is required to load workbooks.

Symptoms:   One or more of the following symptoms might appear:

  • Workbooks do not load on Excel Services Application server.

  • This event appears in the event log: Event ID: 5234 Description: No Excel Calculation Server is available in the farm. [User: <username>].

Cause:   One or more of the following might be the cause:

  • The Excel Services Application server computer might not be running.

  • Excel Services Application might not be started on the server computer.

  • The proxy that the front-end Web server is using might not be the default member of the default proxy group for Excel Services Application.

Resolution:   Verify that the service application instance runs on the machine

  1. On the SharePoint Central Administration Web site, click System Settings.

  2. Click Manage servers in this farm.

  3. For each server that you want to run Excel Services Application, select the name of the server.

  4. On the Services on Server page, if Started is not indicated for Excel Calculation Services in the Status column, click Start in the Action column.

Resolution:   Restart the Excel Services Application server

  • Restart the Excel Services Application server computer.

Resolution:   Verify that the proxy for the service application is the default member for Excel Services Application

  1. On the SharePoint Central Administration Web site, on the Quick Launch click Application Management, and in the Service Applications section click Configure service application associations.

  2. On the Service Application Associations page, in the Application Proxy Group column, for your Web application, click the name of the proxy group. The default name for the proxy group is default.

  3. In the Configure Service Application Associations dialog box, if the check box for the Excel Services Application proxy is not selected select it. If there is more than one Excel Services Application proxy and the word [default] does not appear after the name of the proxy you want to use, select the check box, and then click [set as default].

  4. Click OK.