Cannot find the 'Insert Python' function after installing and agreeing to M365 Insider

Question

I'm trying to use the new 'Python in Excel' functionality, but the button for 'Insert Python' is not visible.

(I cannot provide screenshots or upload files as it seems like that feature is not working on this forum at this moment)

Here's what I've done....

===

* Installed the latest version insider edition and updated

> Microsoft® Excel® 2021 MSO (Version 2410 Build 16.0.18112.20000) 64-bit

* Agreed to the 'Insider's Edition' terms and services.

* Activate Python by typing "=PY()" inside of an excel cell

* Tried to customize my ribbon to see if "Insert Python" was an option, (which there wasn't)

* Tried searching "Python" in the universal search bar in excel, but nothing useful was found.

OS: Windows 11 Home

Version: 23H2

OS Build: 22635.4145

Could someone guide me on?

Answer 1

Hi Hoang Pham4,

To rule out any potential impact from your existing Office 2021 license, I suggest clearing the license information using the following method to see if it resolves the issue.

First, press the Windows key + S, search for "cmd" in the search box, and right-click on "Command Prompt" in the search results to select "Run as administrator."

Enter cd C:\Program Files\Microsoft Office\Office16 

Enter cscript ospp.vbs /dstatus (note the space after .vbs, use English input method to enter the command)

and then enter the following command to uninstall the last five digits of the key:

cscript ospp.vbs /unpkey:(last five digits of the key) [e.g., cscript ospp.vbs /unpkey:KHGM9].

Enter cscript ospp.vbs /dstatus again to verify if there are any other keys, and repeat the above steps if there are.

After completing the removal of residual Office information, reopen your Office. Feel free to share the result with me.

Jonathan Z

Answer 2

I have done as you said. But the result is still the same. I still cannot get access to Python in Excel

Answer 3

Hi Jonathan Z,

Can you continue to help me solve this issue?

Hi Hoang Pham4,

To rule out any potential impact from your existing Office 2021 license, I suggest clearing the license information using the following method to see if it resolves the issue.

First, press the Windows key + S, search for "cmd" in the search box, and right-click on "Command Prompt" in the search results to select "Run as administrator."

Enter cd C:\Program Files\Microsoft Office\Office16 

Enter cscript ospp.vbs /dstatus (note the space after .vbs, use English input method to enter the command)

and then enter the following command to uninstall the last five digits of the key:

cscript ospp.vbs /unpkey:(last five digits of the key) [e.g., cscript ospp.vbs /unpkey:KHGM9].

Enter cscript ospp.vbs /dstatus again to verify if there are any other keys, and repeat the above steps if there are.

After completing the removal of residual Office information, reopen your Office. Feel free to share the result with me.

Jonathan Z

Answer 4

Hello Jonathan,
I have followed all the steps, reinstalled all and it worked for day, and the next day it disappeared.

Please guide.

-Kamal

Answer 5

Hi all members,

Please anyone help me with this issue? I appreciate a lot

Hi Hoang Pham4,

To rule out any potential impact from your existing Office 2021 license, I suggest clearing the license information using the following method to see if it resolves the issue.

First, press the Windows key + S, search for "cmd" in the search box, and right-click on "Command Prompt" in the search results to select "Run as administrator."

Enter cd C:\Program Files\Microsoft Office\Office16 

Enter cscript ospp.vbs /dstatus (note the space after .vbs, use English input method to enter the command)

and then enter the following command to uninstall the last five digits of the key:

cscript ospp.vbs /unpkey:(last five digits of the key) [e.g., cscript ospp.vbs /unpkey:KHGM9].

Enter cscript ospp.vbs /dstatus again to verify if there are any other keys, and repeat the above steps if there are.

After completing the removal of residual Office information, reopen your Office. Feel free to share the result with me.

Jonathan Z