I've got a google spreadsheet I created yesterday and used Tools -> Script Editor to create a function in a single file called Code.gsfunction onOpen(e) {  var email = (Session.getEffectiveUser().getEmail());  var targetsheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  var mastersheet = SpreadsheetApp.openByUrl(https://docs.google.com/spreadsheets/d/.../edit#gid=...).getSheetByName(Master);  var masterrange;  var targetrange = targetsheet.getRange(2, 5, 1000);  // when opened, we will grab the data from the master sheet and feed it into the target sheet.  switch (email){      case 'me@mydomain.com':      masterrange = mastersheet.getRange(2, 21, 1000)      break;    };  targetrange.setValues(masterrange.getValues());  Logger.log(masterrange.getValues());}So I can manually run this function and it does pull the data from mastersheet and populates the target sheet.But if I change the mastersheet and close/re-open the target sheet, the update is not reflected.If I delete the data from the target sheet and close/re-open, it's not populated on opening.Am I missing something here? Just seems like the functions will not run at all.My understanding of triggers is that I shouldn't have to do anything special to bind the onOpen(e) function as a trigger.
onOpen doesn't execute
google spreadsheets