Office scripts team, wherever ye might be. I'm trying to get my organization to switch over from VBA scripts to office scripts but there is a snag. Only the owner of an office a script can edit / add it to a spreadsheet. If I try to open a script on a shared folder from someone else, I can pick the file, but then it just either silently fails or throws a not found error when I try to add it to a spreadsheet. It only works to add a office to a spreadsheet if the user logged into excel is the same as the one who owns the onedrive drive.
It does work if the script is stored in a sharepoint site, however, the script I'm making needs to make a fetch call which does not work on a sharepoint site according to the docs.
We could have everyone just write their own scripts and save them in their personal drives, but if that person ever leaves, those scripts would be removed from all the spreadsheets they were bound to. This could be in the thousands.
Essentially, I need to login to a server via remote desktop as a service account to add office scripts to spreadsheets if I want to be able to make sure the link to the spreadsheet isn't broken some day.
I've tried adding a script to shared folder with multiple people. Each time I cannot add the script to the spreadsheet. I usually tested with the default script that is made. So, for example, person A has the script in their folder that is shared with person B, person B cannot add that script to a spreadsheet even though they have access to it.