SOLVED

Availability of Dynamic Array Formulas In Temporary Hybrid MS 365 Online and Office 2016 Desktop

%3CLINGO-SUB%20id%3D%22lingo-sub-1768991%22%20slang%3D%22en-US%22%3EAvailability%20of%20Dynamic%20Array%20Formulas%20In%20Temporary%20Hybrid%20MS%20365%20Online%20and%20Office%202016%20Desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768991%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20employer%20is%20migrating%20everyone%20to%20MS%20365%20Online%20and%20desktop%20in%20a%202-step%20process%2C%20implementing%20the%20online%20version%20in%20January%202021%20and%20then%20the%20desktop%20version%20in%20June%202021.%26nbsp%3B%20My%20question%20is%20that%20I'm%20anxious%20to%20have%20access%20to%20Excel's%20great%20new%20Dynamic%20Array%20formulas%20in%20the%20interim%20once%20we%20have%20the%20online%20version%20available.%26nbsp%3B%20Will%20I%20be%20able%20to%20do%20that%20with%20files%20in%20Excel%202016%20and%20Excel%20365%20online%20available%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1768991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1769013%22%20slang%3D%22en-US%22%3ERe%3A%20Availability%20of%20Dynamic%20Array%20Formulas%20In%20Temporary%20Hybrid%20MS%20365%20Online%20and%20Office%202016%20Desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1769013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F828062%22%20target%3D%22_blank%22%3E%40Steve1330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%2C%20dynamic%20arrays%20in%20not%20included%20into%202016.%20With%20same%20account%20you'll%20have%20access%20to%3C%2FP%3E%0A%3CP%3EExcel%202016%20-%20all%20functionality%20except%20newly%20introduced%20in%20recent%20couple%20of%20years%2C%20like%20DA%3C%2FP%3E%0A%3CP%3EExcel%20365%20Online%20-%20limited%20set%20of%20functionality%2C%20but%20includes%20modern%20one%20as%20DA.%20No%20VBA%20but%20Office%20Scripts%3C%2FP%3E%0A%3CP%3EExcel%20365%20Desktop%20-%20full%20functional%20office%2C%20exact%20set%20of%20functionality%20above%20basic%20(DA%20is%20basic%20here)%20depends%20on%20your%20license%20and%20channel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

My employer is migrating everyone to MS 365 Online and desktop in a 2-step process, implementing the online version in January 2021 and then the desktop version in June 2021.  My question is that I'm anxious to have access to Excel's great new Dynamic Array formulas in the interim once we have the online version available.  Will I be able to do that with files in Excel 2016 and Excel 365 online available?

2 Replies
Highlighted
Best Response confirmed by Steve1330 (New Contributor)
Solution

@Steve1330 

No, dynamic arrays is not included into 2016. With same account you'll have access to

Excel 2016 - all functionality except newly introduced in recent couple of years, like DA

Excel 365 Online - limited set of functionality, but includes modern one as DA. No VBA but Office Scripts

Excel 365 Desktop - full functional office, exact set of functionality above basic (DA is basic here) depends on your license and channel.

Highlighted