Forum Discussion
Python for Excel not showing in Formulas
I've followed the following steps:
https://insider.microsoft365.com/en-us/join/windows
chose insider level "Beta channel" and installed insider builds, waited for it to install and then opened excel and still python for excel can not be found and typing '=PY' in the formula bar gives an error. Any idea where is that coming from ?
P.S when I search for python in the search bar I get "insert python" option but nothing happens when I click on it
Thanks
Sherbman I was able to customize ribbon and get it to show up, but nothing happens when I click it or try to type =PY
Sherbman me too! Come on MS we're chomping at the bit for this feature! Show me the python!!
- Me too!
- I'm experiencing the exact same issue.
- i'm trying to use this feature, on mac, and faced the same issue. (already change to beta channel), but looks like no 'excel' updates.
if would be great if the developer can give steps to solve this.modifero It's only available for Windows at the moment.
"Platform availabilityPython in Excel is available in Excel for Windows. The feature is not available in Excel for Mac, Excel on the web, Excel for iPad, Excel for iPhone, or Excel for Android. On unsupported platforms, workbooks containing Python can be viewed but Python cells display an error when recalculated."
Introduction to Python in Excel - Microsoft Support- noted. Thanks for the confirmation. Any possibilities to go public on mac then? when?
- Same problem for me. There's no option to create a python function. I guess they are releasing the feature gradually, even if you are subscribed to insider's program.
"Don’t have it yet? It’s probably us, not you. Features are released over time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements for further improvement based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product even if you, as an Insider, have had the opportunity to try it."
https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439Exactly, new functionality is deployed in channel by waves. First one could cover 10%, could 50%, but definitely not 100% of users on the channel. We may wait for weeks or months for 100% coverage.
"Insert Python" in search bar and ability to add some icons to toolbar only says the code with python functionality is inside the build. But not activated.
- Same here
Sherbman
I have the same problem as you, so I can add Python in Exel from Customize Ribbon but it has got one circle like the picture.Anh_Nguyen_2006 again, nothing of that works. That's only to wait for the functionality activation on Microsoft server.
- Me too. Have done what davedavedavedave has done but when typing =PY in spreadsheet will not work. One question, why does microsoft always roll out great things that dont work properly.
