Hi,

I have done a lot a work on an Excel spreadsheet which contains several
pivotal table and charts. The hard work of formatting is done. The pivotal
table is connected to the Analysis Server. Now, the cube is relocated to
another server. Is there any way to change the connection to the new sever
instead of having to re-edit the whole?

Thanks

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



"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote