Forum Discussion

EricAshton's avatar
EricAshton
Copper Contributor
Feb 06, 2025

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! 

  1. Is there any way I can get the preview to work again like it did before?
  2. 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. 
  3. Any hints or word on when we might get an update that may address some of these issues?
  4. 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

  • KaidenFinn's avatar
    KaidenFinn
    Iron 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.

  • MilesGrove's avatar
    MilesGrove
    Iron 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.

  • JudeHill's avatar
    JudeHill
    Iron Contributor

     Sometimes, clearing the cache of Excel or refreshing the application might help. You could also try restarting Excel altogether or rebooting your computer.

Resources