Is there a way to change the excel connection properties
to an OLAP cube without creating separate excel sheets per
server?
I have a few OLAP databases, with the same cubes just
different data, and I want to only create one excel file
per cube but for my super users I want them to be able to
switch to different servers using that one excel sheet.

Thanks
-Hutch

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 porvide me with your e-mail address (guess hutch (AT) nospam (DOT) com won't
work) 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


"hutch" <hutch (AT) nospam (DOT) com> wrote