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

1 Reply

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

Related Conversations