Forum Discussion

MrFMon's avatar
MrFMon
Copper Contributor
Nov 29, 2019

Excel Webservice() #VALUE error

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 took the same URL and put it into Google Sheets and it works there.  But not in Excel.  The URL is calling on Google Maps API for walk distance between 2 addresses.

 

The Excel version is 1810 Build 11001.20074.

 

Any suggestions?

 

excel
    • MrFMon's avatar
      MrFMon
      Copper Contributor
      Dec 04, 2019

      JKPieterse 

      Thank you for the response - I was able to figure it out - I just had to enable links.

      • ermendiola0901's avatar
        ermendiola0901
        Copper Contributor
        Apr 27, 2021
        Hi MrFMon can you please share how you were able to solve you problem in webservice I also having the same error.

Resources