Forum Discussion
New dynamic array functions not available in latest Excel version
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!
Great to know it is sorted out now. Yes, adding of new functionality is not necessary requires the update, code is in the build already. Excel restart could help since with that license engine checks your credentials and in which pool you are in cloud, and switches new functionality ON if you appear in records. But in general restart is also not required, it's enough to be online long enough.
I very simplified in above, only to illustrate an idea.