Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLAP/Excel 2000 Connection Problem HELP!

Status
Not open for further replies.

RobRock

Programmer
Oct 17, 2001
6
0
0
US
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 1. enter the name I want to give the Data Source, I find that nothing appears in the 2. "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. I have most recently tried to install the latest version of "mdac_typ.exe" on the user's machine and no success. This file cured the problem on another machine but not this one. If you have any suggestions, let me know. Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top