• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1935
  • Last Modified:

Viewing an olap cube in excel

Hi There

I am trying to import external data in Excel from a OLAP cube.
I try and conect to the datasource and I keep getting a Unable to locate server error.

Is there anything that needs to be installed or configured on the server to allow this connection.
I am using SQL 2000 standard edition SQL 2000 analysis server.Office 2002 and windows server 2003
1 Solution
Marcel HopmanCommented:
You must have the PTS (Pivot Table Services) installed on your client PC (you can find the PTS on your SQL Server 2000 CD). The correct version of MDAC is also a requirement (min. 2.6 or 2.7).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now