Answer the question
In order to leave comments, you need to log in
Why doesn't a Google Sheets script work after sharing a file with another person?
The script allows you to create linked lists. Everything works for me, but if I give access to another user, this script does not work for him. Does anyone have experience and know how to solve the problem?
Answer the question
In order to leave comments, you need to log in
It is necessary to give access to the script on behalf of the new user. For example, by running the script as a new user
When running the script, a new user may get a warning window stating that the script poses a security risk (allow - yes/no). A similar letter may also be sent to the post office. If the user initially forbade the execution of the script, then nothing will actually happen.
The script file "sits inside" the google spreadsheet. If you give access to the table, then access to the script is also issued automatically.
Have you saved the script? Are you giving access to the file where the script "lies"?
join the question. there are no windows for new users. Furthermore. I give an example.
1. The owner and creator of the table and scripts - let's call A
2. User 1 - B
3. User 2 - C.
In this version, the scripts work only for A.
If A transfers the owner to B, then it works for A and B.
If B will transfer the owner to B, then it works for A and
B. If B transfers the owner to A, then A works,
and so on ...
where to dig the reason. I can give you access.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question