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. 

 

=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! 

1 Reply

@Moonshiney 

WEBSERVICE() itself works

image.png

that's something wrong with data or token

image.png