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

Copper 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."




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


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.