Forum Discussion

Michael_Mertens's avatar
Michael_Mertens
Copper Contributor
Jul 30, 2019

Excel Dynamic Arrays released in Monthy Channel 1907 ?

Hi,
 
I just updated my Office 365 ProPlus to version 1907 Build 11901.20176 (this is shown under "account").
 
According to https://support.office.com/en-us/article/what-s-new-in-office-365-95c8d81d-08ba-42c1-914f-bca4603e1426?omkt=en-001&ui=en-US&rs=en-001&ad=US 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_Mertens's avatar
    Michael_Mertens
    Copper Contributor
    Sep 07, 2019

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

    Strange...

  • Joe McGiven Corban's avatar
    Joe McGiven Corban
    Brass Contributor
    Aug 01, 2019

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

     "https://office-watch.com/2019/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

    • rmose7203's avatar
      rmose7203
      Copper Contributor
      Aug 01, 2019

      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.

      • Joe McGiven Corban's avatar
        Joe McGiven Corban
        Brass Contributor
        Aug 01, 2019

        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

         

  • rbert5949's avatar
    rbert5949
    Copper Contributor
    Jul 31, 2019

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

    • rmose7203's avatar
      rmose7203
      Copper Contributor
      Jul 31, 2019

      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.

      • rbert5949's avatar
        rbert5949
        Copper Contributor
        Jul 31, 2019
        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.
      • rmose7203's avatar
        rmose7203
        Copper Contributor
        Jul 31, 2019

        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.

Resources