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. Ce...
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.
- Hi@sergei baklan,
Actually I tried to uninstall office 365 and install it again for 5 times. It seems that office 365 is a web version and when you click at the upper tool bar "use desktop" it will launch office 2019 desktop version. In recognize webservice and filterxml in office 2019 but the problem is it has an error value.
