Excel Webservice() #VALUE error

Occasional Visitor

I am getting a response of #VALUE from a webservice () function.  The URL within the webservice function is valid - I copied it into Chrome and it worked. 




I've been using this function normally for several months but suddenly it's nor working

It was not firewall problem or Trust Center Settings  in excel 

- Both tried but couldn't help


please help me! 

1 Reply


WEBSERVICE() itself works


that's something wrong with data or token