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. 

3 Replies

@Sergei Baklan  Thank you!

@Shijie Is there any way to use an API call in Excel Online?