HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\CLSID\\ProgID\(Default)
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. The following keys define which MSOLAP version Excel uses to connect to Analysis Services.
DATA ANALYSIS EXCEL MAC 2008 UPDATE
To specify the version of MSOLAP that Excel uses, update the version in the registry keys. This causes issues as you cannot use MSOLAP versions that are earlier than the data source version. 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.Įxcel will configure the connection to use MSOLAP.5 in the connection string.You have MSOLAP.5 installed and configured in the registry.On a client device that has multiple versions of the MSOLAP provider installed, Excel uses the version that's configured in the registry. In the following example, Excel has configured MSOLAP.5 as the data provider in the data connection string. For latest MSOLAP version, please refer to Analysis Services client libraries.Įxcel uses the version of the MSOLAP provider that is installed on the client device.
DATA ANALYSIS EXCEL MAC 2008 HOW TO
For legacy MSOLAP versions, please refer to How to obtain the latest versions of MSOLAP. Analysis Services versionįor more information about MSOLAP and other client libraries for Analysis Services, review Analysis Services client libraries.įor more information about how to use the correct version of MSOLAP, see Connection string properties. The following table lists the Analysis Service versions and their corresponding MSOLAP provider version. Each version of Analysis Services has its own MSOLAP provider version. 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). Original product version: SQL Server 2017 Enterprise, SQL Server 2016 Enterprise, SQL Server 2014 Enterprise, SQL Server 2012 Enterprise, SQL Server 2008 Enterprise Original KB number: 4488253 Summary This article describes how to configure the correct MSOLAP data provider for Excel to connect to Analysis Services.
0 kommentar(er)
