Python not available in Excel - Beta Channel

Question

I've just successfully joined the Beta Channel and Office 365 has been updated.

My Excel Version is 2311 - (Build 17022.20000 Click-to-Run)

However un Excel under the Formulas tab - there is no Python section.

Please advise

Answer 1

Hi WardellCastles, This is Bryll

Thank you for writing us here in Microsoft Community.

To use Python in Excel Beta Channel of Office 365 version 2311 Build 17022.20000, you need to enable the Developer tab and install the Script Lab add-in. Here are the steps to do that:

1. Click on File > Options > Customize Ribbon and check the Developer box under Main Tabs. Click OK to save the changes.
2. Click on the Developer tab and then click on Add-ins. Search for Script Lab in the Office Add-ins Store and click on Add.
3. Once the add-in is installed, you can open it from the Developer tab by clicking on Script Lab > Code.
4. In the Script Lab pane, you can create a new script or import an existing one. You can choose Python as the language and write your code in the editor.
5. To run your script, click on Run > Run in this workbook. You can see the output in the console or in a task pane.

• Make sure that your Windows OS computer is installed with WebView2 - Microsoft Edge Developer

Should Insert Python still show missing from the Formula tab, proceed to other strategies below:

1. Go to File then Excel options
2. Click Quick Access Toolbar
3. Under Choose commands from, select Formulas tab
4. From the list of Formulas tab, try to find Python and press Add
5. Open Excel and click on the "File" tab.
6. Click on "Options" and then select "Add-ins".
7. In the "Manage" drop-down menu, select "COM Add-ins" and click "Go".
8. Check the box next to "Python for Excel" and click "OK".
9. Restart Excel and Python should now be available.

If you do not see "Python for Excel" in the list of COM Add-ins, you may need to download and install the Python for Excel add-in from the Microsoft AppSource store. 

Should problem persist, I recommend in uninstalling or reinstalling your Microsoft Office suite.

If still encountering same issue with Python in Excel, please be guided that Python is currently in preview where it is still in development and are being tested by users to gather feedback and improve their performance before they are released to the general public. It may contain bugs or other issues that could affect their functionality. Report them by selecting Help > Feedback in Excel or through How do I give feedback on Microsoft 365? - Microsoft Support

I am honored to contribute on your concern.

Yours truly,

Bryll

Microsoft Moderator

Answer 2

Thanks.

I tried that. Didn't work.

When I get the time and inclination I will reinstall Microsoft 365 as suggested earlier.

Answer 3

I had the exact same problem. Here's how I solved it:

1. Uninstall 32-bit version of Microsoft 365 installed by mistake (my machine is 64-bit. I had to download and use SetupProd_OffScrub.exe to remove all of it.)
2. Find, download and execute the 64-bit installer for MS 365 and Office
3. Launch Excel
4. Click on Account
5. Under the Product Information column for Microsoft 365, look for Microsoft 365 and Office Updates and smash the Update button.
6. After the update has finished, restart the machine.

Answer 4

Hello WardellCastles, It's Bryll again

I am grateful for your prompt response as well.

Yes, having 3 different versions of Python concurrently may possibly cause conflict with each other. You may try to keep 1 version of Python and if same problem remains, reinstalling Microsoft Office 365 suite would be ideal.

Important note: Make sure you have your product key or account information ready before you do this. You can download the Office setup file your Microsoft account website or use the media that came with your purchase.

If you will still encounter same issue with using Python in Excel, please be guided that Python is currently in preview where it is still in development and are being tested by users to gather feedback and improve their performance before they are released to the general public. It may contain bugs or other issues that could affect their functionality. You may report this problem to Microsoft developers to help upcoming updates by selecting Help > Feedback in Excel or through How do I give feedback on Microsoft 365? - Microsoft Support

Respectfully,

Bryll

Microsoft Moderator

Answer 5

Bryll,,

Thanks for the quick reply.

Things are not going well after following your instructions. I have multiple versions of Python 3 installed. I use pyenv to manage which version is active. Is that a problem?

Worst case I guess I will uninstall and reinstall Microsoft Office 365