Excel Web Services: Error http://myserver:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 403: Forbidden (Forbidden port)
By peter.stilgoe
Im having a problem on a MOSS 2007 farm where if I try & open a spreadsheet in Excel web services I get the error:
Excel Web Access
An error has occurred.
Please contact your system administrator if this problem persists
And in the Sharepoint logs:
Error http://myserver:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 403: Forbidden (Forbidden port)
If I search Google there doesnt appear to be any results for the error ‘The request failed with HTTP status 403: Forbidden (Forbidden port)’ and Im really stumped now.
If anyones got any ideas much appreciated !
TIA……..
UPDATE: 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>
Some more info about bypassonlocal can be found here: ByPassOnLocal MS KB
More From pstilgoe
Excel Web Services Compatibility Checker – Automatically fix common errrors
By peter.stilgoe
Excel Web Services Compatibility Checker is a great tool for when you’re trying to publishing Excel dashboards to Sharepoint and you keep getting various web services errors. This tool will check your workbook for compatability errors & also will autofix most errors if you choose.
Typical error message:
“The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:
External references (links to other workbooks)
Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects
Contact the workbook author.”
Download Excel Web Services Compatibility Checker



May 20th, 2011
