ALL user-defined functions return an "unknown function" in one table, but work in others

Question

I have some simple custom functions that I use all the time. I recently came across a spreadsheet that I desperately need to use, but when I try to use even the most basic user-defined functions, do I get "#NAME"? with hover text for "unknown function".

Even deleting the rest of the code and trying to simply execute this simple function do not work:

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

When I duplicate a spreadsheet, the code that comes with it works.

A few notes:

• This is a Google Apps for Enterprise account.

• I originally did not own this table, but since then I became the owner, believing that this could be the reason.

• Initially, the spreadsheet had protected regions, which have since been deleted, believing that this may be the reason.

This spreadsheet is divided into hundreds of people, so I really want to find the cause and fix it.

Any thoughts?

Answer 1

When you have custom functions in a worksheet, they are BOUNDin that worksheet. Thus, it works when you duplicate itself sheet, but it does not automatically become a global or public user function.

, , - , script script , script , .

Answer 2

OP, , - : , , . , . Tools > Script editor .

, . - , .

- . , , .

Answer 3

, , , - . , - , , , , . . ! , - , ...

Answer 4

, , :

• /- -// ,
• click "Manage" and uncheck the box from the drop-down menu, then check the "Use in this document" box again to add an addition to the current sheet.