ALL Custom Functions return "unknown function" in one spreadsheet, but work in others

google-apps-script google-sheets custom-function
Bob Wold picture Bob Wold · Jun 16, 2015 · Viewed 17k times · Source

I have a few Simple Custom Functions that I use all the time. I have recently run into a spreadsheet that I desperately need to use them in, but when I try to use even the most basic custom functions, I get "#NAME?" with a hover text of "unknown function".

Even deleting all other code, and trying just this simple function, doesn't seem to work:

function double(d) {
  return 2*d;
}

When I duplicate the spreadsheet, the code that comes with it DOES work.

A few Notes:

  1. This is a Google Apps for Enterprise account.

  2. I was originally not the owner on this spreadsheet, but have since become the owner, thinking that this might be the cause.

  3. The spreadsheet originally had protected regions, which have since been removed, thinking that this might be the cause.

This spreadsheet is shared with hundreds of people, so I really want to find the root cause and fix it.

Any thoughts?

Answer

Dryland picture Dryland · Jun 7, 2019

If you already published as Add-on, then you need to do reactivate the addon for copied sheet with the following steps:

  • Click the menu Add-ons / YOUR-ADD-ON-NAME / Help / View in store,
  • click Manage and in the dropdown menu uncheck then check the 'Use in this document' again for the addon to be loaded to the current sheet.

Related questions

Selecting the last value of a column

I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell. Something like: =LAST(G2:G9999) except that LAST isn't a …

Read More
Refresh data retrieved by a custom function in Google Sheet

I've written a custom Google Apps Script that will receive an id and fetch information from a web service (a price). I use this script in a spreadsheet, and it works just fine. My problem is that these prices change, …

Read More
Passing arguments / parameters from a Google sheets custom function to the script function

I'm stuck on a something basic. How do I pass arguments to a Google Sheets custom function. I have a function in the Apps Script code editor defined as: function usageByMonth(range,theDate) { // do something with the arguments passed } In …

Read More