Microsoft KB Archive/287079

= XL2000: Cannot See Cubes Created in SQL 2000 Server Analysis Services =

Article ID: 287079

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q287079



SYMPTOMS
When you create a PivotTable in Microsoft Excel 2000, when you attempt to specify an OLAP cube, you may not see the cube of data that you want to use in the Select the Cube that contains the data you want box.



CAUSE
This behavior occurs when both of the following conditions are true:
 * The database server uses On-Line Analytical Processing (OLAP) version 8.0.

-and-
 * Your computer does not have the OLAP 8.0 OLE database provider installed.

Microsoft Office 2000 installs the OLAP 7.0 OLE database provider; therefore, only the cubes that can be queried with the OLAP 7.0 provider are visible.



RESOLUTION
To show all cubes from an Analysis Services server, follow these steps to install an OLAP 8.0 provider:
 * 1) Insert the SQL Server 2000 CD-ROM in your CD-ROM drive. Click Exit to close the program that starts automatically.
 * 2) Browse to the folder  :\Msolap\Install\PTS.
 * 3) Do one of the following:

Double-click PTSLite to install PivotTable Service files only.

-or-

Double-click PTSFull.exe to install the PivotTable Service files and Microsoft Data Access Components (MDAC).
 * 1) Follow the prompts to complete the installation.



MORE INFORMATION
For additional information about OLAP versions, click the article number below to view the article in the Microsoft Knowledge Base:

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

Additional query words: XL2000

Keywords: kbprb kbpending KB287079

-

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

© Microsoft Corporation. All rights reserved.