Linked Workbooks

[Judy]

Is there an easy way to change an absolute cell reference
that is linked another workbook. How can you do a global
change? For example I have store locations linked to
another workbook and need to change the order of the store
locations in both worksheets. I want to avoid doing this
manually.

Thanks for any help you can give me.

 

[Frank Kabel]

Hi Judy
I would try to use 'Edit - Replace' for this