Forum Discussion
Python in Excel - quotas?
The monthly quota on Python usage in Excel is currently a limitation that many users are running into. Microsoft has set a monthly usage limit for Python calculations in Excel.
When you exceed this limit, you'll encounter the "#BLOCKED - You have exceeded your monthly quota of Python usage." message. The quota likely includes the number of Python function calls or the total computation time. However, Microsoft has not publicly detailed the exact criteria or limits. This quota typically resets at the beginning of each month. If you've hit the limit, you'll need to wait until the next month or optimize your Python usage to avoid hitting the quota.
There is currently no direct payment option for increasing your quota, as far as I am aware.
My knowledge on this topic is limited, I only describe what I knew up to now, which does not mean that anything has changed in the meantime.
Links:
how to check quota for Azure spot VMs vCPU's using Python Azure SDK?
Getting started - Managing Quota using Azure Python SDK
I would like create quota increase request through cli is it possible.
My answers are voluntary and without guarantee!
Hope this will help you.
I got so frustrated with this and other restrictions of Python in Excel that I launched my own version of Python in Excel that you can install for free from the official Excel add-in store. It's called xlwings Lite. Since it runs locally in the browser runtime that powers modern Office add-ins, there's no need to impose any quota whatsoever.