Workbook button for Excel Scripts permission issue : The button cannot run because the script was unshared. Contact the owner to share it again.

Question

Workbook button for Excel Scripts permission issue : The button cannot run because the script was unshared. Contact the owner to share it again.

Dheeraj Kaul 35 Microsoft Employee

I created 3 Excel Scripts , added buttons to the workbook for each script, and shared the excel spreadsheet through Teams, and also the scripts on sharepoint with other folks in my organization.

When they opened the excel sheet and tried to run the script from the workbook button, it asked them to "Allow" permission to the script the first time, and executed the script successfully. When they try to run it the second time, it throws the error : "The button cannot run because the script was unshared. Contact the owner to share it again." I checked the script permission, and nothing had changed, it still had the same access.

When they tried to run the script from workbook by clicking the "Run" button against the script, it ran fine, but the workbook button keeps on throwing the error, although it ran fine the first time.

Perkins(陳柏鈞) 0 Reputation points

2024-04-29T06:52:27.15+00:00
It seems the problem only happens when using button, if in user's environment, run the script directly (throught the Automate/open script), there is no problem. Further test result:

Web version & Mac Application version of Excel -> the problem as describe above.

Windows Application version of Excel -> Each click will ask user to allow the script run.

I think both cases are really bad for user experience.
Dheeraj Kaul 35 Reputation points Microsoft Employee

2024-05-01T18:34:11.7166667+00:00

When run using the script it works just fine, but it isn't a user experience that we would want to give to the users.
On 2. , we are fine if it pops up once and the users have the click the button "Allow" and then it runs. The problem is that it only runs once and then afterwards, the button clicks do not work.
Ian 5 Reputation points

2024-05-22T11:56:20.4433333+00:00

We have this exact same issue, whereby the scripts work fine on the first click but not on the second. If they are run via the automate tab then they work fine. I noticed that when clicking on the Automate Tab and then pressing 'This Workbook' it can take a long time to load the scripts. Could there be a connection/time out issue here?

We are in a mixed native Mac app/web environment. The scripts are in a personal OneDrive. I have tried adding the users so they have explicit access to the folder but this makes no difference. The Excel files are duplicates of a master template and are either stored in a Sharepoint site or personal Onedrives.

3 answers

Your answer

Perkins(陳柏鈞) 0 Reputation points

2024-04-29T06:52:27.15+00:00

It seems the problem only happens when using button, if in user's environment, run the script directly (throught the Automate/open script), there is no problem. Further test result:

Web version & Mac Application version of Excel -> the problem as describe above.

Windows Application version of Excel -> Each click will ask user to allow the script run.

I think both cases are really bad for user experience.
Dheeraj Kaul 35 Reputation points Microsoft Employee

2024-05-01T18:34:11.7166667+00:00

When run using the script it works just fine, but it isn't a user experience that we would want to give to the users.
On 2. , we are fine if it pops up once and the users have the click the button "Allow" and then it runs. The problem is that it only runs once and then afterwards, the button clicks do not work.
Ian 5 Reputation points

2024-05-22T11:56:20.4433333+00:00

We have this exact same issue, whereby the scripts work fine on the first click but not on the second. If they are run via the automate tab then they work fine. I noticed that when clicking on the Automate Tab and then pressing 'This Workbook' it can take a long time to load the scripts. Could there be a connection/time out issue here?

We are in a mixed native Mac app/web environment. The scripts are in a personal OneDrive. I have tried adding the users so they have explicit access to the folder but this makes no difference. The Excel files are duplicates of a master template and are either stored in a Sharepoint site or personal Onedrives.

Answer 1

Sarah F 0

I have the same issue but only with scripts with buttons not all of them even though its the same workbook. I own the script as well.

All scripts run fine through the automate ribbon.

What I've tried and all have failed:

Copy script code, create new script, delete the old script and button, put button in for new script
Delete office script folder and restart excel, move scripts there
Delete button create new button

0 comments

Answer 2

Mark S 0

We overcame this issue and other sharing/permissions issues we were encoutering with shared office scripts by deleting the individdual users 'Office Scripts' folder that gets created in the Documens folder. As soon as we removed that and restarted excel it ran as expected every time.

Sarah F 0 Reputation points

2025-08-28T18:26:43.7666667+00:00

Attempted this and it did not work. Also be sure to backup scripts the user created in that folder before deleting.

Answer 3

GCS Backflow Services 0

I have no answer but have the same problem.

I have an Excel 365 workbook that has three scripts which are activated by a button on worksheet. It has been working property for almost 2 years. Today, for the first time, we are seeing this error when trying to run the script. I have tried replacing the button, creating a new worksheet with new buttons, but, so far, the issue still returns.

I sure could use a proven solution.

0 comments

Share via

Workbook button for Excel Scripts permission issue : The button cannot run because the script was unshared. Contact the owner to share it again.

3 answers

Your answer