For Insider, When Will Python in Excel & New GROUPBY & PIVOTBY Functions Appear?

[Steve1330]

My latest build version (downloaded and installed this week) is:

Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) 64-bit

Why have I not yet gained access to either Python in Excel or the new GROUPBY & PIVOTBY Functions?

Thank you.

Steve

[#2]

@Steve1330 

Latest build on Beta is 2312.17116.20002. Python shall be covered on 100%, new functions only partially.

[#3]

Are you saying, based on my version number above, I should have at least Python in Excel by now? It does not appear in my formulas tab yet. Thanks.

[#4]

@Steve1330 

If you are on Beta and update it on 2312.17116 - to my knowledge you shall have it.

[#5]

Just to be clear, as an Insider, I apparently currently have 2311.17029. So, you're saying until I see 2312.17116 or greater, I won't have it?

[#6]

@Steve1330 

Insiders have two channels - Beta and Current Preview. Based on build number you are on the latest Release Notes Current Channel (Preview) - Office release notes | Microsoft Learn

Discussed new functionality was not deployed on Current Preview, you need to update on Beta channel to have it.

[#7]

Got it now. Thanks for your patience in answering my questions. I'll stick with Current Channel (Preview), and just wait until new features show up there.

[#8 · Accepted solution]

@Steve1330 , you are welcome.

As a comment, Beta is stable enough, serious issues here are very seldom. The main problem is compatibility if you share files with someone else or work in different environments.

[#9]

Sergei:
OK, thanks, that was my concern once I read the risk associated with Beta vs Current Channel (Preview). I'll go ahead now and give Beta a chance. Thanks again.

[#10]

I just updated on Beta channel and still none of those new features are appearing. My new build version is:
2312 Build 16.0.17116.20002) 64-bit

Is there something else I need to do? Reboot my PC?

[#11]

Now the new Python in Excel is appearing, but no GROUPBY or PIVOTBY functions. I guess those will be coming in the next few weeks as you noted above. All good for now. Thanks again.

[#12]

@Steve1330 

Yes, GROUPBY and PIVOTBY cover not all Beta users, they are deployed by waves. That's only to wait.

[#13]

@Steve1330 

May take a bit longer. I'm fully updated on the Beta channel, and I don't have the functions yet.

I recall when Python was announced, it took two weeks for the functionality to appear in my Excel.

I'm really looking forward to putting these functions through the paces to see what they can handle!

[#14]

Hi Group,

I am also a beta channel user. and i saw the version i am in is 

I understand the version is 2312 17126.20000. However i dont have groupby and pivotby function. 

Can you give me some help on this?

Many thanks,

YI 

[#15]

Yes, the Insider channel is not 100% yet. The next update will likely go out Tuesday, Dec 5.

[#16]

@Patrick2788 

Many thanks for your prompt reply. 

Looking forward to the upcoming update. 

have a nice day.

YI

[#17]

@Steve1330 how did you update your version because as of now I have the Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) you had. When I click on update it says I'm up to date

Also I checked my Windows Settings and I am in the Beta Channel, but this option doesn't show in the Excel account tab

I am trying to get the Python formula enabled in my laptop, but it doesn't seem to work, what would you recommend? Thank you!

[#18]

Italo, you've got the "Apps for enterprise" version, that's different than I have. Maybe Sergei can help you. Sorry.

[#19]

Sergei:

FYI, despite your assurances, changing to the Beta Channel started causing repeated recent crashing and corrupting of my primary Excel files, none of which had ever crashed previously. I switched back to Current Channel (Preview) late last night and have not had a single such Excel issue today. I appreciate your good intentions, but please stop encouraging such changes unless you know it will absolutely not cause such crash events. Thanks.

Steve

[#20]

@Steve1330 thank you for pointing that out. Probably that's the reason. When you switch back to the Current Channel (Preview) do you still have the Python formula available? Thanks!