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.
=WEBSERVICE("https://api-ssl.bitly.com/v3/shorten?access_token=myapikey&longUrl=url")
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!
