Dynamic arrays not working on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-479465%22%20slang%3D%22en-US%22%3EDynamic%20arrays%20not%20working%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479465%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%20I%20am%20a%20Mac%20user%20and%20wonder%20if%20anyone%20has%20encountered%20issues%20on%20unable%20to%20use%20the%20new%20formulas.%20I%20deliberately%20subscribe%20to%20Office%20365%20to%20be%20able%20to%20use%20the%20new%20formulas%20as%20it%20would%20save%20me%20months%20on%20a%20database%20project%20i%20am%20using%20...%20when%20i%20try%20to%20use%20sort%20or%20filter%20it%20says%20the%20function%20is%20invalid.%20It%20would%20be%20great%20if%20someone%20could%20shed%20some%20light%20on%20this%20as%20i%20am%20contemplating%20on%20buying%20a%20PC%20just%20for%20the%20project%2C%20but%20it%20will%20be%20costly.%20Thanks%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-479465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479502%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20arrays%20not%20working%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324840%22%20target%3D%22_blank%22%3E%40tim71%3C%2FA%3E%26nbsp%3B%2C%20to%20my%20knowledge%20DA%20are%20only%20for%20Windows%2C%20only%20for%20Excel%20365%20and%20only%20for%20Office%20Insiders.%20So%20far.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20better%20to%20ask%20in%20comments%20to%20this%20blog%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Dynamic-Arrays-in-Excel%2Fba-p%2F252944%2Fpage%2F2%23comments%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Dynamic-Arrays-in-Excel%2Fba-p%2F252944%2Fpage%2F2%23comments%3C%2FA%3E%20with%20direct%20%40mention%20of%20Joe%20(author%20of%20the%20blog%20and%20manager%20of%20this%20program).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-868749%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20arrays%20not%20working%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868749%22%20slang%3D%22en-US%22%3E%3CP%3Ejust%20subscribed%20to%20office%20365%20for%20the%20sole%20purpose%20of%20dynamic%20array%20functions%20...%20i%20am%20on%20mac%20and%20to%20my%20utter%20surprise%20%2C%20it%20does%20not%20work%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20on%20office%20365%20-%20Excel%2016.29.1%20(19091700)%20for%20mac%20%2C%20i%20thought%20dynamic%20functions%20should%20be%20present%20on%20excel%20for%20mac%20since%20release%2016.27.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPls%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-868785%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20arrays%20not%20working%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868785%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412956%22%20target%3D%22_blank%22%3E%40yeba456%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVersion%20number%20practically%20doesn't%20matter%2C%20new%20functionality%20is%20distributed%20by%20channels.%20Dynamic%20Arrays%20were%20introduced%20with%20version%2016.27%20on%20Insiders%20Slow%20channel%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Freleasenotes%2Fmac%2Fslow%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsider.office.com%2Fen-us%2Freleasenotes%2Fmac%2Fslow%3C%2FA%3E.%20If%20you%20are%20not%20insider%20-%20you%20don't%20have%20such%20functionality%20even%20if%20your%20build%20has%20higher%20number.%20Dynamic%20Arrays%20are%20only%20for%20insiders%20so%20far%2C%20both%20on%20Mac%20and%20Windows.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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/pag... 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 

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