Forum Discussion
Error using Filterxml and Webservice functions
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
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.
- SergeiBaklanApr 28, 2021Diamond Contributor
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.
- ermendiola0901Apr 29, 2021Copper ContributorHi@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.- SergeiBaklanApr 30, 2021Diamond Contributor
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-2fdf5dbf61d8
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.