+ Reply to Thread
Results 1 to 3 of 3

Pivot table - Changing OLAP Source

  1. #1
    Registered User
    Join Date
    03-06-2007
    Posts
    1

    Pivot table - Changing OLAP Source

    Hi all,

    We have an Analysis Server which is running on a computer with the name "xx". A couple of user have made several sheets with pivot tables which are connected on the server "xx". To make the connection, the chose OLAP source and it's working perfectly.

    The problem is that the server "xx" won't exist any more ant will be replace with the server "yy". Of course, all the pivot table won't work anymore.

    My question is the following : is there a possibility to change the server name in a pivot table which is based on an OLAP source ? I'have tried a couple of test but it didn't work.

    Thanks for your help.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Don't know much about OLAP.
    Could this link help?
    http://www.contextures.com/xlPivotPlay01.html#GenUse

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    It is only a function of your code ...
    Just make the server name a variable ...
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1