Dynamic Arrays

Copper Contributor

Hi,

I have an E3 O365 subscription and my Office version is:

1812 (11126.20266 Click to Run) Monthly Channel (Targeted).

I deliver Excel training and I would like to show the new dynamic arrays however I do not have these. I tried everything I have found online but alas, no dynamic arrays with the spilling.

What can I do?

 

Thx in adv!

 

Regards,

Raoul

5 Replies

Hi Raoul,

 

So far Dynamic Arrays are only for Insider Fast users. How to join being on business (E3) subscription is here https://support.office.com/en-us/article/how-office-365-commercial-customers-can-get-early-access-to...

 

Hi Raoul,

Welcome to the family :)

Ever looked at youtube video on certain topics?

Additionally i picked up some good address for you:

https://www.excelcampus.com/functions/dynamic-array-formulas-spill-ranges/

 

Have a good sunday,

greets from Eva.

Hi Sergei,

 

Any idea dynamic arrays are available to the public?

I am a little hasitant to perform the steps outlined in the article you mention.

 

Regards,

Raoul

I know that it does, I've seen hours of video content already but now I want it myself :)

Hi Raoul,

 

Nope, I've never seen Microsoft shared such plans.

 

If you are on Monthly Targeted (former Insides Slow) from Office 365 administration point of view you shall be able to install Insider Fast as well. Installation itself is quite straightforward.

 

Main issue, especially in corporate environment, is compatibility if you fully shift on Insider Fast. As for me, I'm also on E3 and Monthly Targeted on my main Win10 corporate PC. On that same PC I installed Hyper-V virtual machine with Insider Fast office. Here are some administrative rights and licensing issues, but in general everything is solvable.