MicroStrategy ONE

Install Manually

If you want to test the MicroStrategy for Office add-in, there is an option to install it manually as an individual user.

In Microsoft's terminology, this is called sideloading, and is not recommended for regular use but for testing and developing add-ins.

To install MicroStrategy for Office, you need an XML manifest file.

You can get a manifest file from your MicroStrategy administrator or generate it in Workstation.

  • Office Web
  • Windows
  • Mac
  1. Open Microsoft Office on the web.
  2. Choose Excel and open a workbook.
  3. Go to Insert > Office Add-ins.
  4. In the Office Add-ins dialog, click Upload My Add-in.
  5. In the Upload Add-in dialog, click Browse and locate your add-in manifest file.

  6. Click Upload. The MicroStrategy for Office add-in appears in the ribbon.

Share Your Folder Catalog

  1. On your Windows computer, open File Explorer.
  2. Go to the folder containing your manifest file and right-click > Properties.
  3. Go to the Sharing tab and click Share.
  4. In the Network access dialog, add yourself and other appropriate users and groups.
  5. Click Share.

  6. Make note of the full network path of your shared folder. This will be used to specify the shared folder as a trusted catalog. Click Done.

Configure the Trust of Your Shared Folder

  1. Open a workbook in Microsoft Excel.
  2. Go to File > Options.
  3. In the Excel Options dialog, go to Trust Center > Trust Center Settings.
  4. In the Trust Center dialog, go to Trusted Add-in Catalogs.
  5. In the Catalog URL field, enter the full network path of your shared folder.
  6. Click Add catalog.
  7. Select the Show in Menu checkbox for your trusted catalog address.
  8. Click OK.
  9. In The Manage Add-in Catalogs dialog, click OK.
  10. Close and reopen Microsoft Excel.
  11. Open a workbook.
  12. Go to Insert > My Add-ins > Shared folder > MicroStrategy. The MicroStrategy for Office add-in appears in the ribbon.

The instructions below have been adapted from Microsoft Docs: Sideload an add-in in Office on Mac. iPhones and iPads are not supported.

See the general prerequisites for Office on Mac in Microsoft Docs: Prerequisites for Office on Mac.

  1. Open Finder.
  2. Navigate to Users/<username>/Library/Containers/com.Microsoft.Excel/Data/Documents/Wef.

  3. If the wef folder doesn't exist on your computer, create it manually.

  4. Copy the MicroStrategy for Office manifest file to the wef folder.

  5. Close and reopen Microsoft Excel.
  6. Open a workbook.

  7. Go to Insert and in the My Add-ins drop-down, choose MicroStrategy for Office.

    My Add-ins in Office on Mac

    Sideloaded add‑ins only appear within the My Add‑ins drop‑down menu.

  8. Verify that MicroStrategy for Office appears in Excel.

    My Add-ins in Office on Mac

    1. Open Finder.

    2. Navigate to Users/<username>/Library/Containers/com.Microsoft.Excel/Data/Documents/Wef.

    3. Delete the MicroStrategy for Office manifest file.

    4. Close and reopen Microsoft Excel.