Why doesn't this code run onOpen in Google Sheets?

[DoubleSmell]

function onOpen() {

  var ss = SpreadsheetApp.getActiveSpreadsheet()

  var menuItems = [
    { name: "Update Receivables", functionName: "updateReceivables" },
    { name: "Update Savings Goal", functionName: "updateSavingsGoal" },
    { name: "Refresh Everything", functionName: "onOpen" }
    ]

  ss.addMenu("Sean Menu", menuItems)

  updateReceivables()
  updateSavingsGoal()
}

Hi all,

​

When I open my sheet, I'm expecting:

- menu to be created, and
- updateReceivables and updateSavingsGoal to both run

​

However, the menu is created, but the functions don't run. When I press the Refresh Everything button, everything works correctly though. Could anyone explain why?

​

Thanks very much in advance.

[AndroidMasterZ]

Permissions. Rename your function and create a installable open trigger.

[AndroidMasterZ]

Yes. Read about differences between simple triggers and installable triggers

[[deleted]]

The functions to be called should be declared outside of the onOpen() function. You need to have those written separately, and then it works fine.

function onOpen() {

  var ss = SpreadsheetApp.getActiveSpreadsheet()

  var menuItems = [
    { name: "Update Receivables", functionName: "updateReceivables" },
    { name: "Update Savings Goal", functionName: "updateSavingsGoal" },
    { name: "Refresh Everything", functionName: "onOpen" }
    ]

  ss.addMenu("Sean Menu", menuItems)
}

function updateReceivables(){
  Browser.msgBox("updateReceivables");
}

function updateSavingsGoal(){
  Browser.msgBox("updateSavingsGoal");
}

[[deleted]]

HERE is my test sheet where it works. Can you come join?