Search & replace in formulae

[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

 

[IC]

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

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