新聞財經娛樂♬資訊 News Economy

If I have three tabs called
1- Arrow
2- Bench
3- Circle
In each of these tabs I use connections called
1- IE.MV.COM IE Arrow
2- IE.MV.COM IE Bench
3- IE.MV.COM IE Circle
In each connection the connection string has an IP address 21x.5x.x3.1xx
I need to change all three connection IP address from 21x.5x.x3.1xx to IE.MV.COM
Is there a way to change all three connection files with out having to modify each file separately??

In the find/replace [Ctrl + h] window you can click on [Options] and then change the [Within] selection to [Workbook].  Then the find/replace will happen on all spreadsheet tabs.

It might work if  each separate file has Cell to store the IP location which is

stored in one workbook of three workbooks and a separate new workbook

For example you put cells as

="[otherworkcallIP.xls]sheet1!a1"

Every times, all three workbooks will call the same location of the IP

Duncan