Home

Dynamic Arrays not available in Office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-528737%22%20slang%3D%22en-US%22%3EDynamic%20Arrays%20not%20available%20in%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20an%20Office%20365%20Subscriber%20and%20an%20Office%20Insider%20too%2C%20what%20happened%20suddenly%20that%20I%20am%20not%20able%20to%20use%20the%20Dynamic%20Array%20functions%20like%20Sort%2C%20Sortby%2C%20Randarray%20%3F%20the%20Excel%20365%20behaves%20like%20the%20older%20one%2C%20I%20have%20the%20latest%20updates%20too.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-528737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528830%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%20not%20available%20in%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F194466%22%20target%3D%22_blank%22%3E%40Soumalya%20Biswas%3C%2FA%3E%26nbsp%3B%2C%20from%20you%20screenshort%20it's%20not%20clear%20do%20you%20really%20have%20no%20DA%20functions%20or%20not.%20If%20to%20enter%20such%20way%20any%20other%2C%20let%20say%20%3Dif%2C%20you%20also%20have%20same%20error.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20start%20typing%2C%20e.g.%20%3Dsor%2C%20do%20you%20see%20SORT%20and%20SORTBY%20in%20the%20list%20of%20suggested%20functions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528870%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Arrays%20not%20available%20in%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528870%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20was%20typing%20and%20looking%20for%20sort%2C%20sortby%2C%20sequence%2C%20randarray%20i%20wasnt%20getting%20them%20but%20after%20several%20fresh%20installations%20and%20sigin%20it%20finally%20worked%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Soumalya Biswas
New Contributor

I am an Office 365 Subscriber and an Office Insider too, what happened suddenly that I am not able to use the Dynamic Array functions like Sort, Sortby, Randarray ? the Excel 365 behaves like the older one, I have the latest updates too.

2 Replies

@Soumalya Biswas , from you screenshort it's not clear do you really have no DA functions or not. If to enter such way any other, let say =if, you also have same error.

 

When you start typing, e.g. =sor, do you see SORT and SORTBY in the list of suggested functions?

When i was typing and looking for sort, sortby, sequence, randarray i wasnt getting them but after several fresh installations and sigin it finally worked@Sergei Baklan 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies