Office Script stuck

Question

question

Sakura-6148 asked Jan 24, '22 ABK-1764 answered Jul 19, '22

Office Script stuck

Hello

I have been using Office Scripts for a long time and never without too many issues.

One returning issue though, is that a script run in Excel Online through the Code Editor (under Automation tab), will get stuck in 'The script is running' while it is in fact not doing anything. Without exception, this happens to me when using Google Chrome. It seems Microsoft has not optimized things for Chrome users. When I use Microsoft Edge, things always worked.

However, this week I need to use some scripts again and now they won't work anymore on Microsoft Edge either. Just stays stuck on 'The script is running'. Nothing has been changed in these scripts and they worked perfectly before.

What do I do to fix this? These are business critical scripts.

office-scripts-excel-dev

· 5

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JOAOVITOROLIVEIRAPEREIRA-1694 · Apr 13 at 12:14 PM

the same happened to me! And i tried simple code with just one comand just to test and it wont work either.

0 ·

JOAOVITOROLIVEIRAPEREIRA-1694 · Apr 13 at 12:14 PM

the same happened to me! And i tried simple code with just one comand just to test and it wont work either.

0 ·

Bart-0342 · May 18 at 12:07 PM

Same here. No idea what's wrong. The script says it is running, but nothing is happening.

0 ·

WojcikMaciej-8853 · May 20 at 09:17 AM

I have exactly same problem. Scripts were not starting on Chrome, I raise this issue with Microsoft last year and I was told to use Edge instead of Chrome. Problem didn't occur on Edge until they moved Edge to Chromium engine. Since several weeks I can't run macro on Edge, clearing cookies and cache do not help. What is curious scripts occasionally work on Edge on different computers with fresh installation. Also, at least right now I can run scripts using Chrome browser.
Excel scrips are amazing and much simpler than VBA but because unreliability I can't use them in my business. I lost some time learning technology and building automation only to discover that I need to redo it again in VBA to make sure that script will run.

0 ·

Bart-0342 · May 20 at 11:26 AM

Please vote on this item so it might get some attention.

0 ·

Answer 1 · 2022-01-31T17:05:30.933Z

jeremy-msft answered Jan 31, '22 Sakura-6148 commented Feb 21, '22

Hi @Sakura-6148, could you please try reproducing the issue then sending feedback (referencing this post) from within Excel following the instructions below? This will help us better diagnose the issue.

https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11#platform=Office_for_the_web

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sakura-6148 · Feb 21 at 02:34 AM

Thank you. I've submitted now through the internal feedback button. Still experiencing the issue intermittently.

0 ·

Answer 2 · 2022-04-12T05:47:07.5Z

Sakura-6148 answered Apr 12, '22 Sakura-6148 commented May 26, '22

Not sure if there was any feedback since I last time inquired, but the issue has been popping all day now for me, meaning I cannot move forward with a project. A simple Office Script like this stays stuck on 'The script is running'. Happening on both Chrome and Microsoft Edge.

 function main(workbook: ExcelScript.Workbook)
 {
   // Your code here
   console.log("success")
 }

· 5

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JOAOVITOROLIVEIRAPEREIRA-1694 · Apr 19 at 03:47 PM

It wasn't working for me a few days ago but now its working normally. Back then what i did in the meanwhile was changing the browser(and it worked). I saw on internet that maybe you can correct this by cleaning your browser cache.

1 ·

AaronLiu-4344 · Apr 18 at 06:40 PM

Hi,

Would you please try to reproduce this issue, then provide the Excel Online session ID?

To find the session id:

Thank you!

0 ·

image.png (33.1 KiB)

Sakura-6148 AaronLiu-4344 · May 26 at 03:48 AM

Can I just post the session ID here?

This issue has really become a problem for us. Never experience it with Google App Script. I'm almost certain it is a browser issue that has not been properly tested by Microsoft. I have a computer where it works without a problem. Another computer where Office Scripts never work. This is very problematic for distribution as users all have different browser setups. Need a business solution on which we can depend.

0 ·

Sakura-6148 Sakura-6148 · May 26 at 03:54 AM

Could it be caused due to not having a desktop version of 365 installed on my machine? The other machine where it works, does have the 365 desktop version installed. I was hoping that merely having the right credentials I could test the scripts in Excel Online.

0 ·

SreejaPhirose-0854 · Apr 18 at 07:08 PM

I'm also having the same issue even on basic scripts. It stays stuck on the The script is running, with no error or output

0 ·

Answer 3 · 2022-05-20T11:25:54.92Z

Bart-0342 answered May 20, '22

Please vote on this item so it might get some attention.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 4 · 2022-07-19T01:41:05.137Z

ABK-1764 answered Jul 19, '22

Also having this issue with new scripts I'm creating. They are fairly basic scripts too - removing and adding some columns and applying some number filters. Interestingly, old scripts still seem to work.

My current workaround is to use Firefox instead of Chrome

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question