Forum Discussion
New dynamic array functions not available in latest Excel version
Great to know it is sorted out now. Yes, adding of new functionality is not necessary requires the update, code is in the build already. Excel restart could help since with that license engine checks your credentials and in which pool you are in cloud, and switches new functionality ON if you appear in records. But in general restart is also not required, it's enough to be online long enough.
I very simplified in above, only to illustrate an idea.
SergeiBaklan Hi Sergey, I see you helped some people here to understand why new array functions are not working. Maybe you can help me too? As I can see I am a Microsoft Office 365 ProPlus user (on Windows 10) with Excel Version 1908 (Build 11929.20966 Click and go) Semiannual Enterprise channel (one side note: I am located in Germany) - therefore I was expecting to have array functions on my Excel. Would you have any tips for me? I would highly appreciate your help! Thank you in advance.
Hi Anastasia,
Semi-Annual Enterprise exists in two versions: 1908 and 2002
Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Docs
Dynamic arrays were introduced with bi-annual feature update in July previous year for version 2002 with build Version 2002 (Build 12527.20880) . This part of announcement looks like
you may check here Release notes for Semi-Annual Enterprise Channel releases in 2020 - Office release notes | Microsoft Docs
I'm surprised DA is not fully in Production, but based on above document version 1908 doesn't have it. You may ask your IT to update on 2002 or wait for another feature update, for semi-annual channel it shall be on Jan-Feb this year. Not sure this functionality is planned or not, many chances it shall be deployed on 1908.
I don't think availability depends on locale, functionality shall be deployed for all local versions, the only not at once for all of them.
Woldman Anastasia_Sentyurova SergeiBaklan Bob_Bachman SpreadsheetRon
My Excel 365 doesn't support Dynamic Array formulas like GROUPBY and PIVOTBY. Can anyone let me know to resolve the issue. Thanks
