Forum Discussion
Python in Excel: "Getting your preview ready..." loads forever
Okay so in January 2025 when I ran past the python-in-excel quota I got a button to "try preview" of premium python speed. When I clicked on the button I got a "getting your preview ready..." window with an infinite loading circle. But then I would get an email saying "welcome to python" and it would work again with the "premium" speed.
But now in February when I click try preview the screen is just frozen forever and I don't get an email and the code runs so slowly it is unusable.
I have a few questions. Any thoughts or answers or anything would be greatly appreciated!
- Is there any way I can get the preview to work again like it did before?
- Can I pay for premium speeds? I want to use it for the Excel World Championship so I have to use a personal account not the account from my government employer so enterprise options won't help me.
- Any hints or word on when we might get an update that may address some of these issues?
- How about if I beg? Please please please :)
It is very frustrating and janky to click on the thing I need and see an infinite loading icon and no way to use all the code I wrote last month. If anyone here knows a workaround I'd be super grateful and of course if anyone from the Excel team is reading this I would love some help here!
3 Replies
- KaidenFinnIron Contributor
1. Check the network: Make sure the network connection is stable.
2. Update software: Click File > Account > Update Options > Update Now to ensure Excel and Office 365 are up to date.
3. Clear cache: Close Excel, delete the cache folder (Windows: %localappdata%\Microsoft\Excel\PythonCache, Mac: ~/Library/Caches/Microsoft/Excel/PythonCache), and restart Excel.
4. Reduce the amount of data: Try to reduce the amount of data or process the data in batches.
5. Use an alternative tool: If the problem persists, try Jupyter Notebook or Google Colab to run the Python code and then import the results into Excel.
6. Contact support: Visit the Microsoft Technical Support page or post in this forum for help. - MilesGroveIron Contributor
Check if there are updates available for your version of Excel. Go to File > Account > Update Options > Update Now to make sure you're using the latest version.
- JudeHillIron Contributor
Sometimes, clearing the cache of Excel or refreshing the application might help. You could also try restarting Excel altogether or rebooting your computer.