Office Script Not Working

Question

Hi Community Team,&nbsp;I have a script on a Excel sheet in one drive, simple script just to clear a range of cells of contents.Works fine for me, but although others can access and edit shared file, the script set up to clear cells does not work.Script seems to be shared too.Any ideas?

jim_currier__npl · Answer

Hi&nbsp;rzaneti&nbsp;&nbsp;This may be one for you buddy.What do you think?

rzaneti · Answer

Hi&nbsp;Jim_Currier__NPL&nbsp;,&nbsp;Are your users calling the script through a button? If yes, is it show the "Running script" message? If yes, does it generate any error logs(it usually appears at the red strip, on the top of your spreadsheets)?

jim_currier__npl · Answer

Hi&nbsp;rzaneti&nbsp;,&nbsp;Yes its through a button.I've asked a couple of people to test it for me to see if they get any error messages.Will let you know.&nbsp;

jim_currier__npl · Answer

Hi&nbsp;rzaneti&nbsp;&nbsp;Just tested with another user, the script does not even appear to show on their version.No error messages, just as if the script is not there.&nbsp;Kind Regards,

rzaneti · Answer

Hi&nbsp;Jim_Currier__NPL&nbsp;,&nbsp;It is probably some issue with the sharing settings. Can you please follow this procedure and test it again:&nbsp;1. In your script details, confirm if the access is allowed to other members of your organization (in the example below, you see that this is available only for me):&nbsp;&nbsp;2. Click in the '...' button and 'Share':&nbsp;3. After allow the sharing, the Script access may look like this:&nbsp;Test if now your users can access it.&nbsp;Let me know if not works and we can keep investigating!

Forum Discussion

Office Script Not Working

Share

Resources