I used to be able to connect to Analysis Server from
Excel XP. However, since installing the AS Manager on my
workstation I can't connect. When I try to create a new
data source using Microsoft OLE DB Provider for OLAP
Serverices 8.0, nothing happens when I click on the
Connect button.

I've tried using Detect and Repair in Excel as suggested
in the KB, but this hasn't worked. I've also removed
Analysis Services from my workstation and reinstalled
Office XP, and this hasn't worked either.

Can anyone help?

Thanks

Edward

I would reinstall the Pivot table services first (PTSLite or PTSFull) , if
that didn't work, re-install the latest MDAC's.

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Edward Ramsden" <anonymous (AT) discussions (DOT) microsoft.com> wrote