Google Sheets script server error on activeSpreadsheet.getNamedRanges()

Question

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?

Kartal Tabak · Answer

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.

One Answer