Aug 22 2023 10:31 AM - edited Aug 22 2023 10:37 AM
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
Aug 22 2023 03:05 PM
Aug 22 2023 07:25 PM
Aug 23 2023 01:58 AM - edited Aug 23 2023 02:24 AM
@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.
Aug 23 2023 04:02 AM
Aug 23 2023 04:14 AM
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.
Aug 23 2023 09:34 AM
@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.
Aug 23 2023 09:42 AM
@Anh_Nguyen_2006 again, nothing of that works. That's only to wait for the functionality activation on Microsoft server.
Aug 23 2023 11:28 AM
@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
Aug 23 2023 05:35 PM
Aug 23 2023 06:14 PM
@Sherbman me too! Come on MS we're chomping at the bit for this feature! Show me the python!!
Aug 23 2023 10:46 PM - edited Aug 23 2023 10:58 PM
Same here; I can't find the Python function in the ribbon. Weirdly enough, the latest build release notes don't mention Python for Excel, either. I don't understand why all the announcements say Python would be available in Build 16818.
Aug 24 2023 01:14 AM
Please check latest comment from Chris Gross (Microsoft) here https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-...
Aug 24 2023 11:01 PM - edited Aug 24 2023 11:08 PM
Aug 25 2023 07:44 AM
@Serene The version you quote is the first & only release of native Python in Excel & the latest as of the initiation of this thread.
I also have this issue, it is a bug in the install process which appears Microsoft are aware so hopefully an update asap.
Aug 25 2023 09:14 PM
Same issue here but using Excel for Mac. Joined Beta Channel following the steps at the official link, updated excel but it only updates till version 16.77 (23082302), whereas I see in the rollout page that they already released version 2309.
Aug 26 2023 04:14 AM
Aug 26 2023 04:52 AM
@ckespanol My understanding is their policy is not to release 100% in that build number. They'll release say 30% on the current build; despite advertising as it being in that release version. Shocked as the entire reason I just subscribed was for this Python version. Would have stuck with Office 21.