4,381 questions
This affects only the "Automate Work". "Record Actions and "New script" work fine. Thank you so much. I apologize, I don't know how to open a session ID..
Excel Automate not Loading (stuck on loading screen once pressing code)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHW%3C/text%3E%3C/svg%3E)
hannah wakeford
10
Reputation points
Hi all,
I have been using automate on excel for the last 6 months as I have a repetitive task I use on excel, this usually allows me to download the date to excel, press automate and it all actions accordingly so I can save and move on. I'm using it for formatting data really. Anyway today I've gone to do my work and when pressing automate then the script before it usually opens the script on the right and allows me to press run script however its stuck with a loading symbol, not opening this,
Can anyone advise?
thanks Hannah
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
3,917 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 22%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Michelle Ran 346 Reputation points Microsoft Employee2024-09-25T19:13:48.3733333+00:00 Hi Hannah - I'm sorry to hear you're not able to access your script. Would you be able to share a session id for us to investigate? On the web, you can find your session id by going to File > Info. On desktop, go to File > Account > About Excel. Please do this after encountering the issue again.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 5%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
YB 10 Reputation points2024-10-07T12:32:09.5066667+00:00 This is happening to me as well! The "Automate Work" tab that opens on the right is just stuck with a loading sign forever and never loads anything..veryyy frustrating.
-
Michelle Ran 346 Reputation points Microsoft Employee
2024-10-07T15:36:10.86+00:00 Hi YB - could you confirm if the loading issue only affects the "Automate Work" experience, or does it also affect other parts of the Automate tab (e.g., recording or opening a script)? It'd also help us if you shared a session id!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 76%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Andrew Wilkins 0 Reputation points2025-02-05T12:53:09.8566667+00:00 I have the "Loading the recorder pane..." with a green whirlpool never ending
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 62%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Michael Vreuls 0 Reputation points2025-05-14T11:11:23.9166667+00:00 Having a lot of these problems recently with varying users.
Clearing cache, using in-private session, or using other browsers does not solve the problem.
Also in general responsiveness of these services became much slower.
Sign in to comment
2 answers
Sort by: Most helpful
-
YB 10 Reputation points
2024-10-07T20:35:49.98+00:00 -
Michelle Ran 346 Reputation points Microsoft Employee
2024-10-08T20:04:31.52+00:00 Hi YB - could you please check if you're still encountering this issue? If so, then on the web, you can find your session id by going to File > Info. On desktop, go to File > Account > About Excel.
Sign in to comment -
-
Andrew Wilkins 0 Reputation points
2025-02-05T15:25:47.3333333+00:00 I had lots of similar problems with Excel Automation.
They seem to have been fixed by clearing the file cache-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 4%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WebDev 0 Reputation points2025-06-04T22:32:31.0266667+00:00 How do you "clear the file cache"? I'm on Excel Online and the "Automate Work" button endlessly spins.
Sign in to comment -