Python in Excel - #BLOCKED!

Question

I have tried this feature, and was quite happy how it worked. I loaded a small dataframe from a Power Query I had made previously, and in another cell I made a plot consisting of several subplots charts using Matplotlib. Worked like a charm. After a few days though, the processing of the code slowed down like mad. I joined the Preview channel. Yesterday Python execution even completely stopped. I am now looking at a #BLOCKED! error, irrespective of what Python code I enter. The explanation of the error message says "Limit exceeded". I have had a lookhere. As I have entered only a small snippet of code, (..my dataset was ~800 rows * 15 columns..) and it gave up on my after a only a couple of days of using it, I think there must be something else wrong. I have contacted Microsoft support, but after having being given the run around for several days, wasting my time, the issue was not resolved. At all. I get no further explanation, on why this issue arises, and how to remedy it. What gives MS? 0/10 would not recommend.

I am running Excel on Windows 10 64 bit with a O365 Family subscription. All software is up to date (MS support even made me re-install the complete office package; did not resolve the issue).

Any help most appreciated.

Answer 1

*bump*

Answer 2

Dear Balkenbrij,

Thank you for visiting the Microsoft Community.

 

I wish I could solve your problem, but your issue seems to require more specialised support and I suggest you try to seek help from the community below, where there are more experts in the relevant field who can provide you with a better solution.

 

To get help from the Using Python with Excel Support Centre, follow this link.

Excel (microsoft.com)

Search | Microsoft Learn

 

We sincerely hope that if you contact the right department, your issue will be handled properly. Thank you for your understanding!

 

Best regards

 

Isabella-MSFT | Microsoft Community Support Specialist

I was recommended by Microsoft help to use exactly this channel I just posted in, funnily enough.

Answer 3

Dear Balkenbrij,

Thank you for visiting the Microsoft Community.

I wish I could solve your problem, but your issue seems to require more specialised support and I suggest you try to seek help from the community below, where there are more experts in the relevant field who can provide you with a better solution.

To get help from the Using Python with Excel Support Centre, follow this link.

Excel (microsoft.com)

Search | Microsoft Learn

We sincerely hope that if you contact the right department, your issue will be handled properly. Thank you for your understanding!

Best regards

Isabella-MSFT | Microsoft Community Support Specialist