Forum Discussion

Woldman's avatar
Woldman
Iron Contributor
Aug 07, 2019
Solved

New dynamic array functions not available in latest Excel version

I have Excel Version 1907 (Build 11901.20176) and according to the list of https://support.office.com/en-us/article/what-s-new-in-excel-for-office-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73  this vers...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Aug 07, 2019

    Woldman 

    But according to this the new functions are not part of Build 11901.20176.

     

Anastasia_Sentyurova's avatar
Anastasia_Sentyurova
Copper Contributor
Jan 02, 2021

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. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 02, 2021

Anastasia_Sentyurova 

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 02, 2024

    adnanmosingmailcom 

    First please check on which channel you are.

    If you don't have these functions on your channel that's only to wait and install updates regularly and/or shift the channel.

    If that's Beta channel and you still don't have these functions that's only to wait when 100% of Beta users will be covered. My impression it'd done already, but I'm not sure.

    If you are on semi-annual channel that's to wait another couple of years till that channel will be updates with such functionality.

Resources