Forum Discussion
Solved
New dynamic array functions not available in latest Excel version
I have Excel Version 1907 (Build 11901.20176) and according to the list of new features
this version should include the new dynamic array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY). But the new function aren't available in my Excel.
Any ideas on this?
Thanks in advance.
Tieme
Today I subscribed to Office 365 home edition from my Windows 10 Pro notebook. I too do not have access to dynamic arrays at this late date. I have Excel 365 64 bit Office Insider Edition (Version 2004 Build 12730.20150 from April 15, 2020). I do not have the SORT function, or other dynamic array functions. I do have access to more modern features such as XLOOKUP.
Prior to signing up to the Office Insider Edition, I did not have the dynamic array functionality. I saw a post that said by signing up their problem was resolved. This did not work for me.
I am from Canada. Has this feature been fully deployed worldwide and if so does anyone have suggestions?
Bob
I also have the problem like Bob_Bachman . I was using the new DA formulas - following an update that went wrong a re-install was necessary of Microsoft 365. It's working now, but anything with FILTER etc is not. The version info is 2004 (Build 12730.20250 Click-to-Run).
Now here is the curious bit: the laptop I use has exactly the same version as above and all of the DA functions work without a problem!
The reinstall on my PC was after all traces of 365 were removed including registry elements.
Any clues as to what's going on would be great. The region can't have anything to do with it as both machines are next to each other.
Frustrating not to have these functions available - particularly as I already had them. they make life so much easier!
Version and build number practically don't matter - code for dynamic arrays is in the builds for a long while and functionality is switched on gradually, mainly depends on channel. Last wave is expected for semi-annual channel in July or so.
Sometimes it's not necessary to upgrade the app to receive the new functionality, it's enough to be online for some while. And perhaps restart the app.
If you don't have dynamic arrays are on monthly or insiders channel, that could be something wrong with licensing engine, or you could be on Win7 for which O365 doesn't support new functionality due to end of Win7 support, or that could be something wrong on MSFT servers, or like.
Send frowns.
Enjoy the new functionality. As good as they are, the new functions are only part of the story. Instead of array formulae being the exception as in normal spreadsheet development, it is now rare that one needs to use anything but array formulas. One's whole mindset can change and copying single cell formulas becomes a thing of the past!
PeterBartholomew1 Grosner Detlef_Lewin
I installed the latest insider update (I'm om Office Pro Plus and had to update through Office deployment) and now the new (stunning) functionality is available.
Thanks for your support.
With help from MS technical support I was able to solve this.
I wanted to use Excel’s dynamic array functions (e.g. Filter(), RandArray()).
I am an Office 365 Home Subscriber.
I was using version 1907 Build 11901.20176.
Per MS support suggestion, I joined Insider and subscribed to the insider newsletter.
It took about 10 minutes but eventually, new updates became available to Excel. (File->Account->Office Updates).
After downloading the updates, I closed and restarted Excel.
The functions are now available to me.
Detlef_Lewin Thanks, that explains it.
