Forum Discussion
=WebService function timing out
I am using the WEBSERVICE function to call a service that I created. I can see from my logging of the service that the request is completing, but Excel returns #VALUE! before the service can finish. I am guessing that Excel is timing out. I would like to know if there is a way to configure the timeout Excel gives to the WEBSERVICE function
2 Replies
you can try going into the response cell where Webservice formula is and press F2 and Enter, this usually fixes the problem, although it is a manual process.
Another suggestion is to use the function NOW() in the WEBSERVICE formula to force it to refresh.
=WEBSERVICE(…) & IF(NOW()=NOW(),"","")
Or
=WEBSERVICE(…) + 0 * NOW()
If this still does not work and you are certain that the URL is correct, then check your Excel settings, make sure that the Message Bar pops up about blocked content and allow it in the Trust Center Settings.
