Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I work for The Smeal College of Business at Penn State. I am doing a project for the Supply chain program and I am creating an excel workbook in Sharepoint that uses a lot of UDF's. I have no problem accessing the workbook or using other UDF's, but when I try to use OpenWorkbookForEditing() I get the following stack trace:

System.Net.WebException: The request failed with HTTP status 503: Service Unavailable. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ClassName.ExcelWebService.ExcelService.OpenWorkbookForEditing(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status) at ClassName.ClassNameFunctions.testWriteCell()

Additionally, I've tried to access excelservice.asmx through PHP SOAP and have not received a response. Each attempt to connect to this service provides a 503 error in the IIS logs similar to the following:

2012-08-06 15:14:58 xxxx::xxx:xxxx:xxxx:xxxxxxx POST /_vti_bin/excelservice.asmx - 80 - xxxx::xxx:xxxx:xxxx:xxxxxxx Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+2.0.50727.5456) 503 0 0 59

I've tried changing most of the settings in Sharepoint Central Administration, as well as some of the setting in IIS. Does anyone know what could be causing this problem? Thanks.

I'm running a Sharepoint 2010 server on Windows Server 2008.

share|improve this question
add comment

1 Answer 1

Have you enabled the Excel Service Application through
Central Admin > Manage Service Applications > Create > Excel Service Application.

Additionally, you need to configure the Trusted locations after you have created excel service application. This should include the path to the document library and probably having the user-defined functions checked.

share|improve this answer
    
I have done the above. The problem isn't with the excel service in general, but only when I try to access it through a SOAP call. Additionally, I can access the WSDL both programmatically and through the browser but making a call to any of the listed functions is when it fails. –  Briton.W Aug 14 '12 at 15:00
    
In Excel services application ,when you create trusted data locations settings you can also check the option "children trusted" and have the trusted location to be your site collection. This authorizes all child sites and lists to use user defined functions. –  Arko D Aug 16 '12 at 5:45
    
I have checked this option as well. I can access all of the UDF's I've created, the problem only occurs in the UDF that attempts to call the OpenWorkbookForEditing() function and as the stack trace indicates, the error occurs on the SOAP call. –  Briton.W Aug 16 '12 at 14:19
    
I would do a fiddler trace and see what is preceding this 503. If that doesn't yield any results then a network trace on both ends to view the entire communication period. The service is running, so I'm thinking you have an authentication issue possibly obscuring the situation. –  Jesus Shelby Jan 30 '13 at 19:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.