Hi,
Every night an excel spreadsheet is created in a sharepoint folder. The previous version is deleted, then the new one is created. The file has the same path and file name on every creation. I'm trying to run an excel script on this sheet, and it works, but at some number of runs it stops, with a Script Not Found error. The most amount of times I've had it run is 4.
I initially set this up on my OneDrive business account, but as part of trying to get this to work I moved the .osts file into the sharepoint and used the Run Script From Sharepoint Library and pointed that at the .osts file. This worked for the first two runs, and now I get the same error, 'Script Not Found'.
When I open the sheet manually I can run the script on the file and it works. The script works the first time, everytime, but at some point stops being found in either the sharepoint or OneDrive Business. Everything is done in my work account, I don't change the script in anyway, editing it, moving it or renaming it between runs. I save it once and then don't touch it.
Any advice is appreciated.
