Does anyone have the Current Version Channel Preview updated after 08/2023?

[awoohaw]

Hello all,
This is my current version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20084) 64-bit

It seems the last update was August 2023, which I think is pretty distant. And I have seen some you tube video posts of functions that work differently particularly the BYROW and BYCOL functions. (I will post the link below the text of the post.)

It seems there is an update coming where you do not need to explicitly state the LAMBDA function as in:

=BYROW(A1:E4,LAMBDA(r,SUM(r)))

and that soon only this will be necessary:

=BYROW(A1:E4,SUM)

Which is much cleaner and easier to follow.

But, I am really confused as when I click on update, the app says i'm up to date, yet the later function syntax does not work.
But, at the same time, I cannot locate that build number in the MS-Excel update release history of the Current Version.

Any thoughts?

PS. Admins if this post should be in another forum please move as you see fit.

Link with new syntax described:

 

[Dave Patton]

I do not have the update.
I can confirm that only the first example works on my system.

I would also like to try the GroupBy and PivotBy functions.

The update information on my system refers to changes from 2022.

Please see www.mrexcel.com/board/threads/dont-have-access-yet-to-pivotby-and-groupby.1249688/

 

[MARK858]

The last update on my 64bit was yesterday (applied it this morning)... still no GroupBy and PivotBy functions or insert checkboxes.

Version Microsoft 365 MSO (Version 2401 Build 16.0.17231.20084) 64-bit, so not so sure about the below but I thought we were already on 2402 on 64bit Beta unless they have taken it back because of recent issues.

It seems the last update was August 2023

The recent Beta builds listed (I think it only shows 32bit versions) are

January 17, 2024
Version 2402 (Build 17315.20000)

January 09, 2024
Version 2402 (Build 17304.20000)

January 03, 2024
Version 2401 (Build 17231.20008)

January 02, 2024
Version 2401 (Build 17228.20000)

December 20, 2023
Version 2401 (Build 17217.20000) (Rolled back)

December 12, 2023
Version 2401 (Build 17204.20000)

 

[Dave Patton]

I have the same version as Mark Version Microsoft 365 MSO (Version 2401 Build 16.0.17231.20084) 64-bit

I am not clear on the logic of the numbering scheme(s). The system shows different numbers in different places.

It may be that we are on the "current channel" and others are on the "beta" channel.
It would be nice to know what is on the updates so that I do not have to check with each update whether or not new features were included.
Many of you experts provide valuable information for Microsoft,

Per Microsoft

"Beta Channel​

We recommend this channel for people who want to try out new features while they’re still in active development, identify issues, and provide feedback. You will receive frequent updates that include new features as well as bug fixes and other updates.

Beta Channel is best suited for people who don’t mind the bit of risk involved in using unsupported builds.

Current Channel (Preview)​

We recommend this channel for customers who want to receive supported builds with less frequent, more stable updates and minimal risk.

New features are released about once per month and may include bug fixes and other updates."

 

[awoohaw]

@Dave Patton I have seen descriptions of what is in the builds, but it was through a rabbit hole of clicks that I was not monitoring how I got there.
I have the Current Channel Preview (which i think is closer to production than Beta as per the description above). What i'm confused is why I saw my last update was in August but my version was released more recently, but I still don't think I have the latest "Current Channel (Preview)" release.

But, it seems we're all mostly in the same situation. I'm not really sure this question will technically ever have an answer though.

 

[MARK858]

but I still don't think I have the latest "Current Channel (Preview)" release

If you go to do a manual update it will tell you if you are on the current release for your version of Excel or it will update

 

[RoryA]

If you are not on Beta you won't have the new functions (even if you are, you still might not yet).

The release notes for current channel preview are here: Release Notes Current Channel (Preview) - Office release notes