I create a Excel 2000 worksheet using Pivot Table to access a Analysis
Services 2000 Server.
I have to change the cubes from this server to another one.
But when I try to change the location of the cube in Pivot Table I can´t
finf where I can do that.
When I call the wizard again, instead of openning the first windows
where I can choose the server, the OLAP database and the cube, the
wizard opens the last windows where I can only choose the location of
the Pivot Table.
Where is the information of where Excel is accessing the cube?

Thanks,

Paulo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Paulo,
The datasource string is kept in an *.oqy file. They're usually found in
your Application Data directory under your documents and settings e.g.
C:\Documents and Settings\PaulI\Application Data\Microsoft\Queries
HTH,
Paul Ibison

Actually, the OLAP connection settings of an existing Excel pivot table
can't be changed by editing the .oqy files: such changes will apply when
creating a new pivot table.

The connection string is held in the pivotcaches.connection of the
workbook, so it can be updated via VBA scripts.

This earlier post presents some of the options:

http://groups.google.com/groups?hl=e...43db9d.0309120
121.2918293b%40posting.google.com
Subject: Re: Excel external data source, how do I change it
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2003-09-12 02:21:54 PST

see my previous post regarding "Excel Connection Properties"

There are three ways I can think off:

# brute force - disconnect your computer from the network and try to
update the data in the pivot table, XL will let you change the server
since it cannot find find it

# Modify the .oqy connection file created by XL in Notepad. It should
be located in c:\Documents and Settings\<user name>\Application
Data\Microsoft\Queries

# I put together an XL add-in that enables you (besides some other
things) to change the connection string easily and userfriendly. If
you provide me with your e-mail address I'll send it to you.

(There's supposed to be another way by saving the sheet in XML-format,
I never tried it because of solution # 3)

Thomas

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!