Forum Discussion

Sherbman's avatar
Sherbman
Brass Contributor
Aug 22, 2023

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

 

  • Mr_Zagon's avatar
    Mr_Zagon
    Copper Contributor
    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.
  • Anh_Nguyen_2006's avatar
    Anh_Nguyen_2006
    Copper Contributor

    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.

  • pdutra145's avatar
    pdutra145
    Copper Contributor
    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/3893439
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP

      pdutra145 

      Exactly, 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. 

  • PieterG's avatar
    PieterG
    Copper Contributor

    Sherbman   Same problem here but after closing all Excel docs and restarting Excel twice I was able to go to  'formulas> inser Python' and it worked.

  • modifero's avatar
    modifero
    Copper Contributor
    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.
    • Mikael Gabrielsson's avatar
      Mikael Gabrielsson
      Copper Contributor

      modifero It's only available for Windows at the moment.

      "Platform availability 

      Python 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

      • modifero's avatar
        modifero
        Copper Contributor
        noted. Thanks for the confirmation. Any possibilities to go public on mac then? when?

Resources