[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Viewing an olap cube in excel

Posted on 2007-10-09
Medium Priority
Last Modified: 2013-11-16
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
Question by:Stanton_Roux
1 Comment

Accepted Solution

Marcel Hopman earned 2000 total points
ID: 20046780
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).

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question