Dynamic arrays and Excel version.

Occasional Contributor

From this thread, "Dynamic Arrays is now available to Office 365 users on all endpoints."


I would like to know if dynamic arrays are supported in single version of Excel such as Excel 2016, 2019, etc. Is there a version/build table to check that?

1 Reply
best response confirmed by Tie CHENG (Occasional Contributor)


No, dynamic arrays are only for Office 365 subscribers. Perhaps they will be available in coming Excel 2022.