Excel Services Application unexpected workbook failure - Event 5225 (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Excel Services Application unexpected workbook failure

Event ID:   5225

Summary:   The server for Excel Services Application is responsible for loading, refreshing, and recalculating workbooks, and maintaining user session state. An unexpected failure occurred on the server for Excel Services Application and a workbook session was terminated.

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

  • User sessions are dropped on Excel Services Application. This causes a workbook in the browser to stop responding or causes an error message to appear; for example, An error has occurred.

  • This event appears in the event log: Event ID: 5225 Description: An unexpected serious error occurred when executing <URL to workbook>. The workbook will be unloaded by the server for Excel Services Application. If this error continues to occur, an administrator should look at the file and verify its contents.

Cause:   A workbook file that is in a corrupted state was loaded on the Excel Services Application server.

Note

Administrator permissions are required to perform these steps.

Resolution:   Remove the affected file

  1. From the event log, note the path to the file for event ID 5225.

  2. Use the path to locate the file on the disk, or in the list of workbook files in SharePoint.

  3. Delete the file.

Resolution:   Restart the Excel Services Application server computer

  • If the problem persists or occurs for numerous files or for files that were previously loading correctly, restart the Excel Services Application server computer.