How can I edit a Google Macros Script, When the editor becomes unresponsive?

99 Views Asked by At

I've made a Macros to create filters (just 3 columns' data) on a large (16k rows) data set. This is the 3rd iteration of this Macros I've created using relative references each time.

When I made the 2nd iteration, I ran into the problem of "The starting range row is too small". When I opened the script to look, the page went unresponsive, forcing me to kill the page. After logging out of my secondary google account, I tried again and was able to edit the script.

Now on my 3rd iteration, I've recorded a new Macros using the relative references set (to add on to the filters I've previously created) and have received the same error message regarding the range as before. Upon opening the script to investigate, as soon as I click anywhere on the page (in the textbox, headers, anywhere!) The page goes unresponsive and I'm forced to kill it and start again.

I'm only logged into one google account, and I've tried both Chrome & Firefox and the page crashes on each try.

How can I edit the script? I can't even open the page! Help!!

1

There are 1 best solutions below

4
On

Possible solutions: