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.
Bookmarks