Fix a Disabled Add Button for Excel Office Scripts in SharePoint
Question details
The user needs to add a button that runs an Office Script in an Excel workbook stored in SharePoint.

- Product
- Microsoft Excel for the web and Office Scripts
- Device & OS
- not provided
- Scenario
- Assigning an Office Script to a button in a SharePoint-hosted Excel workbook.
- Observed behavior
- The Add Button option is unavailable.
Open the workbook in Excel for the web and check that you can edit it. Confirm that the Automate tab and the Office Script are available under your work or school account.
Try adding the script button from OneDrive
Use a OneDrive copy to check whether the workbook or script location is contributing to the disabled option.
In Excel for the web, use File > Save As to save a copy of the SharePoint workbook to your OneDrive. If that option is unavailable, use the OneDrive or SharePoint file menu to copy the workbook.
In OneDrive, select the copied workbook and open it in Excel for the web. Make sure it opens in editing mode.
Select Automate > All Scripts and open the script. If it is stored in SharePoint, try creating a personal copy: open its code, copy it, and use Automate > New Script to create and save a script in your OneDrive.
With the script selected in Automate > All Scripts, open its details or More options menu and choose Add button. Check whether the button appears in the worksheet.

Check editing access and Office Scripts availability
Use this solution if Add button remains unavailable or the script cannot be opened.
Work with Excel files using WPS Spreadsheets
WPS Office is a free, lightweight alternative for everyday spreadsheet work. Its familiar interface and Excel file support make it easy to move between office suites. It does not fix Microsoft Office Scripts or the disabled Add Button option.

Frequently Asked Questions
Does an Office Script have to be stored in OneDrive to add a button?
Not necessarily. Trying a personal script saved in OneDrive can help isolate a location or access issue, but it is not a universal requirement for SharePoint workbooks.
Where can I find the Add button option?
In Excel for the web, open Automate > All Scripts, select the script, and look in its details or More options menu for Add button.
Why can't I see the Automate tab?
Check that you are signed in with an eligible work or school account. If the tab is still missing, ask your Microsoft 365 administrator to check your license and Office Scripts settings.
Will a button in my OneDrive copy appear in the original SharePoint workbook?
No. A OneDrive copy is a separate workbook. Changes made to it, including an added button, do not automatically update the original SharePoint file.
Can other people run the script from the workbook button?
Other users need appropriate access to the workbook and script, as well as an account that can use Office Scripts. Check sharing permissions with the workbook and script owners.




