Forum Discussion

MrFMon's avatar
MrFMon
Copper Contributor
Nov 29, 2019

Excel Webservice() #VALUE error

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 ...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 04, 2019
Which URL please?
MrFMon's avatar
MrFMon
Copper Contributor
Dec 04, 2019

JKPieterse 

Thank you for the response - I was able to figure it out - I just had to enable links.

  • ermendiola0901's avatar
    ermendiola0901
    Copper Contributor
    Apr 27, 2021
    Hi MrFMon can you please share how you were able to solve you problem in webservice I also having the same error.
    • MrFMon's avatar
      MrFMon
      Copper Contributor
      Apr 27, 2021

      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-10204ae0-0621-411f-b0d6-575b0847a795

       

       

Resources