Microsoft KB Archive/303438

= PRB: Unable to See All Cubes When Connecting from Excel 2000 to Analysis Services =

Article ID: 303438

Article Last Modified on 2/19/2007

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q303438



SYMPTOMS
On a client computer with Microsoft Office 2000 installed, when creating a pivot table in Microsoft Excel 2000 and connecting to a Analysis Services server, only a subset (or even none) of the cubes are visible in the Select the Cube that contains the data you want box.



CAUSE
Because Office 2000 installs the OLAP 7.0 OLE DB provider, only the cubes that can be queried with the OLAP 7.0 provider are visible.



WORKAROUND
To show all cubes from an Analysis Services server, you need to use the OLAP 8.0 provider. To work around this problem, obtain a copy of the SQL Server 2000 installation CD, browse to the Msolap\Install\PTS folder, and run PTSLite.exe.

NOTE: PTSLite.exe installs the PivotTable Service files only, and PTSFull.exe installs the PivotTable Service files and Microsoft Data Access Components (MDAC).

Additional query words: OLAP PivotTable Office

Keywords: kbprb KB303438

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.