As title, use the=FILTERXML (WEBSERVICE (" http://fanyi.youdao.com/translate? & I="& amp; $A1 & amp;" & Doctype=xml& Version "), "//translation") to translate the word, was used well, about translation of more than one thousand later, then use this function is useless, all show # VALUE! , the original has been translated using FORTRAN term again also becomes a # VALUE! , restart Exel also useless, he suggests that WEBSERVICE is disabled, I ordered to enable no matter use,

As shown in figure, in column B is the translation good results, and B1 cells is I once again after the operation show # VALUE! ,
Does anyone know this is how to return a responsibility

CodePudding user response:

As if the translation website is so limited, don't let have been free to use,