Search & replace in formulae

I

Iain Rhodes

Is it possible to do a search and replace which includes
the cell formula contents ? I have a workbook that has
cells which link to the contents of a cell in another
workbook and I'd like to know if the naming has to remain
constant or if I can replace a part of the name
periodically. ie each year.

thanks
 
I

IC

Iain Rhodes said:
Is it possible to do a search and replace which includes
the cell formula contents ? I have a workbook that has
cells which link to the contents of a cell in another
workbook and I'd like to know if the naming has to remain
constant or if I can replace a part of the name
periodically. ie each year.

thanks
Click to expand...

In answer to the first part, yes you can search and replace on formalae.

In answer to the second part, as long as the links are valid (ie there's
something to link with), it shouldn't be a problem.

Ian
 
Top