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.
This is the first release of the add-in, and it will be updated with new features every quarter.
System Requirements
- A MicroStrategy 2019 Update 1 or later environment with Cross-Origin Resource Sharing (CORS) enabled. MicroStrategy for Office uses MicroStrategy Library. For steps, see How to Enable CORS Settings in MicroStrategy for Office Help.
- MicroStrategy Workstation 2019 Update 1 or later to generate the manifest file. See How to Generate the Manifest File Using Workstation in MicroStrategy for Office Help.
- MicroStrategy Library Server using the HTTPS protocol.
- MicroStrategy 2019 or later Intelligence Server.
- Microsoft Excel Online or Microsoft Excel 2016 (Retail) or later, supporting Office JS API 1.4 or later (preferably 1.12 to support all features).
- Windows 10 or macOS Mojave or High Sierra.
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 in Office 365 for all major browsers including Google Chrome, Mozilla Firefox, Safari and Microsoft Edge. It is recommended that you stay up-to-date on browser updates and upgrades to leverage capabilities and features added in each version.
MicroStrategy for Office also supports the desktop version of Excel on Mac and Windows.
The previous .NET MicroStrategy Office add-in using XML and Web Services is no longer actively developed by MicroStrategy. For documentation on the previous MicroStrategy Office add-in, see the MicroStrategy Office Guide.
Installing MicroStrategy for Office
For steps to install MicroStrategy for Office, see Installing MicroStrategy for Office.