Python in Excel

Question

I have subscribed in the beta channel of Business insider but Python is not installed in Excel. What should i do?

***moved from Microsoft 365 and Office / Excel / For home use / Windows***

Answer 1

Hi Christos Kagkileris,

Greetings!

Thank you for posting in Microsoft Community.

If you have subscribed to the beta channel of Microsoft 365 Business Insider, you should have access to the latest features and updates, including the ability to use Python in Excel. However, you may need to manually enable this feature in Excel.

To do this, follow these steps:

1. Open Excel and click on the "File" tab.
2. Click on "Options" and then select "Customize Ribbon".
3. In the right-hand pane, check the box next to "Developer" and click "OK".
4. Click on the "Developer" tab and then click on "Insert" in the "Controls" group.
5. Select "More Controls" and then scroll down to find "Microsoft Web Browser".
6. Click on "OK" to add the control to your worksheet.
7. Right-click on the control and select "Properties".
8. In the "Properties" window, enter the following URL in the "Address" field: https://www.python.org/downloads/windows/
9. Click "OK" to close the "Properties" window.
10. Double-click on the control to open the Python download page in the web browser control.
11. Download and install the appropriate version of Python for your system.
12. Once Python is installed, you should be able to use it in Excel by writing Python code in the Visual Basic Editor.

I hope this helps! Let me know if you have any further questions.

Regards,

Jrecila B.

Microsoft Moderator

Answer 2

After execution of step 6 above the following message pops up and will not let me proceed.

Answer 3

Hi Christos Kagkileris ,

Thank you for trying the recommended steps. If it is really not letting you go through, then possibly there's an issue on your current build. Please share the full version of your Excel app and we'll check if there's ongoing issue for this. Also, you may want to check for updates on your Excel app after and try again the steps to install Python and also please provide the full version of Office license you are using.

Answer 4

i have use beta channel, for one time the python get installed and i used it . As soon as i restarted the pc, python get disappred from my excel. Why??

Answer 5

Hello Christos Kagkileris,

We haven't heard from you, so we will consider your issue addressed. If you do need further help, please create a new thread to discuss your concerns through this link: Create a new question or start a discussion (microsoft.com), as we will not be monitoring this thread going forward.

Thank you for understanding.

Regards,

Jrecila B.

Microsoft Moderator