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

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.