Python in Excel via Microsoft 365 Insiders program - Beta Channel

Question

Hi Team,

I have enabled Beta Channel via Registry changes , did updated excel as well. But I don't have the access to use Python Function. Please see the below screenshots and advise

Enabled the commands from Options -->choose commands -->MainTab- Added Python. But when i try to use it's not working . Please see below screenshot

Answer 1

I'm the Global Admin here :)

After my research, "Office 365 administrators can't directly enable the Microsoft Insider Beta Channel at the tenant level. However, you can encourage or guide your users to join the Microsoft Insider Program and select the Beta Channel for Office applications on their own"

Is this correct?

Answer 2

Hello

We are very sorry for the late response, on the other hand we would like to thank you for providing us with some additional information on your current concern.

By the way, as we have read the recent information that you have provided. We would like to know where did you get this specific information? As the instruction that was given by the support article was you just have to select the Beta Channel in order for you to enable Python on Excel.

Lastly, since you are the Global admin of your organization. It might be best if you post or ask the same inquiry to this specific Microsoft 365 Insider community forum.

You can directly post your concern by clicking on this link: Microsoft 365 Insider - Microsoft Community Hub ( Note: The provided link will route you directly to the Microsoft 365 Insider community forum.)

This way you can get the most relevant answers and the best solution to your current concern. As most advanced users are gathered on this specific community forum which should be able to answer your current question.

Sincerely

Khou Sun

Microsoft Community Moderator

Answer 3

My issue got resolved few days ago. to get beta channel, we need run below command in command prompt or powershell. But please make sure that you run cmd with local administrator .

reg add HKLM\Software\Policies\Microsoft\office\16.0\common\officeupdate /v updatebranch /t REG_SZ /d BetaChannel  - For Beta Channel

then update the office by using the path and command

Cd “C:\Program Files\Common Files\microsoft shared\ClickToRun”

C:\Program Files\Common Files\microsoft shared\ClickToRun>OfficeC2RClient.exe /update user

then you can open the excel and click on Try preview

Answer 4

Hi

We are very pleased to know that you are able to find an alternative solution to your current concern.

We also very much appreciate you for sharing the steps on how the issue was resolved. As this will help other community members that might encounter the same problem in the future.

Please do not hesitate to ask the community anytime just in case you have any questions in the future. 

Sincerely

Khou Sun

Microsoft Community Moderator

Answer 5

I have signed up for the beta etc,

In 365 EXCEL "Insert Python" is available in the Formulas-Python(preview) group.

When I select "Insert Python" or enter "=py(" in a cell I get:

ERROR: The service required to use this feature is turned off. Check your privacy settings.

What service or privacy settings are required? I have allowed just about everything under "privacy settings" and I still get that message.