CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-api
sacha
sacha

Reputation: 85

getRangeByName stopped working! Document corrupted or known issue?

As referenced here (https://code.google.com/p/google-apps-script-issues/issues/detail?id=2589), calling getRangeByName stopped working on documents that were perfectly working until now. Is this a known issue? How to fix this? I've seen reports about people complaining about the "instability" of this method that would stop working at time. This is a problem for us as we are using this extensively to populate company dashboards!

Thanks for your ideas

Upvotes: 3

Views: 967

Answers (1)

eddyparkinson
eddyparkinson

Reputation: 3700

try

SheetName!rangename

i.e. add the sheet name to your named range. I was setting this with code, not sure if it works from the UI. When I switched to this way, my problems with named ranges went away.

Background: With only one sheet, all worked fine, but having a few sheets caused problems. I think it was caused when I duplicated sheets with names ranges in. Adding the sheet name solved the problem. Also deleting all the named ranges and adding them again solved the problem.

Upvotes: 4

Related Questions