I’m developing a script that should trigger from a menu option within a Google Sheets file using the onOpen() function. This work is being done in the script editor accessed from the spreadsheet’s menu. After several days of enhancing the script and testing it through the menu, I’ve encountered an issue: the changes I make are not taking effect when I run the menu command. It appears that an earlier version of the script is stuck in the spreadsheet and doesn’t update even after I save changes in the script editor. I’ve attempted completely closing and reopening both the browser and spreadsheet, but the old script still executes. How can I link my updated code to the spreadsheet so that it correctly runs the most recent version when executed?
Hey Alex, had a similar issue b4. Sometimes clearing the browser cache helps. Also, ensure no errors during save in the script editor. If that doesn’t work, re-add the menu option in the \onOpen\ function after resetting your browser, that helped me once. Good luck!