0

I have a script to get a list of Named Ranges on a google spreadsheet. I was working fine until yesterday, where the execution is failing with:

We're sorry, a server error occurred. Please wait a bit and try again.

I have waited and tried again, as instructed. As expected, nothing changed.

I simplified my script until nothing left but:

SpreadsheetApp.getActiveSpreadsheet().getNamedRanges();

Interestingly, if I call getNamedRanges(), the script generates a server error.

Any ideas on the root cause?

0

There is a #REF in one of the named ranges. Apparently, the linked range is deleted, but the named range is still there.

Unfortunately, Google Apps Script is throwing a server error in that case, instead of a meaningful exception/message.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.