When will the dynamic arrays be available in Office 365 Pro Plus?

New Contributor

The dynamic arrays were released for the people in the Office Insider program in 2019. However, these formulae are not available in the Version 1908 (Build 11929.20838). It is the semi-annual enterprise channel.

Does anyone know when these formulae will be released in the semi-annual enterprise channel?

2 Replies

@Rushabh_Doshi Hello, see this post.

 

"March 31st 2020 Update
Dynamic Arrays is now available to Office 365 users on all endpoints, with the exception of users on the Semi-Annual channel. It will be available to users in Semi-Annual (Targeted) channel starting mid April 2020."

 

https://techcommunity.microsoft.com/t5/excel-blog/preview-of-dynamic-arrays-in-excel/ba-p/252944 

 

Reach out to the Program Manager Joe and perhaps you'll get an updated status.

@ChristianBergstrom 

Thanks for the link.

The office version I am running is 1908. (Build 11929.20838 Click-to-Run)

Semi-Annual Enterprise Channel.

Maybe that's why the dynamic array formulae do not work in this version.

I will try and reach out to the program manager for an update.