How to use one code for multiple spreadsheets that can be updated, attempt to use Library

Question

I have 200+ spreadsheet that our customers fill. I developed a script to manage the spreadsheets which is basically identical in function.

The problem is when I modify the script I need to change it in all these sheets. I tried using libraries but with no success and I hoping to hear if someone knows an answer.

The library version I include (with development on) in each spreadsheet does not show the change ensued. It will only show the results at the time of inclusion, which means that in order to make this work I have to go to each of the spreadsheets, remove the library and re-install the most recent version. The updated library only works from my owner's account. The library is of course shared by anyone who has a link. Running a library's updated function in any of the spreadsheets produce an error: "TypeError: Cannot find function FunctionName in object [object Object]. (line 2, file "test")"

Is there a good way to have all spreadsheets same one code that I can change whenever I wish?

Answer 1

You should turn on "development mode". Resources -> libraries included for each spreasheet that include the library