Excel Webservice() #VALUE error

%3CLINGO-SUB%20id%3D%22lingo-sub-1039986%22%20slang%3D%22en-US%22%3EExcel%20Webservice()%20%23VALUE%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039986%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20a%20response%20of%20%23VALUE%20from%20a%20webservice%20()%20function.%26nbsp%3B%20The%20URL%20within%20the%20webservice%20function%20is%20valid%20-%20I%20copied%20it%20into%20Chrome%20and%20it%20worked.%26nbsp%3B%20I%20took%20the%20same%20URL%20and%20put%20it%20into%20Google%20Sheets%20and%20it%20works%20there.%26nbsp%3B%20But%20not%20in%20Excel.%26nbsp%3B%20The%20URL%20is%20calling%20on%20Google%20Maps%20API%20for%20walk%20distance%20between%202%20addresses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Excel%20version%20is%201810%20Build%2011001.20074.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1039986%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047256%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Webservice()%20%23VALUE%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047256%22%20slang%3D%22en-US%22%3EWhich%20URL%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047284%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Webservice()%20%23VALUE%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20response%20-%20I%20was%20able%20to%20figure%20it%20out%20-%20I%20just%20had%20to%20enable%20links.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2296241%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Webservice()%20%23VALUE%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2296241%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F472943%22%20target%3D%22_blank%22%3E%40MrFMon%3C%2FA%3E%20can%20you%20please%20share%20how%20you%20were%20able%20to%20solve%20you%20problem%20in%20webservice%20I%20also%20having%20the%20same%20error.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2298093%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Webservice()%20%23VALUE%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1037617%22%20target%3D%22_blank%22%3E%40ermendiola0901%3C%2FA%3E%26nbsp%3BHi%20-%20sorry%2C%20it's%20been%20a%20little%20while%20since%20I%20got%20this%20figured%20out.%26nbsp%3B%20I%20believe%20it%20has%20to%20do%20with%20a%20Trust%20Centre%20setting.%26nbsp%3B%20Check%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fblock-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fblock-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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...