Forum Discussion
Python in Excel quota problem
I understand that there is a quota. It's normal because Microsoft's servers are not sufficient. However, there's a problem: I have an Excel file with a total of 22 tabs, each containing independent calculations. When I change the content of a single cell, all formulas in all Excel tabs start working.
Why are they all running, and why am I not controlling this calculation or compilation process myself? I have Anaconda installed on my machine. If you allow me to run the Excel calculations with Python on my machine without limits, it would be an excellent solution.
The same issue exists with GPT. We can't perform large calculations on your servers. GPT already says, "You can run this code." GPT and Python in Excel only support small calculations with a few formulas. Unfortunately, large-scale enterprise operations fail.
Since no CPU or GPU solution is available right now, at least allow running Python within Excel on our own machines until this crisis is resolved. If this isn't possible, only calculate the formulas in the tab I'm currently working on. Additionally, let me control this calculation process.
When writing a code, all lines of code are executed for each row. This is very unnecessary.
5 Replies
You could set your file to Partial calculation mode, it would turn off recalc for Python formulas.
If I recall correctly, there is a subscription you can add to your M365 subscription that increases the limits.
i buy python in excel. and blocked message has appear. Where can i incareses the limits.
Now I’m getting an error saying that all Python codes are blocked due to quota overage. Do I have to wait for 1 month now? I couldn’t find where to upgrade. I’ve already purchased the Python in Excel add-in. Despite that, will I have to wait for 1 month? I’ll have paid Microsoft for nothing.
Yes, I have already bought the premium add-on. But the limit was exceeded again, stopping everything.
Ok I change it to Partial calculation mode. Now I’m getting an error saying that all Python codes are blocked due to quota overage. Do I have to wait for 1 month now? I couldn’t find where to upgrade. I’ve already purchased the Python in Excel add-in. Despite that, will I have to wait for 1 month? I’ll have paid Microsoft for nothing.
