Apr 26 2021 10:55 PM
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.
Apr 27 2021 03:20 AM
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
Apr 27 2021 03:25 AM
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
Apr 28 2021 05:18 AM
Apr 28 2021 06:49 AM
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.
Apr 29 2021 02:44 PM
Apr 30 2021 06:21 AM
Not sure how did you uninstall, in this case clean uninstallation is required instructions are here https://support.microsoft.com/en-us/office/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5d...
Office 365 could be online only, could be with desktop applications, it depends on your subscription. If Excel Desktop is included in your subscription, you need to make clean uninstall of 2019 (and 365 if you tried to install it), and after that to install Office 365 desktop applications from scratch.