Forum Discussion

Copper Contributor

Apr 22, 2019

Dynamic arrays not working on Mac

Dear all, I am a Mac user and wonder if anyone has encountered issues on unable to use the new formulas. I deliberately subscribe to Office 365 to be able to use the new formulas as it would save me ...

excel

Excel on Mac

SergeiBaklan

Diamond Contributor

Apr 22, 2019

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).

yeba456

Copper Contributor

Sep 21, 2019

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

SergeiBaklan
Diamond Contributor
Sep 21, 2019
yeba456

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.