130 reputation
18
bio website
location
age
visits member for 3 years, 4 months
seen Mar 20 at 15:58

Mar
20
awarded  Popular Question
Jul
30
awarded  Critic
Jul
25
accepted Set up a forwarding email account with Gmail for Business
Feb
21
awarded  Scholar
Feb
21
accepted how do I get named ranges in Google Spreadsheets to be more reliable/current?
Feb
20
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
So the real issue here was that the app doesn't like to do lots of get named range calls -- I had about 60 cells that were relying on a function that read and stored a set of values from a named range. Well that caused all sorts of problems, so I had to ditch it.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
Hmm, taking out ss.getActiveSheet doesn't seem to have changed anything. I'm going to have to look at the original sheet later...
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
so the only difference I see is this: var sh = ss.getActiveSheet();, could that be it? I added that to my code (and cleaned up a typo) and it seems to be working.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
OK your sample is working and mine isn't, I'll look into it a bit.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
I don't see the difference between what I'm doing and that code.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
Sorry, I don't understand that. I made a sample spreadsheet to show you what I'm encountering: docs.google.com/spreadsheet/…; that's a simple spreadsheet with one named range and a function that accesses it. The function can't find the named range.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
As in, do they use $A$1 or A1? It's the latter. Don't know why that'd matter, the data in them changes rarely.
Feb
17
awarded  Editor
Feb
17
revised how do I get named ranges in Google Spreadsheets to be more reliable/current?
edited title
Feb
17
asked how do I get named ranges in Google Spreadsheets to be more reliable/current?
Nov
22
awarded  Notable Question
Oct
26
awarded  Supporter
Jul
19
awarded  Popular Question
Feb
24
asked Set up a forwarding email account with Gmail for Business
Apr
20
awarded  Student