Excel Webservice() #VALUE error

Copper Contributor

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?


4 Replies
Which URL please?

@Jan Karel Pieterse 

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

Hi @MrFMon can you please share how you were able to solve you problem in webservice I also having the same error.

@ermendiola0901 Hi - sorry, it's been a little while since I got this figured out.  I believe it has to do with a Trust Centre setting.  Check: https://support.microsoft.com/en-us/topic/block-or-unblock-external-content-in-office-documents-1020...