Office Settings & Configuration

Fix a Disabled Add Button for Excel Office Scripts in SharePoint

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

The user needs to add a button that runs an Office Script in an Excel workbook stored in SharePoint.

Fix a Disabled Add Button for Excel Office Scripts 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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the workbook

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.

2
Open the OneDrive copy

In OneDrive, select the copied workbook and open it in Excel for the web. Make sure it opens in editing mode.

3
Check the script

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.

4
Add the button

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.

Try adding the script button from OneDrive
Test the copy first: Moving to OneDrive is a troubleshooting test, not a requirement for every SharePoint workbook. The copy is separate from the original workbook, and other users may also need access to the script.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksWork with Excel-format files when moving between office suitesGet a free, lightweight office suite
microsoft office alternative - wps office

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.