MOPS 4.0 Excel Add-In Installation

Steps for Deployment of an Excel Add-in

Prerequisite: Admin permissions in Microsoft 365 admin center (real or via sandbox)

Microsoft 365 Developer subscription (E5) sandbox

  1. Log in at https://my.visualstudio.com/

  2. Create a Microsoft 365 Developer subscription (E5) sandbox and generate all necessary resources.

Microsoft 365 admin center

  1. Log in as admin to the sandbox at https://admin.microsoft.com/#/homepage

  2. Expand Show all in the left menu (this will show Settings in the left menu).

  3. Expand Settings in the left menu and select Integrated Apps.

  4. Press the Add-ins link in the first paragraph to open https://admin.microsoft.com/#/Settings/AddIns

  5. Press + Deploy Add-in, which will open a right menu.

  6. Press Next at the bottom.

Deploy Add-in menu

  1. Select Upload custom apps.

  2. Select Choose File and find and open the manifest.xml file.

You can upload a manifest.xml file while it is located at {{baseUrl}}/excel-addin/manifest.xml

OR

You can use the option to provide the link to the manifest.xml, i.e., {{baseUrl}}/excel-addin/manifest.xml

Upload manifest options

  1. Assign Users to: Everyone | Specific users/groups | Just me

Assign users menu

  1. Press Deploy button at the bottom.

Excel users can now find and add the deployed Add-in

  1. Open the Excel application and open a sheet.

  2. Press the Add-ins button (rightmost button in the Home ribbon).

  3. Press the [+] More Add-ins button. Excel Add-ins tab

  4. Select the ADMIN MANAGED tab in the Office Add-ins dialog.

  5. Select the added MOPS Excel Add-in and press the Add button at the bottom. Excel admin managed pop-up

  6. The add-in should be added to the rightmost part of the Home ribbon.

  7. Pressing the newly added button in the ribbon opens the task pane of the added add-in.