Configure MSOLAP data provider for Excel to connect to Analysis Services


To create a data connection to an Analysis Services data source, Microsoft Excel uses the Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server (MSOLAP). Each version of Analysis Services has its own MSOLAP provider version. The following table lists the Analysis Service versions and their corresponding MSOLAP provider version.

Analysis Services version

MSOLAP provider version

SQL Server 2008


SQL Server 2012


SQL Server 2014


SQL Server 2016


SQL Server 2017


For more information about how to use the correct version of MSOLAP, see How to obtain the latest versions of MSOLAP.

Excel uses the version of the MSOLAP provider that is installed on the client device. In the following example, Excel has configured MSOLAP.5 as the data provider in the data connection string.

Connection properties

On a client device that has multiple versions of the MSOLAP provider installed, Excel uses the version that's configured in the registry.

For example, in the following scenario:

  • You have MSOLAP.5 installed and configured in the registry.

  • You have installed MSOLAP.6 on your device to connect to Analysis Services 2014, but you have not updated the registry to reference MSOLAP.6.

Excel will configure the connection to use MSOLAP.5 in the connection string. This causes issues as you cannot use MSOLAP versions that are earlier than the data source version. 

More information

To specify the version of  MSOLAP that Excel uses, update the version in the registry keys. The following keys define which MSOLAP version Excel uses to connect to Analysis Services. The location of the registry key depends on whether Microsoft Office is an MSI or Click-to-Run (C2R) installation, and whether it's 32-bit or 64-bit.

Office 32-bit MSI


Office 64-bit MSI


Office 32-bit C2R




Office 64-bit C2R




The following is an example of Office 32-bit C2R configured to use MSOLAP.5:


To determine whether your installation is MSI or C2R, in Excel go to File > Account. If you see an Office Updates section, the installation is C2R:

C2R installation

If there's no Office Updates section, then it's an MSI installation:

MSI installation

To determine whether Excel is 32-bit or 64-bit, click About Excel in the same Accounts screen and it will show you in the dialog box at the top:

32-bit or 64-bit

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.