Forum Discussion
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....
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().
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.
- Issue resolved 🙂
I'd recommend to send a frown, Microsoft monitors such feedbacks. That's from the ribbon Help->Feedback->Report a problem.
- 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!Don't expect any answer on feedback. That only means they will find that the problem exists and put it on radar. When it'll be fixed depends on current budget, Excel team loading and prioritization.
Some answer if only you are on paid support.
- Given the feedback on Aug 23 only
