MicroStrategy ONE

MicroStrategy for Office

The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy.

The initial version of the add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. It supports Windows, Mac, and Office 365 Online versions of Office.

System Requirements

Excel

  • A MicroStrategy ONE/2021 Platform or newer environment with Cross-Origin Resource Sharing (CORS) enabled. MicroStrategy for Office uses MicroStrategy Library. For steps, see How to Enable CORS Settings.
  • MicroStrategy Workstation ONE/2021 Platform or newer to generate the manifest file. See How to Generate the Manifest File Using Workstation.
  • MicroStrategy Library server using the HTTPS protocol. You must have the appropriate certificate to use MicroStrategy Library with HTTPS protocol.
  • MicroStrategy ONE/2021 Platform or newer Intelligence server. You must have the same version of the Intelligence server and MicroStrategy Library.

  • The minimum Microsoft Excel API version is 1.12. Microsoft Excel API version 1.17 or newer is required to support all MicroStrategy for Office functionality. For more information, see Excel JavaScript API requirement sets and Required Microsoft API Version per Functionality.

  • The MicroStrategyLibrary/static folder must be accessible.

  • Desktop application for Microsoft Excel that supports the above mentioned Excel API version.

  • Microsoft Excel Online supported in Chrome, Edge, Firefox, and Safari.

  • Windows 10 or 11, macOS Sonoma (14) or Sequoia (15).

PowerPoint

  • MicroStrategy Workstation ONE Update 11 or newer to generate the manifest file. See How to Generate the Manifest File Using Workstation.

  • MicroStrategy Library server using the HTTPS protocol. You must have the appropriate certificate to use MicroStrategy Library with HTTPS protocol.

  • MicroStrategy ONE Update 11 or newer Intelligence server. You must have the same version of the Intelligence server and MicroStrategy Library.

  • The minimum Microsoft PowerPoint API version is 1.5. For more information, see PowerPoint JavaScript API requirement sets.

  • The MicroStrategyLibrary/static folder must be accessible.

  • Desktop application for Microsoft PowerPoint 365 that supports the above mentioned PowerPoint API version.

  • Windows 10 or 11, macOS Sonoma (14) or Sequoia (15).

Teams

  • A MicroStrategy ONE Update 12 or newer environment with Cross-Origin Resource Sharing (CORS) enabled. MicroStrategy Teams App uses MicroStrategy Library. For steps, see How to Enable CORS Settings.

  • MicroStrategy Workstation ONE Update 12 or newer to generate the manifest file. See How to Generate the Manifest File Using Workstation.

  • MicroStrategy Library server using the HTTPS protocol. You must have the appropriate certificate to use MicroStrategy Library with HTTPS protocol.

  • MicroStrategy ONE Update 12 or newer Intelligence server. You must have the same version of the Intelligence server and MicroStrategy Library.

  • Microsoft Teams Web supported in Chrome and Edge.

  • Windows 10 or 11, macOS Sonoma (14) or Sequoia (15)

For more information, such as supported applications and web browsers, see Prerequisites in MicroStrategy for Office Help.

For all certified systems, see Platform Certifications.

Compatibility and Interoperability

MicroStrategy for Office supports Excel and PowerPoint via add-ins and Microsoft Teams with a custom app built for your organization.

The MicroStrategy Excel add-in is supported in web for Chrome, Edge, Firefox, and Safari browsers, while the Teams app is supported in Chrome and Edge. MicroStrategy recommends staying current with browser updates and upgrades to leverage the capabilities and features added in each version.

MicroStrategy for Office also supports the desktop version of Excel, PowerPoint, and Teams on Mac and Windows.

The previous .NET MicroStrategy Office add-in using XML and Web Services is no longer actively developed by MicroStrategy.

Installing MicroStrategy for Office

For steps to install MicroStrategy for Office, see Installing MicroStrategy for Office.