How to use WEBSERVICE in Excel online

New Contributor



I built a Green House Gas calculator on Excel 365 desktop. I use WEBSERVICE to pull commuting distance information from Google Map API, and it is working perfectly.

I want to host the calculator (excel sheet) online, but it seems all WEBSERVICE formulas turn into #VALUE!, does anyone know how to fix it? Thank you. 

2 Replies

@Sergei Baklan  Thank you!