An error has occurred. Please contact your system administrator if this problem persists.

While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:

Error Message:

An error has occurred.

Please contact your system administrator if this problem persists. 

ULS Logs shows the following entry:

There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.

Checked the event viewer and found the following:

Event Viewer entries:

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category: Excel Services Web Front End

Event ID:  5234

Date: 12/7/2012

Time: 2:50:06 PM

User: N/A

Computer: XXX

Description:

No Excel Calculation Services is available in the farm.[User:

SHAREPOINT\system]

Event Type:        Error

Event Source:    Office SharePoint Server

Event Category:  Excel Services Web Front End

Event ID: 5239

Date: 12/7/2012

Time: 2:50:06 PM

User:                     N/A

Computer: XXX

Description:

There was an error in communicating with Excel Calculation Services

http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx

exception: Unable to connect to the remote server

[Session: (null)

User: SHAREPOINT\system].

Troubleshooting Done:

1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d  which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.

2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.

3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.

4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.

5-Ran this below mentioned commands but no results:

stsadm -o setsharedwebserviceauthn -negotiate

stsadm -o execadmsvcjobs

6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d  but it is fine and no problems

7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html

Resolution that fix our issue:

If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:

<system.net>

<defaultProxy>

<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>

</defaultProxy>

</system.net>

------------------------------------------

what we have added in this: bypassonlocal = "true"

Issue has been resolved and excel services started working without any issues, Thank you

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, Thanks