Forum Discussion
Error using Filterxml and Webservice functions
Hi Guys,
Good day.
I need help regarding the use of Filterxml and Webservice functions because I followed the right syntax for the formula but it doesn't give the right output.
Filterxml
1. Cell A1 entered : 2,5,8,9
2. In Cell B2 converted cell A1 to XML using this formula : = "<Start><Num>"&substitute(A1,",","</Num><Num>")&"</Num></Start>"
3. In Cell C3 = Filterxml(B2,"//Num")
4. Answer : 2 only.
Webservice
1. In Cell D1 copy and paste a url from a website
2. In E1 entered this : =webservice(D1) and the output is Value error
Please help.
6 Replies
WEBSERVICE() - depends on URL. Please check here why #VALUE could be returned WEBSERVICE function - Excel (microsoft.com)
How to use - How to use the Excel WEBSERVICE function | Exceljet
FILTERXML returns an array. If you are on Excel which doesn't support dynamic arrays you shall use Ctrl+Shift+Enter, otherwise it returns only first element of the array
- Hi,
Thanks for your help. I'm currently using office 365 and office 2019 both of them installed at the same time when I renewed my subscription. Do you have any idea why am I not get dyanamic array support because I already tried control shift enter and it returns one value only.I'm not sure you may install desktop version of 365 and Excel 2019 in parallel on one machine. Perhaps you work with 2019 which doesn't support dynamic arrays.
