Forum Discussion

Shijie's avatar
Shijie
Copper Contributor
Apr 01, 2021

How to use WEBSERVICE in Excel online

Hello, 

 

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. 

Resources