Apps scripts have stopped working completely on sheet

184 views
Skip to first unread message

Peter Storey

unread,
Jul 26, 2023, 10:38:28 AM7/26/23
to Google Apps Script Community
I have a very important sheet that updates via a banking API and is pretty crucial to our workflow. Yesterday morning, all the scripts stopped running. All I get is the Execution Started notice and the spinner. No code is executed although it does show as launched in the logs.

I even tried to recreate with the simplest possible Hello World script and that too hangs until it times out.. We're nowhere near use limits, duplicating the sheet has the same problem, and it happens across multiple user accounts. Creating another sheet and moving Hello World works, although I haven't tried any of the more complex scripts.

Anyone seen this before?

Web Dev

unread,
Jul 26, 2023, 10:46:14 AM7/26/23
to google-apps-sc...@googlegroups.com
I've noticed a lot of users have been experiencing various issues similar to this. Many issues with DriveApp and operations. For one of my client's the issue was solved by simply removing and adding emails to the Share feature (People with access), as there was nothing wrong with the code. Try creating a copy of the sheet and test-run it.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5720c717-9751-422c-b5c0-6e6e9a047695n%40googlegroups.com.

Peter Storey

unread,
Jul 27, 2023, 9:33:20 AM7/27/23
to Google Apps Script Community
So now it's getting even weirder. I was able to get the sheet up and running again by copying all the data to a new sheet, then copying the scripts over one by one. It was working - for a while. Now, it seems to be stuck only running one of my scripts. No matter which one I select on the left, or if I make any changes, it will only run a previous version of an outdated script. Almost like it's stuck in a cache somewhere. Doesn't matter which user account I use, or which browser, still the same effect. Even creating a new script is ignored - it will only run a mystery version of something outdated, every time I hit the run button.
Reply all
Reply to author
Forward
0 new messages