Share via

New Dynamic Array functions and new Calculation Engine in Excel

Anonymous
2019-09-17T05:04:35+00:00

I have Office 365 ProPlus with Semi-annual channel (Targeted). When will the new Dynamic Array functions of Excel be available to me ?  (Considering my admin does not want to change the Update channel or put me into Insider Programme).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-09-17T09:06:58+00:00

Hi Prasanta Panigrahi,

What I can know is that Monthly Channel (Targeted) (formerly Insider Slow) has released Dynamic arrays function in Excel. I've also tested on my Excel (Monthly Channel), but this feature isn't available for me.

From this article: Dynamic Arrays and New Functions in Excel, we can know that Dynamic Arrays is available to Insiders on iOS and Android running the July update.

Do you mean this feature is available on Excel apps (Semi-annual channel (Targeted)) in your mobile devices now?

Best Regards,

Hugo

Was this answer helpful?

0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-17T11:54:12+00:00

    Hi Prasanta Panigrahi,

    Thanks for your reply.

    Now I would like to suggest you enjoy the new feature on Excel app on your Android device and wait for the good news of the feature released on Excel on your Windows.

    Hoping this feature will be released to all platforms as soon as possible.

    Best Regards,

    Hugo

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-09-17T11:37:41+00:00

    Hi Hugo,

    You are right. For the Excel app in my Android device, I checked and found that I have enrolled into 'Insider Program'. That is why, I am getting this function in my mobile device, but not in desktop environment.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-09-17T08:39:07+00:00

    Hi Hugo,

    But these functions are available even on Excel apps in mobile devices i.e. Android and IOS. And I have heard, it is  also available on Monthly Channel. So, quite surprising that its held back only on a particular update channel.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-09-17T08:26:11+00:00

    Hi Prasanta Panigrahi,

    I'm afraid we also cannot tell you the released time of the Dynamic Array function in Semi-annual Channel (Targeted) channel because of the limited resources on our side.

    We can understand you feeling, and we are also hoping the released of the new feature in all platforms, but it is currently only available for testing in insider channel, the Dynamic array function will be released to all platforms once it is perfect.

    We appreciate your time and understanding.

    Best Regards,

    Hugo

    Was this answer helpful?

    0 comments