WSE is causing the Excel cannot connect to the SharePoint List error.  How do I fix it, while keeping WSE?
Let me apologize if this is not the right forum for this. I wasn't sure where to stick this at.I have a client who is using a 3rd party product that hooks into SharePoint. I'm not really sure what the 3rd party product does, but I do know that it requires and installs Web Service Enhancements (WSE) 2 on the SharePoint server.Initally, this caused the content editor web parts to no longer allow users to use the rich text editors. I was able to set a location in the web.config to remose the soap extension types for the WebPartPages.asmx web service and everything seemed to work.They then realized they could no longer export lists to a spreadsheet. I tried to do the same trick but since that functionality uses OWSSVR.dll (WebDAV) and not a web service, it didn't fix the issue. I removed the WSE entries from the web.config and then I could export to a spreadsheet. So I'm pretty sure WSE is the issue. The resolution in every post I ready said to remove WSE which is not an option here.Below is thecontents of the web.config file. <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <configuration> <configSections> <section name="microsoft.web.services2" type="Microsoft.Web.Services2.Configuration.WebServicesConfiguration, Microsoft.Web.Services2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </configSections> <system.web> <webServices> <protocols> <remove name="HttpGet" /> <remove name="HttpPost" /> <remove name="HttpPostLocalhost" /> <add name="Documentation" /> </protocols> <soapExtensionTypes> <add type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" /> </soapExtensionTypes> </webServices> <customErrors mode="On" /> <httpRuntime maxRequestLength="128000" executionTimeout="900" /> </system.web> <location path="WebPartPages.asmx"> <system.web> <webServices> <soapExtensionTypes> <remove type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" /> </soapExtensionTypes> </webServices> </system.web> </location> <location path="authentication.asmx"> <system.web> <authorization> <allow users="*" /> </authorization> </system.web> </location> <location path="wsdisco.aspx"> <system.web> <authorization> <allow users="*" /> </authorization> </system.web> </location> <location path="wswsdl.aspx"> <system.web> <authorization> <allow users="*" /> </authorization> </system.web> </location> <microsoft.web.services2> <messaging> <maxRequestLength>128000</maxRequestLength> </messaging> </microsoft.web.services2> </configuration> Any ideas?- John
December 3rd, 2009 11:01pm

Try the following: <location path="_vti_bin">     <system.web>       <webServices>         <soapExtensionTypes>           <remove type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" />         </soapExtensionTypes>       </webServices>     </system.web>   </location>
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2010 11:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics