Forum Discussion
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 months on a database project i am using ... when i try to use sort or filter it says the function is invalid. It would be great if someone could shed some light on this as i am contemplating on buying a PC just for the project, but it will be costly. Thanks in advance
3 Replies
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
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.
