Forum Discussion
Dynamic arrays not working on Mac
tim71 , to my knowledge DA are only for Windows, only for Excel 365 and only for Office Insiders. So far.
However, better to ask in comments to this blog https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Dynamic-Arrays-in-Excel/ba-p/252944/page/2#comments with direct @mention of Joe (author of the blog and manager of this program).
just subscribed to office 365 for the sole purpose of dynamic array functions ... i am on mac and to my utter surprise , it does not work ...
i am on office 365 - Excel 16.29.1 (19091700) for mac , i thought dynamic functions should be present on excel for mac since release 16.27.
Pls help
- SergeiBaklanSep 21, 2019Diamond Contributor
Version number practically doesn't matter, new functionality is distributed by channels. Dynamic Arrays were introduced with version 16.27 on Insiders Slow channel https://insider.office.com/en-us/releasenotes/mac/slow. If you are not insider - you don't have such functionality even if your build has higher number. Dynamic Arrays are only for insiders so far, both on Mac and Windows.