Forum Discussion
datamanjp
Aug 17, 2024Copper Contributor
TRANSLATE() function not available in Excel
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel. My Specs: Windows 11 ARM 64bit Excel version 2409 Insider Beta Channel OS and MS365 both fully updated...
- Aug 17, 2024The specs look good. The reason you don't have TRANSLATE and DETECTLANGUAGE is because new features are rolled out in waves each week to the Insider Beta Channel (It seems to be Tuesday or Wednesday usually). Not everyone on the insider channel has the functions currently.
For example, PIVOTBY/GROUPBY were announced in November 2023, but I did not receive them until January. When Python in Excel was announced I received it in an update two weeks later. It varies.
I know the wait is no fun when there are cool new features coming out, but you'll get them soon enough.
SergeiBaklan
Aug 17, 2024Diamond Contributor
As a comment, new feature could appear even without weekly Beta update. Code is already within the build. If no changes which could affect functionality it could be activated any time. Or deactivated for all users, includes ones who had it, if critical bug appears.
The only we are to be on internet.
But yes, usually it is synced with new builds publishing.
datamanjp
Aug 17, 2024Copper Contributor
Thansk Patrick2788 and SergeiBaklan ! That makes sense.