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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Resolution

To show all cubes from an Analysis Services server, follow these steps to install an OLAP 8.0 provider:

Insert the SQL Server 2000 CD-ROM in your CD-ROM drive. Click Exit to close the program that starts automatically.
Browse to the folder CD-ROM drive:\Msolap\Install\PTS.
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).
Follow the prompts to complete the installation.

↑ Back to the top