XL2000: "Couldn't open the OLAP Cube Wizard." Error Starting OLAP Cube Wizard

• Microsoft Excel 2000
• Microsoft Office 2000 Small Business

SYMPTOMS

When you click Create OLAP Cube on the File menu in Microsoft Query, or you click Create an OLAP Cube from this query in the Query Wizard - Finish dialog box, you receive the following error message:

Couldn't open the OLAP Cube Wizard.

CAUSE

This problem occurs when you have installed Microsoft Excel 2000 by installing one of the following programs:

• Microsoft Excel 2000 (stand-alone version)
• Microsoft Office 2000 Small Business

RESOLUTION

To work around this problem, follow these steps:

1. Insert the CD-ROM that you used to install Excel 2000 (Excel stand-alone version or Office 2000 Small Business) into your CD-ROM drive.



2. Copy the following file from the \Pfiles\Msoffice\Office folder on your CD-ROM to the C:\Program Files\Microsoft Office\Office folder on your hard disk:




Msowcw.dll

3. Copy the following file from the \Pfiles\Msoffice\Office\1033 folder on your CD-ROM to the C:\Program Files\Microsoft Office\Office\1033 folder on your hard disk:




Msowcwi.dll

4. Click Start, and then click Run. Type Regsvr32 "C:\program files\microsoft office\office\msowcw.dll" and then click OK.
   
   Click OK in the message indicating that the operation succeeded.
   
   NOTE: If you receive an error message indicating that Regsvr32.exe was not found, then you need to download and install Regsvr32.exe. For additional information about obtaining Regsvr32.exe, please see the following article in the Microsoft Knowledge Base:




Q161983 ACC: Regsv32a.exe Available on MSL

5. Click Start, and then click Run. Type Regsvr32 "C:\program files\microsoft office\office\1033\msowcwi.dll" and then click OK.
   
   Click OK in the message indicating that the operation succeeded.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: OFF2000 XL2000 sbe

Keywords : kbdta xlquery
Version : WINDOWS:2000; :
Platform : WINDOWS
Issue type : kbbug