Excel Dynamic Arrays released in Monthy Channel 1907 ?

%3CLINGO-SUB%20id%3D%22lingo-sub-779308%22%20slang%3D%22en-US%22%3EExcel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779308%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CFONT%3EHi%2C%20%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EI%20just%20updated%20my%20Office%20365%20ProPlus%20to%20version%201907%20Build%2011901.20176%20(this%20is%20shown%20under%20%22account%22).%20%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EAccording%20to%20%3CA%20title%3D%22What's%20New%20in%20Office%20365%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhat-s-new-in-office-365-95c8d81d-08ba-42c1-914f-bca4603e1426%3Fomkt%3Den-001%26amp%3Bui%3Den-US%26amp%3Brs%3Den-001%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhat's%20New%20in%20Office%20365%3C%2FA%3E%3C%2FFONT%3E%3CFONT%3Ethe%20dynamic%20array%20functions%20should%20be%20included.%3CBR%20%2F%3EHowever%2C%20Excel%20doesn't%20recognize%20them%20(filter%2C%20sort%2C%20unique...).%20%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EI%20checked%20the%20new%20function%20that%20was%20described%20with%20%22no%20more%20bouncing%20to%20the%20browser%22%20and%20I%20find%20the%20new%20option%20%22link%20handling%22.%20So%20my%20installation%20should%20be%20fine.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EWhat%20goes%20wrong%20with%20the%20new%20functions%3F%20Do%20I%20need%20to%20activate%20them%20somehow%3F%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThanks%20%26amp%3B%20Regards%3CBR%20%2F%3EMichael%3CBR%20%2F%3E%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781356%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781356%22%20slang%3D%22en-US%22%3Eme%20neither%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781591%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384361%22%20target%3D%22_blank%22%3E%40Michael_Mertens%3C%2FA%3EMy%20monthly%201907%20DAFs%20are%20working%20just%20fine.%20Had%20them%20about%20a%20month%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781762%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781762%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385024%22%20target%3D%22_blank%22%3E%40rmose7203%3C%2FA%3E%2C%20then%20you%20probably%20are%20in%20the%20monthly%20targeted%20channel%2C%20not%20the%20monthly%20channel%2C%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782001%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384361%22%20target%3D%22_blank%22%3E%40Michael_Mertens%3C%2FA%3E%26nbsp%3B%20We%20had%20the%20same%20though%20re%201907%20on%20monthly%20on%20Monday%20when%20we%20downloaded%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20got%20in%20touch%20with%20one%20of%20the%20folks%20from%20MS%20(our%20team%20is%20working%20on%20an%20Excel%20add-on%20using%20DA)%20and%20were%20told%20that%20it%20is%20available%20now%20on%20the%20Monthly%20(Targeted)%20Channel%20and%20considered%20a%20'release%20candidate'%20for%20the%20regular%20monthly.%20However%2C%20there%20is%20not%20an%20exact%20ETA%20yet%20as%20they%20are%20still%20validating%20quality%2Fbugs%20for%20the%20wider%20rollout.%26nbsp%3B%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20it%20certainly%20sounds%20like%20they%20do%20understand%20that%20everyone%20is%20waiting%20on%20it%2C%20so%20crossing%20our%20fingers%20that%20it%20won't%20be%20too%20much%20longer...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782068%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782068%22%20slang%3D%22en-US%22%3E%3CP%3Eok%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385130%22%20target%3D%22_blank%22%3E%40wanderslth%3C%2FA%3E%2C%20thanks.%20It%20seems%20that%20just%20the%20what's-new-document%20is%20wrong%20(the%20link%20in%20my%20initial%20post).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782248%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384361%22%20target%3D%22_blank%22%3E%40Michael_Mertens%3C%2FA%3EYes%2C%20that's%20correct.%20I%20discovered%20today%20it%20used%20to%20be%20called%20the%20Insider%20Slow%2C%20and%20hence%20why%20it%20is%20still%20treated%20as%20an%20insider%20account.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782640%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384361%22%20target%3D%22_blank%22%3E%40Michael_Mertens%3C%2FA%3EI%20also%20have%20the%201907%20bld%2011901.20176%20version%20of%20Office%20365%20and%20have%20neither%20DAF%20or%20the%20new%20link%20handling%20file%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782661%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385328%22%20target%3D%22_blank%22%3E%40rbert5949%3C%2FA%3EYou%20would%20only%20get%20the%26nbsp%3B%20DAF%20if%20you%20are%20on%20one%20of%20the%20Insider%20channels.%20There%20are%20two%20types.%20Your%20version%20of%20excel%20would%20have%20to%20be%20registered%20for%20monthly%20updates%20as%20a%20Monthly%20(Targeted)%20Channel.%20This%20is%20also%20considered%20an%20Insider%20channel%20as%20it%20was%20previously%20called%20Insider%20Slow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782743%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782743%22%20slang%3D%22en-US%22%3EThank%20you.%20I%20have%20signed%20up%20for%20the%20Office%20Insider.%20I've%20heard%20about%20this%20for%20so%20long%20that%20I%20have%20to%20give%20it%20a%20try.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782914%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782914%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20-%20related%20to%20ProPlus%20Monthly%201907%20(%3CSPAN%3EBuild%2011901.20176%20too)%20-%20but%20not%20Michaels's%20issue..%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%22%3CA%20href%3D%22https%3A%2F%2Foffice-watch.com%2F2019%2Fopening-office-file-hyperlinks-in-office-desktop-apps-not-browser%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EOpening%20Office%20file%20hyperlinks%20in%20Office%20desktop%20apps%20not%20browser%3C%2FA%3E%22%20doesn't%20appear%20for%20me...%20what%20about%20you%3F%20I%20have%20been%20waiting%20for%20this%20for%20a%20while.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20to%20hijack%20your%20thread%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384361%22%20target%3D%22_blank%22%3E%40Michael_Mertens%3C%2FA%3E...%20but%20perhaps%20other%20folks%20here%20could%20check%20and%20advise%3F%20Unsure%20if%20this%20has%20been%20blocked%20from%20being%20enabled%20or%20something%2C%20would%20be%20useful%20setting%20to%20apply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Joe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783595%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139376%22%20target%3D%22_blank%22%3E%40Joe%20McGiven%20Corban%3C%2FA%3E%26nbsp%3B%20Go%20into%20backstage%2C%20FILE%20--%26gt%3B%20OPTIONS%20--%26gt%3BADVANCED%20--%26gt%3BLINK%20HANDLING%20and%20check%20the%20tick%20box%20there.%20If%20that%20option%20isn't%20there%2C%20do%20an%20update%20of%20your%20Office%2C%20and%20if%20still%20not%20there%20then%20maybe%20it%20hasn't%20been%20pushed%20to%20your%20version%20as%20yet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784794%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784794%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385024%22%20target%3D%22_blank%22%3E%40rmose7203%3C%2FA%3E%26nbsp%3B-%20yeah%2C%20definitley%20not%20there%2C%20and%20for%20our%20ProPlus%20monthly%20version%20it%20should%20be.%20Very%20odd...%20everyone%20else%20has%20it%3F%20Not%20a%20single%20other%20soul%20out%20there%20on%2011901.20176%20has%20it%20missing%3F%20Would%20be%20great%20to%20test%2C%20but%20worse%20case%20I%20can%20wait%20till%201908%20and%20if%20still%20missing%20then%20I'll%20raise%20a%20ticket%20with%20MS.%20Cheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20556px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125338iD94B44535EAE5C87%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22No%20Link%20Handling.JPG%22%20title%3D%22No%20Link%20Handling.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842323%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Arrays%20released%20in%20Monthy%20Channel%201907%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842323%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20the%20August%20version%20now%2C%20still%20without%20Dynamic%20Arrays.%20And%20the%20%22readme%22%20for%20July%20is%20still%20unchanged%2C%20listing%20the%20new%20functions.%3C%2FP%3E%3CP%3EStrange...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi,
 
I just updated my Office 365 ProPlus to version 1907 Build 11901.20176 (this is shown under "account").
 
According to What's New in Office 365 the dynamic array functions should be included.
However, Excel doesn't recognize them (filter, sort, unique...).
 
I checked the new function that was described with "no more bouncing to the browser" and I find the new option "link handling". So my installation should be fine.
 
What goes wrong with the new functions? Do I need to activate them somehow?
 
Thanks & Regards
Michael
13 Replies

@Michael_MertensMy monthly 1907 DAFs are working just fine. Had them about a month now

@rmose7203, then you probably are in the monthly targeted channel, not the monthly channel, correct?

@Michael_Mertens  We had the same though re 1907 on monthly on Monday when we downloaded it.

 

We got in touch with one of the folks from MS (our team is working on an Excel add-on using DA) and were told that it is available now on the Monthly (Targeted) Channel and considered a 'release candidate' for the regular monthly. However, there is not an exact ETA yet as they are still validating quality/bugs for the wider rollout.  :(

 

But, it certainly sounds like they do understand that everyone is waiting on it, so crossing our fingers that it won't be too much longer...

ok, @wanderslth, thanks. It seems that just the what's-new-document is wrong (the link in my initial post).

@Michael_MertensYes, that's correct. I discovered today it used to be called the Insider Slow, and hence why it is still treated as an insider account.

@Michael_MertensI also have the 1907 bld 11901.20176 version of Office 365 and have neither DAF or the new link handling file option.

@rbert5949You would only get the  DAF if you are on one of the Insider channels. There are two types. Your version of excel would have to be registered for monthly updates as a Monthly (Targeted) Channel. This is also considered an Insider channel as it was previously called Insider Slow.

Thank you. I have signed up for the Office Insider. I've heard about this for so long that I have to give it a try.

Hi all - related to ProPlus Monthly 1907 (Build 11901.20176 too) - but not Michaels's issue..

 "Opening Office file hyperlinks in Office desktop apps not browser" doesn't appear for me... what about you? I have been waiting for this for a while.

 

Sorry to hijack your thread here @Michael_Mertens... but perhaps other folks here could check and advise? Unsure if this has been blocked from being enabled or something, would be useful setting to apply.

 

Thanks, Joe

@Joe McGiven Corban  Go into backstage, FILE --> OPTIONS -->ADVANCED -->LINK HANDLING and check the tick box there. If that option isn't there, do an update of your Office, and if still not there then maybe it hasn't been pushed to your version as yet.

@rmose7203 - yeah, definitley not there, and for our ProPlus monthly version it should be. Very odd... everyone else has it? Not a single other soul out there on 11901.20176 has it missing? Would be great to test, but worse case I can wait till 1908 and if still missing then I'll raise a ticket with MS. Cheers

 

No Link Handling.JPG

We have the August version now, still without Dynamic Arrays. And the "readme" for July is still unchanged, listing the new functions.

Strange...