Forum Discussion

Sachin Jain's avatar
Sachin Jain
Brass Contributor
Sep 23, 2023

Webservice function not working in Excel and generating #VALUE error after launch of python in excel

Ever since Python in Excel is launched, Webservice() function is not working in excel and generating #VALUE error.  Is there any update on this ? Today i got update in Office 365 but still not fixed....
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 23, 2023

Sachin Jain 

You are right, it doesn't work on Beta. Perhaps some news with Trust center and we shall allow the source additionally. Not sure, practically don't use WEBSERVICE().

  • JerryDNYC's avatar
    JerryDNYC
    Copper Contributor
    Oct 04, 2023

    SergeiBaklan I track what beta version of Excel I have irregularly. My notes have the following information:

    • 09/01/2023: Version 2309 Build 16.0.16827.20000 64-bit - Includes Python
    • 09/09/2023: Version 2310 Build 16.0.16830.20000 64-bit
    • 09/21/2023: Version 2310 Build 16.0.16907.20000 64-bit - WEBSERVICE problem surfaces
    • 09/28/2023: Version 2310 Build 16.0.16924.20002 64-bit - WEBSERVICE problem NOT FIXED
    • 10/04/2023: Version 2311 Build 16.0.16926.20000 64-bit - WEBSERVICE problem NOT FIXED

    Maybe that would help?

    • Sachin Jain's avatar
      Sachin Jain
      Brass Contributor
      Oct 11, 2023
      Issue Resolved now in Build 17005
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 07, 2023

      JerryDNYC 

      Unfortunately I can't help here. I'm not working on Microsoft and have no information except what is published officially in release notes.

  • Sachin Jain's avatar
    Sachin Jain
    Brass Contributor
    Sep 24, 2023
    Yes, in new worksheet if we enter the URL it gives Microsoft Excel Security Notice , stating potential security concert , i have test all the settings with trust center as well , but no specific way to run the function is not available . even if we enable the content , it does not allow the connection.
    • Sachin Jain's avatar
      Sachin Jain
      Brass Contributor
      Oct 11, 2023
      Issue resolved 🙂
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 24, 2023

      Sachin Jain 

      I'd recommend to send a frown, Microsoft monitors such feedbacks. That's from the ribbon Help->Feedback->Report a problem.

      • JerryDNYC's avatar
        JerryDNYC
        Copper Contributor
        Sep 28, 2023
        I sent feedback four days ago and it has not been touched! Very disappointed. I usually get a response within a few days. I didn't see the problem until Version 2310 Build 16.0.16907.20000 64-bit, and just updated to Version 2310 Build 16.0.16924.20002 and the problem persists.
        Very frustrating as I have a template that uses the FRED API to pull in financial data and not only is it now useless, but all the workbooks that use it are as well!

Resources