'How to deploy newer version of library and new static code to all users?

I currently have a spreadsheet template that is copied and renamed for each new client. The template contains its own code and html files. It also references a library. I do not have a good understanding of the deployment process.

I currently have a test and prod version of the library. I make changes to the test and then copy them to the prod when ready to publish to the company. I can always be sure that everyone is using the proper prod version.

This is not the same for the code and html resident with the named spreadsheet. This code is static from when the file was copied.

I want to be able to update the library and local code dynamically through the DEPLOY process. Is this achievable? Should the library code be "included" directly into the template rather than being "referenced"? (If yes, How?)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source