Unanswered: Server Name/Cube Name Changes and Excel
We have a large user community that have created a number of MS EXCEL spreadsheets using MS OLAP Cubes as their input. Every month, once the cubes have been updated, the users can "refresh" their spreadsheets. These spreadsheets range from simple to complex, depending on the user's skill set and task to be performed.
Here is the problem... We are in the process of moving the cubes to a new server and the cube names are changing due to new Naming Standards. What can we do to minimize the impact to our user community?