Home

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%20noopener%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
tim71
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies