I'm using the new webservice function in excel 2013. I have a problem that when the return message from the service is above a certaian size. The call in excel craps out. I can make the same call from a web browser without any problems.
Are there any work arounds to this?


Dim sResultXML As String
sResultXML = Application.WorksheetFunction.WebService(sURL)

GetXMLResults = sResultXML

Error # 1004: Unable to get the WebService property of the WorksheetFunction class