I use about 20-25 Excel files which connect to OLAP server and retrieve information from the cubes. Since I have set auto refresh on file open for all these files it does the job and serves my purpose.
The problem I am facing :
I have changed my OLAP Server from Server A to Server B. How do I change all the connections in my Excel files to point to the new server. One way I have tried is to stop the old server and then when I open the Excel file it prompts for the new OLAP Server name. But as you can guess this approach is time consuming if I have to do this for so many sheets.
Is there an easier alternative? Any help on this will be highly appreciated...
The problem I am facing :
I have changed my OLAP Server from Server A to Server B. How do I change all the connections in my Excel files to point to the new server. One way I have tried is to stop the old server and then when I open the Excel file it prompts for the new OLAP Server name. But as you can guess this approach is time consuming if I have to do this for so many sheets.
Is there an easier alternative? Any help on this will be highly appreciated...