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