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.
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.