Excel pivot tbl - missing olap drivers

I

Ilona

Brand new laptop w/Windows XP. Has Office 97 installed
(first), than complete install of Office XP(second). Than
install of PTSfull.exe (pivot table services that come w/
sql server analysis services service pack 2).

Go to data manu - PivotTable and Pivot Chart report -
External data source/Pivot table - Get Data - OLAP cubes -
new data source - select an olap provider for the
database you want to access - blank dropdown (no
Microsoft OLEDB Provider for OLAP Services or Microsoft
OLEDB Provider for OLAP Services 8.0).

Tried removing Office 97 & Office XP than installing PTS -
same result. The only way to get it was to completely
reinstall Windows, than Office XP. This is not an option
for all the computers that needaccess to OLAP cubes.
Please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing OLEDB drivers in Excel 2000 (9.0.28.12) 1
Alternatives to MS Query for Pivot Tables & Cubes 0
no oledb drivers when using excel pivot 0
olap data cube 0
suppress warning and locate cube in a pivot table from olap cube 0
Pivot Table accessing data from OLAP cube 0
EXCEL: OLE DB provider for OLAP Services 8.0 Missing 2
OLE DB OLAP Service 0

Top