Unable to establish connection with Excel Services Application - Events 5231 5233 (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010

Alert Name:   Unable to establish a connection with Excel Services Application

Event ID:   5231 and 5233

Summary:   The front-end Web application sent a request to a specific server for Excel Services Application and could not contact the server computer. In this case, the Web front end attempts to load balance to a different Excel Services Application server if another server is available.

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

  • Workbooks fail to load.

  • Longer load times for workbooks that succeed to load.

  • This event appears in the event log: Event ID: 5231 Description: The Excel Calculation Server <URL to server> is no longer available. Session: <session ID> User: <username>]

  • The following message may be shown in the event log: Event ID: 5233 Description: The Excel Calculation Server <URL to server> is no longer available. Session: <session ID> User: <username>].

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

  • The Excel Services Application server computer is turned off or is off the network.

  • The Excel Services Application server computer is having difficulty and is unavailable.

Ensure the server is started and can connect to the network

  1. Ensure that the server running Excel Services Application is turned on and running.

  2. Ensure that the server running Excel Services Application is able to connect to the network and that you can connect to the server form another computer on the network.

  3. If the server is started and it can connect to the network and the problem is not fixed, re-install Excel Services Application and re-add the server to the farm.