I have started to look at this feature a couple of days ago. It seemed to work fine, and the combination of adding Python code into Excel got me excited. However, after running a couple of simple scripts, and after a couple of days I got a message saying "LIMIT EXCEEDED You're using the standard Python in Excel calculation speeds."
I am running two Python scripts. The first script gets a dataframe from a Power Query connection (1000 rows and 10 columns). The second script filters the dataframe, and then draws plots based on the filtered dataframe.
The execution first slowed down like mad, and after a couple more days I am now only looking at #TIMEOUT! errors; the scripts no longer execute.
I was instructed to join the preview channel, which I did. This did not remedy the issue.
Microsoft support do not offer a working solution. They recommended re-install O365, up the calculation timeout limit, and when that did not work, resorted to blaming either my code, Python, or both.
I am not looking for code debugging, and I do not want to share my code here. The code worked fine a couple of days ago. No network or connection issues either.
I am starting to lose my enthusiasm for Python in Excel to be honest.
Does anyone here have experience with this error, and are there some general tips to fix it?
... in fact, it now turned into a #BLOCKED! error, and came with "Limit exceeded" as a further explanation.
I have bot been able to verify if there is indeed a limit, what the limit is, how the limit can be breached, and when it resets. I've contacted Microsoft help, but they did not want to explain or remedy the issue. Very interesting way of dealing with Paying customers Microsoft. 0/10 would not recommend O365 family subscribers.
Hello,
According to information at Microsoft support pages. (As per date of this post)
Python in Excel is now available to Enterprise and Business users running the Current Channel on Windows, starting with Version 2407 (Build 17830.20128), and Monthly Enterprise Channel on Windows, starting with Version 2408 (Build 17928.20216). It’s available in preview for Family and Personal users running the Current Channel on Windows starting with Version 2405 (Build 17628.20164). Python in Excel is available in preview for Education users running the Current Channel (Preview) through the Microsoft 365 Insider Program. It's not currently available for the Semi-Annual Enterprise Channel.
and in the troubleshoot section following is stated about the #TIMEOUT error
The #TIMEOUT! error indicates that the Python formula exceeded the maximum allotted execution time.
Try running the formula again or resetting the Python runtime. From the Formulas tab, in the Python group select Reset runtime, or use the keyboard shortcut Ctrl+Alt+Shift+F9.
You can also adjust the Python timeout limit. Go to File > Options > Advanced > When calculating this workbook and set Python Formula Timeout as desired.
Hi Sjaak,
The BLOCKED and TIMEOUT errors should not be permanent. If you're still experiencing them, go to the Help tab and send feedback so Microsoft can track it.
All Business and Enterprise 365 users have access to the free Python functionality which gives you so much at the premium compute speeds and once you've hit your quota, it slows down to standard speeds, as you've found.
If you want the premium compute Python license, it's US$24/month and you can get it via your Microsoft 365 admin panel.
Mynda
