Highlight the whole sheet by clicking on the box which intersects the
row and column labels, and then do Find and replace (CTRL-H):

Find what: [2005.xls]AA340
Replace with: [1995.xls]AB623
click replace all

Hope this helps.

Pete

On Sep 3, 12:22*am, Darius wrote:
I have several sheets in a file and cells in the sheets read data from
different other excel files. In some cells in each sheet (hard to find one by
one) the address is for example:

='D:\Gaines\Sourcefiles\Wet\Result\[2005.xls]AA340501'!E6

I want to change the address to:

='D:\Gaines\Sourcefiles\Wet\Result\[1995.xls]AB623501'!E6

I have to add that I have data in different cells not just E6. Instead of
cell by cell how can change the address (like above example) for the whole
sheet?

Appreciate your help