Unanswered: Execel Pivot Table doesn't connect to Analysis Server
in Excel I select the 'Data' Tab ->Pivot Table and PivotChart Wizard. I then Select External data Souce and Pivot Table then click Next. I then click 'Get Data', OLAP Cubes 'New Data Source' and Click OK. I enter Name in Box one of Create New Data Source. In Box 2 I select Microsoft OLE DB Provider for
OLAP Services 8.0 an click Connect. In the Multidimensional Connection Window I select Analysis Server and enter my Server Name and click next. The error message I get is 'Unable to open connection. Cannot connect to the server 'Name'. The server is either not started or too busy. the thing is its my home computer and SQL Server 2000 is running but idle. I can't figure out what the problem is. I am running Excel 2002.