Forum Discussion
New dynamic array functions not available in latest Excel version
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.
Interesting. "Something could be wrong with the licensing engine..." seems highly likely. How can this be fixed? Send frowns - I guess this is will only work if enough of us do it!
The other point: Win7 (no, on win10). Restart app - I'll keep trying!
- Well, well, well... kept trying and suddenly things are now working. Full suite of DA formulas without any more updates or downloads. Spot on SergeiBaklan, Thanks!
The problem magically went away for me within one week of my post after a new Office Update came in. I see that your build looks more up to date than mine, so I am totally confused.
Bob_Bachman Sounds like I need to wait for the next update. Only a few weeks...!
