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 - you get BLANK dropdown (no
Microsoft OLEDB Provider for OLAP Services or Microsoft
OLEDB Provider for OLAP Services 8.0). As a result, can
nort connect to OLAP cubes
Tried removing Office 97 & Office XP, installing OfficeXP
and 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!
To clarify:
Client computer having Windows XP SP1,
then installed Office 97 SR2,
then side-by side install of OfficeXP SP2
result - missing MIcrosoft OLEDB drivers in Excel Pivot for Excel XP
tried -
* installing PTSfull from SQL Server Analysis Services Service Pack 2,
* installing PTSfull from SQL Server Analysis Services Service Pack 3a
*uninstalling Office 97 and Office XP, installing Office XP, than PTSfull
Not an isolated incident - happens on all machines with similar
configuration.
the only solution so far is to reinstall Windows, than Office XP.
Need to get this to work without reinstall of Windows.
