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 15 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 15 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.