Nov 29 2019 12:15 PM
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?
Dec 04 2019 08:41 AM
Thank you for the response - I was able to figure it out - I just had to enable links.
Apr 26 2021 11:41 PM
Apr 27 2021 07:55 AM
@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...