Home

Dynamic Arrays

%3CLINGO-SUB%20id%3D%22lingo-sub-314279%22%20slang%3D%22en-US%22%3EDynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314279%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20an%20E3%20O365%20subscription%20and%20my%20Office%20version%20is%3A%3C%2FP%3E%3CP%3E1812%20(11126.20266%20Click%20to%20Run)%20Monthly%20Channel%20(Targeted).%3C%2FP%3E%3CP%3EI%20deliver%20Excel%20training%20and%20I%20would%20like%20to%20show%20the%20new%20dynamic%20arrays%20however%20I%20do%20not%20have%20these.%20I%20tried%20everything%20I%20have%20found%20online%20but%20alas%2C%20no%20dynamic%20arrays%20with%20the%20spilling.%3C%2FP%3E%3CP%3EWhat%20can%20I%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%20in%20adv!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ERaoul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314279%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314288%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314288%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Raoul%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20I've%20never%20seen%20Microsoft%20shared%20such%20plans.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20on%20Monthly%20Targeted%20(former%20Insides%20Slow)%20from%20Office%20365%20administration%20point%20of%20view%20you%20shall%20be%20able%20to%20install%20Insider%20Fast%20as%20well.%20Installation%20itself%20is%20quite%20straightforward.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMain%20issue%2C%20especially%20in%20corporate%20environment%2C%20is%20compatibility%20if%20you%20fully%20shift%20on%20Insider%20Fast.%20As%20for%20me%2C%20I'm%20also%20on%20E3%20and%20Monthly%20Targeted%20on%20my%20main%20Win10%20corporate%20PC.%20On%20that%20same%20PC%20I%20installed%20Hyper-V%20virtual%20machine%20with%20Insider%20Fast%20office.%20Here%20are%20some%20administrative%20rights%20and%20licensing%20issues%2C%20but%20in%20general%20everything%20is%20solvable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314286%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314286%22%20slang%3D%22en-US%22%3EI%20know%20that%20it%20does%2C%20I've%20seen%20hours%20of%20video%20content%20already%20but%20now%20I%20want%20it%20myself%20%3A-)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314285%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20dynamic%20arrays%20are%20available%20to%20the%20public%3F%3C%2FP%3E%3CP%3EI%20am%20a%20little%20hasitant%20to%20perform%20the%20steps%20outlined%20in%20the%20article%20you%20mention.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ERaoul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314281%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314281%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Raoul%2C%3C%2FP%3E%3CP%3EWelcome%20to%20the%20family%20%3A)%3C%2FP%3E%3CP%3EEver%20looked%20at%20youtube%20video%20on%20certain%20topics%3F%3C%2FP%3E%3CP%3EAdditionally%20i%20picked%20up%20some%20good%20address%20for%20you%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelcampus.com%2Ffunctions%2Fdynamic-array-formulas-spill-ranges%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excelcampus.com%2Ffunctions%2Fdynamic-array-formulas-spill-ranges%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20good%20sunday%2C%3C%2FP%3E%3CP%3Egreets%20from%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314280%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314280%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Raoul%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20far%20Dynamic%20Arrays%20are%20only%20for%20Insider%20Fast%20users.%20How%20to%20join%20being%20on%20business%20(E3)%20subscription%20is%20here%26nbsp%3B%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-office-365-commercial-customers-can-get-early-access-to-new-office-features-4dd8ba40-73c0-4468-b778-c7b744d03ead%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-office-365-commercial-customers-can-get-early-access-to-new-office-features-4dd8ba40-73c0-4468-b778-c7b744d03ead%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
raouls
New 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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies