OLAP/Excel 2000 Connection Problem

[Guest_imported]

When using the PivotTable and PivotChart Wizard, I can go through the steps that
lead to "Choose Data Source" fine. When I click on "OLAP Cubes", choose "New Data Source" and enter the name I want to give the Data Source, I find that nothing appears in the "Select an OLAP Provider for the database you want to access:" drop down menu. The "Microsoft OLE DB Provider for OLAP Services" does not appear like it does on other user's machines. If you have any suggestions, let me know.
Thanks in advance.

 

[Maltus]

Hi Robert.

Did you already install the ADO package in the machine you're trying to use the pivot table service? Sometimes this could be the problem. So if you already had installed it, try again with a newer version.

Hoping that this could help, Wagner