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.

     

Bob_Bachman's avatar
Bob_Bachman
Copper Contributor
Apr 15, 2020

Today I subscribed to Office 365 home edition from my Windows 10 Pro notebook. I too do not have access to dynamic arrays at this late date. I have Excel 365 64 bit Office Insider Edition (Version 2004 Build 12730.20150 from April 15, 2020). I do not have the SORT function, or other dynamic array functions. I do have access to more modern features such as XLOOKUP.

 

Prior to signing up to the Office Insider Edition, I did not have the dynamic array functionality. I saw a post that said by signing up their problem was resolved. This did not work for me.

 

I am from Canada. Has this feature been fully deployed worldwide and if so does anyone have suggestions?

 

Bob