Change Cube-Name in Excel Sheets

[rks1]

Hi Community!

We have been moving our files to another server with another name (for tests at the moment). Included are more than 100 Excel-Sheets.
Each has several thousand formulas referencing the cube in a DBRW formula (=DBRW(server:cube,....).
Is there a way to avoid opening each file and replace each formula manually (or by clicking strg+F)? If not, maybe there's a solution to implement in the future by another reference saved in a config on the server or a config excel sheet?

Thank you very much for your help and best regards,
Konstantin

[Paul Segal]

Something like this could help: http://www.ozgrid.com/Services/excel-find-replace.htm

[lotsaram]

Or you could use this.

TM1_Reference_Updater.xlsm

(35.4 KiB) Downloaded 503 times

Will also change references to servers in action buttons and very useful if changing cube, dimension or element names for whatever reason. (Note that the code assumes worksheets are not protected.)

However if it is just a case of server migration in a DQP setup I believe this technique is the best option as it avoids any need for find/replace whether automated or not.

[rks1]

lotsaram, that's a wonderfool little tool.
Paul, thank you, too

Solved!