SOLVED
Home

Dynamics Arrays & Array Formulas in Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-790414%22%20slang%3D%22en-US%22%3EDynamics%20Arrays%20%26amp%3B%20Array%20Formulas%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790414%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20have%20any%20clue%20as%20to%20when%20or%20even%20%3CEM%3Eif%3C%2FEM%3Eexcel%20online%20(the%20javascript%2Fweb%20version%20of%20excel)%20will%20be%20getting%20dynamics%20arrays%20and%20array%20functions%20(especially%20the%20new%20ones%20e.g%20UNIQUE)%3F%26nbsp%3B%20Right%20now%20they%20definitely%20do%20not%20work%20in%20excel%20online%20for%20my%20tenant%2C%20and%20I%20cannot%20find%20any%20info%20about%20if%20they%20ever%20will.%26nbsp%3B%20The%20current%20behaviour%20when%20opening%20a%20document%20already%20using%20dynamic%20arrays%20or%20the%20new%20functions%20is%20very%20counter-intuitive%20and%20sometimes%20fully%20dysfunctional.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20adopt%20the%20hell%20out%20of%20these%2C%20but%20can't%20even%20gauge%20when%2Fif%20I%20should.%26nbsp%3B%20%26nbsp%3BIn%20my%20opinion%20you%20should%20be%20able%20to%20open%20any%20excel%20document%20in%20both%20apps%20so%20long%20as%20they%20are%20both%20using%20only%20cell%20functions%20because%20the%20alternative%20is%20very%20confusing%20for%20average%20users%2C%20so%20this%20stops%20me%20from%20using%20them%20except%20for%20pet%20cases.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-790414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edynamic%20arrays%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796217%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamics%20Arrays%20%26amp%3B%20Array%20Formulas%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131202%22%20target%3D%22_blank%22%3E%40Myles%20Gallagher%3C%2FA%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EThere%20will%20be%20no%20delay%20on%20Excel%20Online%20getting%20Dynamic%20Arrays.%3C%2FSPAN%3E%20When%20ready%20for%20General%20Availability%2C%20Dynamic%20Arrays%20will%20go%20to%20all%20endpoints%20at%20roughly%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796346%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamics%20Arrays%20%26amp%3B%20Array%20Formulas%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9664%22%20target%3D%22_blank%22%3E%40Joe%20McDaid%3C%2FA%3E%26nbsp%3BGreat%20to%20hear!%26nbsp%3B%20I%20suppose%20the%20strangeness%20I%20am%20experiencing%20has%20to%20do%20with%20me%20being%20on%20the%20%22targeted%22%20release%20ring.%26nbsp%3B%20I%20put%20myself%20in%20it%20within%20my%20tenant%20(without%20putting%20the%20whole%20tenant%20in%20the%20targeted%20ring)%20to%20test%20new%20features%20before%20they%20hit%20the%20general%20group%2C%20but%20maybe%20excel%20online%20is%20not%20in%20sync%20with%20my%20desktop%20apps%20%22new%20features%22.%26nbsp%3B%20Not%20sure%20how%20the%20online%20experience%20schedules%20into%20the%20Microsoft%20release%20rings.%26nbsp%3B%20I%20notice%20SharePoint%20definitely%20seems%20to%20get%20targeted%20updates%20that%20other%20users%20do%20not%20have%2C%20I%20was%20expecting%20the%20office%20web%20apps%20to%20follow%20the%20same%20sort%20of%20schedule.%26nbsp%3B%20Greatly%20looking%20forwards%20to%20GA.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Myles Gallagher
Contributor

Anyone have any clue as to when or even if excel online (the javascript/web version of excel) will be getting dynamics arrays and array functions (especially the new ones e.g UNIQUE)?  Right now they definitely do not work in excel online for my tenant, and I cannot find any info about if they ever will.  The current behaviour when opening a document already using dynamic arrays or the new functions is very counter-intuitive and sometimes fully dysfunctional.

 

I want to adopt the hell out of these, but can't even gauge when/if I should.   In my opinion you should be able to open any excel document in both apps so long as they are both using only cell functions because the alternative is very confusing for average users, so this stops me from using them except for pet cases.

2 Replies
Solution

@Myles Gallagher There will be no delay on Excel Online getting Dynamic Arrays. When ready for General Availability, Dynamic Arrays will go to all endpoints at roughly the same time. 

@Joe McDaid Great to hear!  I suppose the strangeness I am experiencing has to do with me being on the "targeted" release ring.  I put myself in it within my tenant (without putting the whole tenant in the targeted ring) to test new features before they hit the general group, but maybe excel online is not in sync with my desktop apps "new features".  Not sure how the online experience schedules into the Microsoft release rings.  I notice SharePoint definitely seems to get targeted updates that other users do not have, I was expecting the office web apps to follow the same sort of schedule.  Greatly looking forwards to GA.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 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