Excel Services: Unable to process the request

Error

This error message appeared in a SharePoint 2010 farm/environment when trying to use Excel Services to display a Excel spreadsheet in SharePoint 2010.

image_thumb

Excel. Unable to process the request. Wait a few minutes and try performing this operation again.

After reviewing the Events and log files and finding error messages such as these:

image_thumb2

 

Event Viewer: Event 5239, Excel Services Application. There was an error in communicating with Excel Calculation Service (server address on port 32843, standard port for web services address ending with /ExcelService*.asmx) exception: The underlying connection was closed: An unexpected error occurred on a receive.

Issue

The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled.

Solution

The solution is to disable the ASP.NET Impersonation again.

Go to IIS Manager (Start, Administrative Tools, Internet Information Services (IIS) Manager). Expand the Sites node on the server running the Excel Services Service Application. Choose the Authentication icon in the IIS area. Choose ASP.NET Impersonation in the list and disable it using the action link on the right hand side.

image_thumb3

IIS Manager, Authentication settings for the SharePoint Web Services.

Ref : Stefan Johansson

Advertisements

One thought on “Excel Services: Unable to process the request”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s